I have searched the forums and have not found any mention of this problem. There si a lot of posts regarding subreports based on two tables linked to the same customer but not for the problem that I have. So if there is such a post please refer me to it please.
The Structure
---------------
I would like to print a report based on a set with the following (1:M) relationship. Customer linked to Division and points_purchased at the same time:
customer
->division
->enduser
->license
->transactions
->points_purchased
The report will print in that hierarchy, the transactions for each license and sum the totals. This works fine.
I would also like to print the points purchased with totals by the customer at the end of the report (I will at this stage only print one customer at a time).
So in order to add the points_purchased totals to the report I added a subreport with the structure that I need.
The Problem
--------------
I am in a catch 22 for what I am trying to achieve.
If the report is based on a set with the "Include record from parent table" option to "Always - even if no matching child records exists" then the sub report displays correctly but I get a few lines at the beginning of the report that is not related at all.
If the report is based on a set with the "Include record from parent table" option to "Only if matching child record DOES exist" then the lines at the beginning is gone but the sub report does not display the details of the points_purchased items.
I have attached a sample database(Username:Administrator and Password:master) with two reports to print.
1) View Report All - Based on set where parent record printed regardless.
2) View Report distinct - Only print parent record if child exist.
If anyone can shed some light on this problem I will be most grateful.
The Structure
---------------
I would like to print a report based on a set with the following (1:M) relationship. Customer linked to Division and points_purchased at the same time:
customer
->division
->enduser
->license
->transactions
->points_purchased
The report will print in that hierarchy, the transactions for each license and sum the totals. This works fine.
I would also like to print the points purchased with totals by the customer at the end of the report (I will at this stage only print one customer at a time).
So in order to add the points_purchased totals to the report I added a subreport with the structure that I need.
The Problem
--------------
I am in a catch 22 for what I am trying to achieve.
If the report is based on a set with the "Include record from parent table" option to "Always - even if no matching child records exists" then the sub report displays correctly but I get a few lines at the beginning of the report that is not related at all.
If the report is based on a set with the "Include record from parent table" option to "Only if matching child record DOES exist" then the lines at the beginning is gone but the sub report does not display the details of the points_purchased items.
I have attached a sample database(Username:Administrator and Password:master) with two reports to print.
1) View Report All - Based on set where parent record printed regardless.
2) View Report distinct - Only print parent record if child exist.
If anyone can shed some light on this problem I will be most grateful.
Comment