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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Report not returning entire data
Hi I have a situation in which the report output is showing 35K rows of data which is incorrect. However when i execute the cognos sql (generated from the report studio report) against the db I'm getiing around 3 million rows, which is in tune with the expected result. Can anyone please let...- ranjani06
- Thread
- Replies: 0
- Forum: Cognos solutions
-
Crosstab prompt on drill down report
Hi, I have a nested crosstab with years as columns. I have tree prompt on the report page for year. My data source is a cube. My requirement is that when i select a particular level in the prompt, the report columns should directly show data at that level. For eg, if i select month in the...- ranjani06
- Thread
- Replies: 0
- Forum: Cognos solutions
-
Crosstab calculation and hiding empty rows
Hi I have a crosstab column in my report that calculates the % of the two nested columns in the crosstab at the end under totals column. It works fine. But I have a requirement wherein I have to supress rows with zeros. When I give a filter saying [measure]>0, it works but my percentage column...- ranjani06
- Thread
- Replies: 5
- Forum: Cognos solutions
