CR 10...
I have a report which shows daily revenue totals by day and a subreport that shows refunds by day. The report and subreport data come from different tables. The report looks like this:
Mainline Daily Trips
Date Revenue Trips Passengers
10/1/2014 11,299.00 52 331
10/2/2014 10,878.00 52 322
Daily Refunds
10/1/2014 -145.00
10/2/2014 -218.00
Is there a way to pull the subreport daily refunds into a column in the main report so the report layout would look like this?
Mainline Daily Trips
Date Revenue Refunds Trips Passengers
10/1/2014 11,299.00 -145.00 52 331
10/2/2014 10,878.00 -218.00 52 322
Thank you in advance for any help you can offer.
I have a report which shows daily revenue totals by day and a subreport that shows refunds by day. The report and subreport data come from different tables. The report looks like this:
Mainline Daily Trips
Date Revenue Trips Passengers
10/1/2014 11,299.00 52 331
10/2/2014 10,878.00 52 322
Daily Refunds
10/1/2014 -145.00
10/2/2014 -218.00
Is there a way to pull the subreport daily refunds into a column in the main report so the report layout would look like this?
Mainline Daily Trips
Date Revenue Refunds Trips Passengers
10/1/2014 11,299.00 -145.00 52 331
10/2/2014 10,878.00 -218.00 52 322
Thank you in advance for any help you can offer.