Skip to Content
avatar image
Former Member

Adding 5 different reports in one page

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 17, 2015 at 04:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded