Report with many subreports

[Madalina]

I have to make a report based on a MsSqlServer database. The record criteria selection is complex, generated by a "report wizard". I made 5 subreports for every kind of data but I can't transfer all parameters from main report to subreports. Most of this parameters are arrays and don't works like subreports links. How can I obtain the records selected without using Record Selection Formula, which must be less 254 characters and my selection formula is greater? Can I use crystal queries or sql stored procedures, or dictionaries?
Thank you

 

[dcm]

Madalina: From your posting it is not clear if you have the same parameter structure in the main AND subreports. If you do then you will be able to use the main report parameters to link to the subreport parameters and all values will have an effect David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[teddyboy]

Try writing a Stored Proceedure to populate a temp table with ALL the fields you need. Just Select from that temp table what you want for each sub report.