Cross Tab from Cross Components
Posted: Thu Mar 26, 2020 2:18 pm
Hi I am attempting to build a cross-tab report using the CrossBand components.
Attached is a sample database, sample report, and a report file that I have been working with.
The first page of the report contains a Cross-Tab component displaying data as I would like it to be displayed.
The second page of the report is my attempt at re-creating what the cross-tab component is doing. There are
a few things I haven't been able to figure out...
1. I haven't been able to get the values under the correct headings.
2. I can't get the row totals to appear properly.
3. I'm not sure how to get totals at the bottom.
Why would I want to try to re-create the functionality? Because I actually need to sum two values under each
heading as shown in the example below. I'm hoping someone can provide some guidance.
Thank You,
Carl
Attached is a sample database, sample report, and a report file that I have been working with.
The first page of the report contains a Cross-Tab component displaying data as I would like it to be displayed.
The second page of the report is my attempt at re-creating what the cross-tab component is doing. There are
a few things I haven't been able to figure out...
1. I haven't been able to get the values under the correct headings.
2. I can't get the row totals to appear properly.
3. I'm not sure how to get totals at the bottom.
Why would I want to try to re-create the functionality? Because I actually need to sum two values under each
heading as shown in the example below. I'm hoping someone can provide some guidance.
Thank You,
Carl