Eclipse Community Forums: BIRT » cross tab

Help

Home

Home » Eclipse Projects » BIRT » cross tab - days of month(how to show days-colomns with null datas)

Show: Today's Messages :: Show Polls :: Message Navigator

cross tab - days of month [message #1010886]

Mon, 18 February 2013 07:19

Elena M
Messages: 11
Registered: January 2013

Junior Member

Hello!
I have a cross tab with some datas
and I need to show it for days for a month
can I make some settings in birt to show coloms of day where no datas?

in example for a days 1-16 october 2012
(I need that this days must be in a report with null datas)

thank you!

Attachment: crosstab.JPG
(Size: 33.95KB, Downloaded 17 times)
Attachment: crosstab.JPG
(Size: 32.54KB, Downloaded 124 times)

[Updated on: Mon, 18 February 2013 07:22]

Report message to a moderator

Re: cross tab - days of month [message #1010919 is a reply to message #1010886]

Mon, 18 February 2013 08:36

Jakob Altenstein
Messages: 19
Registered: February 2013

Junior Member

Hi,

select the crosstab, then in Property Editor -> Properties, choose the "Empty Rows/Columns" tab, activate "Show empty columns" and select the "Days of Month" entry.

In case you want, put something in the "For empty cells, show:" box to display 0 or so in those cells.

Regards, Jakob

[Updated on: Mon, 18 February 2013 08:38]

Report message to a moderator

Re: cross tab - days of month [message #1011210 is a reply to message #1010919]

Mon, 18 February 2013 23:30

Elena M
Messages: 11
Registered: January 2013

Junior Member

Thank you for anser!
but there are no posibility to choose this properties - show empty colomns
- it is not available
?

index.php/fa/13469/0/

Attachment: crosstab2.JPG
(Size: 62.59KB, Downloaded 101 times)

[Updated on: Tue, 19 February 2013 03:28]

Report message to a moderator

Re: cross tab - days of month [message #1014173 is a reply to message #1011210]

Mon, 25 February 2013 04:48

Elena M
Messages: 11
Registered: January 2013

Junior Member

it meens, that birt d'not have the possibility to show empty colomns

Report message to a moderator

Re: cross tab - days of month [message #1014334 is a reply to message #1014173]

Mon, 25 February 2013 10:55

Michael Williams
Messages: 808
Registered: July 2009

Senior Member

The dates must be present in your dataSet to show them. The best way to handle this would be to create a scripted dataSet that creates a row for each date within your report's date range, then join this dataSet with your actual data, to make sure each date is represented.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: cross tab - days of month [message #1014571 is a reply to message #1014334]

Mon, 25 February 2013 23:21

Elena M
Messages: 11
Registered: January 2013

Junior Member

yes, it is that I do now - with additional sql statement (with additional sql table),
but I hope if birt can do it faster and more easy.
thank you

Report message to a moderator

Re: cross tab - days of month [message #1014930 is a reply to message #1014571]

Tue, 26 February 2013 15:59

Michael Williams
Messages: 808
Registered: July 2009

Senior Member

I would guess if you're able to do this all within your query, it's faster than using a scripted dataSet and a join within BIRT, but I could be wrong. Let me know what you see when you try it. Let me know if you have questions on how to create such a scripted dataSet.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:	How to give each table in the report a name
Next Topic:	Birt Chart Engine Api - set y-axis labels

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 15:50:15 EDT 2013