Cross tab report

building reports desktopintelligence
1

I have a cross tab report which looks like this

YTD Objective Obj Variance
Region
Atlanta 45 90 45
Detroit 60 100 40

Total 120 200

My problem is that total amount being pulled from national table and other info comes from regional tables.
How do I pull data from 2nd data provider in a cross tab report?

Any help will be appreciated.

Thanks

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

2

Not really sure what you’re describing, but it sounds like the totals are aggregated prior to query time, so that what you really have here is two queries - one for the detail data and one for the totals. What I would do is just make the totals a simple table instead of trying to make it a part of the crosstab. You should be able to butt the two tables up together so that it all looks like one big table.

Hope that helps.

Paul

Kaur, Harpreet (H.) wrote:

I have a cross tab report which looks like this

My problem is that total amount being pulled from national table and other info comes from regional tables.
How do I pull data from 2nd data provider in a cross tab report?

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