problem with linked subreport on formula

[mwhalen]

Hi I'm running into a problem here. I have a formula on my main report "if client.status in [100,200,300] then client.number". Then I link my client orderinfo subreport based on the formula. I have about 6000 clients with no order info but maybe only a handful with order info. It seems to run fine when I just put in those client numbers that I KNOW have order detail. I'm wondering if it's running into a problem because there are SO many without the order detail (and therefore the subreport returns nothing) that it doesn't like them combined for whatever reason in the same run.

 

[kenhamady]

see faq149-237, and then tell us what error or problem you are having. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[mwhalen]

I'm not running into an error message per se.... when I try to do it on a small scale, it works. It's when I try to run it on a large scale it just runs forever (i.e. 2 or 3 days) on Info Desktop.

 

[kenhamady]

That seems pretty excessive.

Post here the exact formula of the field that you are linking to in the main report.
Also post the exact record selection formula from both the subreport and the main report.
Last, tell us which section of the main report the subreport is placed in. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com