Previous Message

building reports desktopintelligence
1

I have 2 reports (report1 and report 2)that come from the same universe. They contain the same information but with different date ranges. Report 1 contains month to date data and report 2 contains cummulative data. How can I get the table from report 2 (cummulative data) to display with report 1? I want the data from report 1 and report2 to print out on the same page.

Any help is greatly appreciated.
Thanks,
David

Listserv Archives (BOB member since 2002-06-25)

2

Copy/paste the table from report2 into report1; then delete report2. In report1, format table2 so it’s right next to table1 via Format Table -> Appearance tab.

George Baranowski
QuadraMed

Listserv Archives (BOB member since 2002-06-25)

3

At 01:01 PM 1/27/2000 -0600, you wrote:

I have 2 reports (report1 and report 2)that come from the same universe. They contain the same information but with different date ranges. Report 1 contains month to date data and report 2 contains cummulative data. How can I get the table from report 2 (cummulative data) to display with report 1? I want the data from report 1 and report2 to print out on the same page.

David

Given: Query 1 Objects - Customer Name, Current Revenue
Query2 Objects - Customer Name, YTD Revenue

  1. Menu INSERT - REPORT - Create a new report tab (not required but it easier) 2) Menu INSERT - TABLE - Create a new table for the report 3) In the INSERT NEW TABLE wizard select “Use existing data from the document” 4) Select the variables that you want to see in the report. Note you will need to
    use the CTRL key to select multiple entries from the list.
    For example:
    Select ‘Customer Name’ from Query1(Current) for the purpose of this
    example ‘Customer Name’ is common to both query 1 & 2. Select ‘Current Revenue’ from Query1(Current) Select ‘YTD Revenue’ from Query2(YTD)
    5)After you have selected all of the objects you want to see in the table select
    the FINISH button. The report table will display ‘Customer Name’, ‘Current Revenue’, and ‘YTD Revenue’.

You’ll find that BusObj will merge the values of the two queries such that when a Customer Name has YTD Revenue values but no Current Revenue values that the Current Revenue value is set to zeros.

Check it out… you’ll be able to create some really nice reports using this functionality.

Mike McErlain
McErlain Consulting @ Cisco Systems
MikeMcErlain@Netscape.net

Listserv Archives (BOB member since 2002-06-25)