Using CR9 Developer edition with Sp3
reporting from an obscure flat file system on UNIX.
I have a fairly complex report using multiple linked tables containing 4 levels of grouping and 8 linked subreports to show different views and calculations of the same basic data.
The reason I have to use so many sub reports is because the main report data needs to be sorted in a specific order to use previous() and next functions() to calculate specifiic values (basically poor database design).
my problem occurs when trying to use a crosstab on the summary page of the report GF1
The details of the crosstab display correctly but the totals don't match the detail records i.e.
PrintQty as Columns
Material Type as rows
Material Price as summarised fields (calculated Field)
I can't think why the detail lines and row totals should be correct and column totals incorrect.
I have checked the data being returned from the db in the details section of the report and that matches the details displayed in the cross tab.
I haven't shown the Material Price formula simply because the results returned in the main report are correct and it relies on a number of other if - then - else calculations for it's result.
Any one any ideas.
Secondly
My work around for this was to create a linked subreport in GF1 containing the crosstab and display that instead.
The sub report works fine and the correct data results and totals are displayed when the sub report is run stand alone. But when refreshed from the main report something strange happens.
The sub report contains the 2 data fields used to link the sub to the main report and the crosstab in RH no details or grouping required.
When the main report is refreshed the sub report fires once for each of the 5 records in Group 1 and the data fields are displayed correctly for each group 1 to 5 but the crosstab results displayed are always the results of Group 1 on the main report.
As a check I also added the data fields used in the crosstab into the details section of the subreport to see what was coming from the database, and this displayed the correct data for each group.
It's as though the sub report is running correctly but somehow the crosstab is not.
Any thoughts
Gary Parker
MIS Data Analyst
Manchester, England
reporting from an obscure flat file system on UNIX.
I have a fairly complex report using multiple linked tables containing 4 levels of grouping and 8 linked subreports to show different views and calculations of the same basic data.
The reason I have to use so many sub reports is because the main report data needs to be sorted in a specific order to use previous() and next functions() to calculate specifiic values (basically poor database design).
my problem occurs when trying to use a crosstab on the summary page of the report GF1
The details of the crosstab display correctly but the totals don't match the detail records i.e.
PrintQty as Columns
Material Type as rows
Material Price as summarised fields (calculated Field)
Code:
10,000 30,0000 Total
CON STOCK 31.55 31.55 63.10
OUTWORK 491.20 878.26 1369.46
SHT INK 34.66 100.19 134.85
STOCK 203.93 553.53 757.46
TOTAL [b] 837.96[/b] [b]1794.63[/b] 2324.87
[b]characters in bold are imcorrect[/b]I can't think why the detail lines and row totals should be correct and column totals incorrect.
I have checked the data being returned from the db in the details section of the report and that matches the details displayed in the cross tab.
I haven't shown the Material Price formula simply because the results returned in the main report are correct and it relies on a number of other if - then - else calculations for it's result.
Any one any ideas.
Secondly
My work around for this was to create a linked subreport in GF1 containing the crosstab and display that instead.
The sub report works fine and the correct data results and totals are displayed when the sub report is run stand alone. But when refreshed from the main report something strange happens.
The sub report contains the 2 data fields used to link the sub to the main report and the crosstab in RH no details or grouping required.
When the main report is refreshed the sub report fires once for each of the 5 records in Group 1 and the data fields are displayed correctly for each group 1 to 5 but the crosstab results displayed are always the results of Group 1 on the main report.
As a check I also added the data fields used in the crosstab into the details section of the subreport to see what was coming from the database, and this displayed the correct data for each group.
It's as though the sub report is running correctly but somehow the crosstab is not.
Any thoughts
Gary Parker
MIS Data Analyst
Manchester, England