I'm using CR9 and have created a report based on the services.I did a topN grouping based on my top 5 services and grouped the rest as Other. I then created a cross-tab per group as well as a graph based on the cross-tab.The top 5 services show accordingly with their graphs but Other does not print, it just comes out blank but the name is there showing that there should be a crosstab and a graph accompying the name. Does anyone know what could be the problem. The whole report is working fine except for this minor problem.
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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TopN Grouping
- Thread starter Joy1
- Start date
What is your row or column field in the crosstab? Try replacing it with a formula like:
if groupnumber > 5 then {table.rowfield} else
if groupnumber <= 5 then {table.rowfield}
This doesn't make much sense, but it did force the crosstab appear for the Others group when I tested it. Worked for forcing the chart, too.
-LB
if groupnumber > 5 then {table.rowfield} else
if groupnumber <= 5 then {table.rowfield}
This doesn't make much sense, but it did force the crosstab appear for the Others group when I tested it. Worked for forcing the chart, too.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question