Report blanks out after heavy use of queries

[MayFlowerNew]

I have created a report which heavily uses MS Access queries. The tables on which these queries run are also quite huge. My problem is if I add one more formula that accesses a query result field, it blanks out the whole report whereas I can use the same formula in another report fine.
Also while refreshing the data it gives me following error "More than one datasource or stored procedures used in this report. Please make sure that no SQL expression is added and no server side grouping is performed."

Whats wrong? Is it too much for crystal to handle? or am I doing something wrong??

 

[vidru]

Crystal treats Access queries as if they were stored procedures. As soon as the second 'procedure' is added to the report, it generally issues the warning you're seeing ("More than one datasource..."). Then, if you place fields from both procedures on the report canvas, the results will be unexpected, at best - if it doesn't just completely bomb out.

Your best bet would be to try create a new query within Access that combines the two (or more) queries, then use that as the report's data source.

-dave

 

[MayFlowerNew]

Hi dave,
Thanks for the input but after some further investigation I found out that linking in one of the queries was going wrong. And the report was going blank.

Do you have any idea why crystal generates the report so slow..Access runs the same query pretty fast..

Also is there any way to write a formula using other custom formulas??

Thanks