Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    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 12:19 Go to next message
Elena M is currently offline Elena MFriend
Messages: 12
Registered: January 2013
Junior Member
index.php/fa/13462/0/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 199 times)
  • Attachment: crosstab.JPG
    (Size: 32.54KB, Downloaded 1066 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 Go to previous messageGo to next message
Eclipse GuestFriend
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 Go to previous messageGo to next message
Elena M is currently offline Elena MFriend
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 1012 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 Go to previous messageGo to next message
Elena M is currently offline Elena MFriend
Messages: 12
Registered: January 2013
Junior Member
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 15:55 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
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
Re: cross tab - days of month [message #1014571 is a reply to message #1014334] Tue, 26 February 2013 04:21 Go to previous messageGo to next message
Elena M is currently offline Elena MFriend
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
Re: cross tab - days of month [message #1014930 is a reply to message #1014571] Tue, 26 February 2013 20:59 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
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
Previous Topic:How to give each table in the report a name
Next Topic:Language of Report Labels
Goto Forum:
  


Current Time: Wed Feb 01 13:26:22 GMT 2023

Powered by FUDForum. Page generated in 0.18779 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top