Eclipse Community Forums: BIRT » cross tab

Help

Home

Home » Archived » 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 12:19

Elena M

Messages: 12
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 215 times)
Attachment: crosstab.JPG
(Size: 32.54KB, Downloaded 1178 times)

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

Report message to a moderator

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

Mon, 18 February 2013 13: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 13:38] by Moderator

Report message to a moderator

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

Tue, 19 February 2013 04:30

Elena M

Messages: 12
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 1130 times)

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

Report message to a moderator

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

Mon, 25 February 2013 09:48

Elena M

Messages: 12
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 15:55

Michael Williams

Messages: 1925
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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Tue, 26 February 2013 04:21

Elena M

Messages: 12
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 20:59

Michael Williams

Messages: 1925
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.

Michael

Developer Evangelist, Silanis

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 15:27:27 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter