How to suppress main report based on subreport

[TryingToLearn101]

Hello everybody,

I have a question and I hope I can explain it well enough.
I am currently using Crystal XI.
I have 2 orders in my system each order has 2 line items. Now, all 4 line items on those orders have transfers against them. If a line item on a transfer has "lot" more than 1 then I want to see it on my report. But if there is only 1 lot or no lot at all then I don't want to see it on the report.
I created a main report that shows all of items on orders that have transfers. Then I created a subreport that shows those items with the lots information. Everything works well except now, I have all of these other items on my main report that do not have any lots on the subreport or lots more than 1. I need to get rid of them.
I tried using the shared formula to pass the information back to the main report but it does not work well since I place the subreport in the detail section B and the formula in the detail section C. In the mean time I need to eliminate all of the information including the group header and such.
Any advice will be highly appreciated. I hope I explained it okay. Thanks in advance.

 

[Durango122]

Hi
you can look at these thread for more help

http://www.tek-tips.com/search.cfm?...&action=search&CFID=22774335&CFTOKEN=11398722

cheers



Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40

 

[TryingToLearn101]

Hey Durango,
thanks a lot for the tips. I really appreciate it.