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

Simple Error, but URGENT - plz help!

Started by dfite, 23 Jul 2009 11:53:28 AM

Previous topic - Next topic

dfite

I am still fairly inexperienced in reportnet, but I have an urgent need to complete development on a report and I don't know how to get it to work.  It is a "member statement" letter that generates a letter to each member of a batch (that is run in oracle).  On the statement the member's name, address, etc. is displayed and I also need to list all of their contributions/interest by certain types.  For that, I am using a second oracle view and cognos query and a List object.  As the user generates the report, he chooses the batch ID on the prompt page, which I am using to filter my query results (in both queries).

The issue is - the list box dollar totals have ALL dollars for all members in the batch.  I have tried linking the 2 queries together with a filter (basically query 2's member key = query 1's member key) but that didn't help.  I also tried making query 2 a Tabular Reference under Query 1 - that didn't help either.  Thirdly, I tried creating a Relationship inthe framework manager between the 2 query subjects that correspond to the 2 oracle views I'm using.  Still, for each member letter, the dollar totals in the List contain everyone's dollars...

Any ideas?

DustPanMan

Have you tried creating a master-detail relationship between the two queries?
Best,

D