Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Problem with Empty Rows
Problem with Empty Rows [message #693434] Wed, 06 July 2011 13:21 Go to next message
vijay kumar is currently offline vijay kumarFriend
Messages: 26
Registered: October 2010
Junior Member
Hi,

I am using cross tab to display my result. my resilt returns 6 rows. in that one row is having value for for one field and remaing fileds are null. I have attached the screen shots of what am i doing.

some one help me. thank you in advance

Thank you
vijay Kumar Bolisetti
Re: Problem with Empty Rows [message #693704 is a reply to message #693434] Thu, 07 July 2011 02:37 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Is account year nested in the cube design? If so can you set it as a
dimension on its own?

Jason

On 7/6/2011 9:21 AM, vijay kumar wrote:
> Hi,
>
> I am using cross tab to display my result. my resilt returns 6 rows. in that one row is having value for for one field and remaing fileds are null. I have attached the screen shots of what am i doing.
>
> some one help me. thank you in advance
>
> Thank you
> vijay Kumar Bolisetti
>
Re: Problem with Empty Rows [message #693709 is a reply to message #693704] Thu, 07 July 2011 03:51 Go to previous messageGo to next message
vijay kumar is currently offline vijay kumarFriend
Messages: 26
Registered: October 2010
Junior Member
Thanks Json,

I have done that purposefully so that i can display for each year values in Pivot style. i have observed one thing either any one value for coumn or row it is diaplying.

one way i thought is to place the dummy scope value.

Thank you
Re: Problem with Empty Rows [message #695864 is a reply to message #693709] Tue, 12 July 2011 17:06 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1687
Registered: July 2009
Senior Member

What do you want your output to look like? If you have a value in one column of a row, but not for the others, it's going to be blank. If you don't want it to just be blank, then in the text box in the 4th screenshot in your DOC file, put what you want it to show when there are "null" values.

Regards,

Michael

BIRT Evangelist on
http://www.birt-exchange.org


Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Multiple questions on BIRT engine
Next Topic:Unwanted page breaks in PDF output
Goto Forum:
  


Current Time: Sun Dec 21 16:34:08 GMT 2014

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

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