Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to hide the row ?

Status
Not open for further replies.

Cog8i

IS-IT--Management
Oct 12, 2006
13
CA
Hi,
I'm working on crosstab reports in cognos 8. Is there any one who can help me that how to hide the row in cross tab if it is showing 0 record and how can i show these rows in the bottom of the report.

 
Piece of cake - If using cog8 then Analysis Studio may be an option (and assuming you have dimensional model defined and published?) fire AS up and use the built in zero-suppression options from either 13th icon or menu Settings-->Suppress -->'Total is Null or Zero' and 'Apply to Rows Only'.
Prototype and finalize the look and feel then export to Report Studio. This is a File menu option from AS if you have the tool and author permissions.
Run it in RS. Still zero suppressed. Look at the query subject wizardry!
Pretty difficult to maintain custom changes using this approach directly in Report Studio however...lots of objects
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top