Eclipse Community Forums: BIRT » cross tab

Home

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

cross tab - days of month [message #1010886]

Mon, 18 February 2013 07:19

Eclipse User

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 251 times)
Attachment: crosstab.JPG
(Size: 32.54KB, Downloaded 1260 times)

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

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

Mon, 18 February 2013 08:36

Eclipse Guest

Messages: 93
Registered: February 2013
Location: Vienna

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] by Moderator

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

Mon, 18 February 2013 23:30

Eclipse User

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 1215 times)

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

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

Mon, 25 February 2013 04:48

Eclipse User

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

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

Mon, 25 February 2013 10:55

Eclipse User

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.

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

Mon, 25 February 2013 23:21

Eclipse User

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

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

Tue, 26 February 2013 15:59

Eclipse User

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.

Previous Topic:	How to give each table in the report a name
Next Topic:	Language of Report Labels

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Apr 15 06:07:24 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter