Excel output showing blank rows when there is no data

[sameena]

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

[sunny bachan prasad]

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

[bdbits]

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.

[Lynn]

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

Sage advice!!  ;D ;D ;D