Subreports run for long time when link is null

[tservo]

Hi All,

I'm working in Crystal Reports 2011 with Oracle 11g and have a general question on Subreports. When the main report ends up returning no data for a valid reason (i.e. desired data simply doesn't exist), meaning that the data used for the subreport link is null. However, the subreport runs for quite a while before it finally figures out that it is returning nothing as well. It almost seems like it's doing a full table scan.

Is there any parameter or technique that can prevent subreports from running in this situation?


Thanks a lot,
Dan

 

[pmax9999]

Hi Dan

Use conditional suppression on the subreport to suppress when:

Isnull(Count({table.field})) //where {table.field} is one of the actual columns from a table used in the main report

Cheers
Pete

 

[tservo]

Doh, I had the feeling it would be something simple that I was missing!

Thanks a lot,
Dan