how to code 2 dependant queries

[vanK]

Hello! I am new to Actuate reporting - we are getting familiar with the tool at work and decided to convert some of our BRIO reports. I know how to construct a simple report, but i am stumped when i need to do the following:
First I want to query for a particular Master Id based on the group it belongs to. Once this is found, I want to update all Master ID's child records. How do i create these two separate queries?...do i structure them as sub reports and if so, how do i do this? How do i allow the execution of the second query based on the first one ... and use the eg. Master Id returned in the first query in the where clause of the second query.
Thanks!
-van

 

[bcaslow]

My suggestion is that you accomplish this with your SQL statement. Anything you can do on the database end, DO IT! Actuate is a memory hog, and while you could accomplish this, the overhead -- and likely the performance as well -- will be pathetic (unless you're talking very few results).

Otherwise, you woul need to have a Sequential Section: one report to query the database for the MasterID, building an AcList (there is an example that ships with Actuate) but not creating any controls (other than the list). The second report woulf then build your SQL statement from the AcList in the WhereClause. But again, if you have more than just a few results returned for MasterID, you will be much, much better of with a nested SQL statement.