Print Page - Excel output showing blank rows when there is no data

Title: Excel output showing blank rows when there is no data
Post by: sameena on 30 Jul 2014 05:24:54 AM

Hi Gurus,
I have a report with 5 lists. When i run the report selecting my prompt parameters, my excel output shows blank rows if my list does'nt have any data. please let me know on how to avoid blank rows in my report.
I am working on Cognos 10. Is there anything I can do with the 'No data contents' tab.

Thanks,
Sam

Title: Re: Excel output showing blank rows when there is no data
Post by: sunny bachan prasad on 02 Aug 2014 01:22:35 PM

Hi Sam,
have you got the solution of this problem???I am facing the same problem in cognos report studio :(

Title: Re: Excel output showing blank rows when there is no data
Post by: bdbits on 04 Aug 2014 11:57:52 AM

To avoid blank rows, make sure they will always have data. ;D

What do you want it to do? If you set the 'No Data Contents' propery to 'Content specified in the No data tab', and you have no data, whatever you have in the layout on the 'No data tab' is what will be rendered. Give it a try.

Title: Re: Excel output showing blank rows when there is no data
Post by: Lynn on 04 Aug 2014 12:00:33 PM

Quote from: bdbits on 04 Aug 2014 11:57:52 AM
To avoid blank rows, make sure they will always have data. ;D

Sage advice!! ;D ;D ;D

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sameena on 30 Jul 2014 05:24:54 AM