jenschmidt
Programmer
I hope this is an easy question because I can't figure out what in the world is going on with this report!
My report has five groups. For all five groups, we have implemented "flexible grouping" using parameters and formulas - the end user can pick what the groups should be at run time. They can use only some of the groups if desired and the other groups return "No Group Selected".
In groups one and two, I have inserted crosstabs, both formatted the same way:
Rows: {@Parameter # 1} (or #2)
Columns: POST_PERIOD
Sum'ed fields: CHARGES, TOTAL_CANC, TOTAL_PMT
Also in groups one and two, I have a chart above each crosstab that graphs the same data shown in the crosstab.
Groups 2 thru 5 are hidden for drill down.
When I run the report, group 1 crosstab and chart look great. When I drill down on group 1, the first page of group 2 looks great. But, the second page of group 2 is just a repeat of page one, then page three is new, page four is a repeat of page three and so on all the way through all group 2's.
The group tree generates correctly - it prints each group 2 only once, as I would have expected the pages to be as well. I have looked into the section expert, any formulas etc and cannot find one clue to help me figure out what's going on.
Any suggestions?
Working on Crystal 9.0, connecting thru ODBC to Oracle tables.
jennifer.giemza@uwmf.wisc.edu
My report has five groups. For all five groups, we have implemented "flexible grouping" using parameters and formulas - the end user can pick what the groups should be at run time. They can use only some of the groups if desired and the other groups return "No Group Selected".
In groups one and two, I have inserted crosstabs, both formatted the same way:
Rows: {@Parameter # 1} (or #2)
Columns: POST_PERIOD
Sum'ed fields: CHARGES, TOTAL_CANC, TOTAL_PMT
Also in groups one and two, I have a chart above each crosstab that graphs the same data shown in the crosstab.
Groups 2 thru 5 are hidden for drill down.
When I run the report, group 1 crosstab and chart look great. When I drill down on group 1, the first page of group 2 looks great. But, the second page of group 2 is just a repeat of page one, then page three is new, page four is a repeat of page three and so on all the way through all group 2's.
The group tree generates correctly - it prints each group 2 only once, as I would have expected the pages to be as well. I have looked into the section expert, any formulas etc and cannot find one clue to help me figure out what's going on.
Any suggestions?
Working on Crystal 9.0, connecting thru ODBC to Oracle tables.
jennifer.giemza@uwmf.wisc.edu