Eclipse Community Forums: BIRT » Problem with Empty Rows

Help

Home

Home » Eclipse Projects » BIRT » Problem with Empty Rows

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

Problem with Empty Rows [message #693434]

Wed, 06 July 2011 09:21

vijay kumar
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

Attachment: Empty Row Problem..doc
(Size: 88.00KB, Downloaded 24 times)

Report message to a moderator

Re: Problem with Empty Rows [message #693704 is a reply to message #693434]

Wed, 06 July 2011 22:37

Jason Weathersby
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
>

Jason Weathersby

BIRT Exchange

Report message to a moderator

Re: Problem with Empty Rows [message #693709 is a reply to message #693704]

Wed, 06 July 2011 23:51

vijay kumar
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

Report message to a moderator

Re: Problem with Empty Rows [message #695864 is a reply to message #693709]

Tue, 12 July 2011 13:06

Michael Williams
Messages: 802
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

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:	Multiple questions on BIRT engine
Next Topic:	Unwanted page breaks in PDF output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 07:09:44 EDT 2013