Passing Parameters -Hiding SubReport

building reports crystal reports
1

I am able to pass parameters from my sub-report to my main report but only if the sub-report is not suppressed or not hidden. I don’t want to see the sub-report when I run the main report - just the result of it. Any ideas? Thanks!

Gingerly (BOB member since 2011-03-24)

2

Figured it out - made all fields white font/white background and changed size of sub-report to .2 all around. Hope this helps someone else!

Gingerly (BOB member since 2011-03-24)

3

Don’t use subreport for calculate one value! Your report will be very slowly… Better solution in this way is to use sql expression.

  1. Field Explorer | New
  2. Type sql statement in brackets(!), for example:

(select sum(sallary) from orders where customerId = {customers.customerId})

Hope this helps!

sulmar (BOB member since 2012-05-18)

4

I would love to try this, Sulmar but my NEW is grayed out in Field Explorer. How do I activate? Thanks!

Gingerly (BOB member since 2011-03-24)