Adding 5 different reports in one page

[Former Member]

Hello,

I have 5 different reports and would like to place these reports in one page without using subroutine (already know how to do it with subroutine).

Here is the information for each report:

Report one has 3 records with a total

Report two has 4 records...........

Report three has 1 record.........

Report four has 1 record...........

Report five has 1 record............

The format should be like this.

Report one with a title

IT1                10

IT2                2

IT3                3

          Total   15

Report two with a title

FG1              6

FG2              1

FG3              4

FG4              3

          Total   14

Report three with a title

RM1             4

          Total   4

Report four with a title

SA1              2

          Total   2

Report five with a title

WA1             12

          Total   12

Any help would be appreciated.

-Bill

[abhilash_kumar · Accepted solution]

Hi Bill,

This can be done using crosstabs.

1) Create a formula with this code below:

if {database_field} IN ['IT1, 'IT2', 'IT3'] then

{database_field}

else

''

2) Create another formula for the Summary field with the code below:

if {database_field} IN ['IT1, 'IT2', 'IT3'] then

{measure_field}

else

0

3) Insert a Crosstab. Add formula 1 as the Row and formula 2 as the summarized field

4) Next, right click the Row field on the Crosstab > Select Row Options > Suppress Empty Rows.

5) Go to the Crosstab Expert > Customize style tab > Format Gridlines > uncheck 'Show Gridlines'

Repeat Steps 1 through 5 for each of the other crosstabs. You'd only need to change formula 1 and 2 by replacing the 'IT1', 'IT2',..with the FG1, FG2 and so on..

-Abhilash

[Former Member · Accepted solution]

Hello Abhilash,

It works. I really appreciate you taking the time and help others.

-Bill