If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Multiple Queries in Single List Report

Started by kbasha2004, 20 May 2008 01:00:42 PM

Previous topic - Next topic

kbasha2004

Hi Friends,

I've a list report with few fields. Last column's value is a calculated value. So, I'm trying this calculation in the 2nd query bringing as a dataitem.  When I try to include this column in list. I get message "This is not in 1st Query".  How do I bring this datatitem into my list?

I've the following columns in Query1:
Q1.Country
Q1.Order ID
Q1.Product Name

Query2:
Q2.Country
Q2.Product Name
Q2.Total Quantity of Product for Country (Data Item with Calculation)

The output should be :

Q1.Country, Q1.Order ID, Q1.ProductName and Q2.Total Quantity of Product

USA      10    Campaign Equipment      100   
AUSTRALIA   12    Golf Clubs         150

How do I achieve this?

Thanks in advance!

Basha

almeids

(heavy sigh)...Where to begin?
First, what are you trying to accomplish here?
If the second query has the total quantity of the product for the country, you can't just willy-nilly lump it together with order numbers...unless for some reason you just want to list all your orders and repeat the country/product total with each one.
Secondly, in Reportnet you have one query associated with one report object; everything in your list must come from its query.

If you really do want to repeat total sales with each order, then you can create a child tabular model under your Query 1 tabular model with the Query 2 data items, add a filter in the Query 1 tabular model equating its country and product with the child's, and add the child's Quantity to the Query 1 tabular model and to Query 1.

But, it would be better if this data were appropriately modelled in Framework Manager (which it may well be) so that you don't have to cobble it together.  I suggest you sit down with your modeller and/or DBA to review the report requirements and gain a better understanding of the data and metadata involved, and perhaps consider a Report Studio course.