Missing data in report
Wickey
Amsterdam, Netherlands
Hi there,
I have a problem when viewing/printing a report. The report have the following structure:
1: Report Title: empty
2: Page Header: Contains fields for general customer info such as Name, address etc.
3: Group Header: Condition=CustomerId
4: Data: CustomerDataSource: Contains fields for purchases and prices
5: Group Footer: Contains fields for Totals
6: Page Footer: Contains PageNofM field
The data source contains data rows containing all the customer info (CustomerId, name, address, purchases, prices etc.) per row.
f.ex:
100, CuName1, CuAddress1, Product1, Price1 ...
100, CuName1, CuAddress1, Product2, Price2 ...
101, CuName2, CuAddress2, Product3, Price3 ...
101, CuName2, CuAddress2, Product4, Price4 ...
...
The data is grouped by CustomerId.
The wanted result should be something like this:
page 1
CuName1, <= this is missing on the 1st report page
CuAddress1 <= this is missing on the 1st report page
page 2
CuName2,
CuAddress2
The problem is that the customer info CuName1 and CuAddress1 isn't printed for the 1st data row, only the grouped date is printed.
Other pages are printed correctly with both the Customer info and the related purchases.
The data source is an xml file read into a DataSet.
Hope this explains the problem and that someone out there have an idea what I'm doing wrong.
Kind regards
Wickey
I have a problem when viewing/printing a report. The report have the following structure:
1: Report Title: empty
2: Page Header: Contains fields for general customer info such as Name, address etc.
3: Group Header: Condition=CustomerId
4: Data: CustomerDataSource: Contains fields for purchases and prices
5: Group Footer: Contains fields for Totals
6: Page Footer: Contains PageNofM field
The data source contains data rows containing all the customer info (CustomerId, name, address, purchases, prices etc.) per row.
f.ex:
100, CuName1, CuAddress1, Product1, Price1 ...
100, CuName1, CuAddress1, Product2, Price2 ...
101, CuName2, CuAddress2, Product3, Price3 ...
101, CuName2, CuAddress2, Product4, Price4 ...
...
The data is grouped by CustomerId.
The wanted result should be something like this:
page 1
CuName1, <= this is missing on the 1st report page
CuAddress1 <= this is missing on the 1st report page
TotalProduct1, Price1
Product2, Price2
page 2
CuName2,
CuAddress2
TotalProduct3, Price4
Product4, Price4
The problem is that the customer info CuName1 and CuAddress1 isn't printed for the 1st data row, only the grouped date is printed.
Other pages are printed correctly with both the Customer info and the related purchases.
The data source is an xml file read into a DataSet.
Hope this explains the problem and that someone out there have an idea what I'm doing wrong.
Kind regards
Wickey
Comments
Put the customer info (CuName1, CuAddress1) on the GroupHeader, instead of PageHeader.
Thank's for the very fast reply.
It works like a charm.
Kind regards
Wickey