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?