getting rid of subreports

[sdtechlog]

Need a little help, so I thought I'd throw this out there and see if I can get any feedback on it. We are using CR 8.5 and MS SQL. We currently have one report with 10 subreports. The problem is that its slow. I figure we need to make this one single report. Each subreport references a different single SQL table using the same field (account #). We run this report one account at a time, and each subreport will come out to multiple pages.

I've searched the forums, but have not found anyhting to help me along. Can anyone point me thoward any resources (ie: faq, or threads) that could help me with setting up the relevant group header, footer, detail sections, etc.?

Thanks in advance...

 

[Mountaine]

There are many possible solutions to your problem. The best is to upgrade to CR9, which allows you to write a SQL command yourself, and you would create a query that is a combination of all the separate queries using UNION. If you know how to do that. I've done this successfully many times now. However, you don't have CR9. I'm sure there are ways to simulate the above using stored procedures in your database; that's kinda technical, and I hope you know how to do it. In general, the key is to find a way to have a single data source for Crystal to report off of that includes all the data you need. Hope this sparks some ideas... Mort Jonas

 

[sdtechlog]

It does. So if I had a single data source, how would I go about giving the apparence of multiple subreports? Meaning, currenctly each subreport has its own slighty different header and running total columns, how would I go about setting that up using the main report only?
Let me know if I'm making sense...

 

[Madawc]

You can use SQL with Crystal 8.5, via the SQL design software. Unfortunatley I don't think that will get you want you want. Accessing ten different tables in turn and printing each separately isn't something you can do without subreports, at least not by any method I can think of.

What does the main report do? If it is currently just a 'frame' that does nothing except access the subreports, you could move up the function of one subreport.

Madawc Williams (East Anglia, UK)

 

[sdtechlog]

Main report is just a frame.

 

[sdtechlog]

Will an upgrade to CR 9 or 10 help me resolve this issue?