Report not showing depending on parameter

[smeyer56]

I have a report based on year and grouped by one of: producer, type and price. The report works fine for all groupings if the year is 2003 but if the year is 2002(there is data) nothing, not even text shows. Any ideas?

 

[smeyer56]

sorry, forgot to includ4e that the report shows 10007 records but I still see a blank page.

 

[rhinok]

Please post your record selection criteria. Also, how are you handling the grouping (grouped by one of: producer, type and price)? Is this done through a parameter, through conditional suppression, etc... The fact that there are records returned, but no displayed indicates that you may be using conditional suppression.

 

[smeyer56]

selection: Year ({tblInquirers.FldInqDate})=ToNumber ({?year})

as far as the grouping: a parameter is enetered for type, producer etc. then a formula called group calculates:

if {?Groupby}="Source" Then {tblInquirers.FldSrcname}
else if {?Groupby}="Producer" Then {tblInquirers.FldProComp}
else {tblInquirers.FldSrcPromoType}

The report is tehn grouped by this formula.

 

[Turkbear]

Hi,
Are any supression formulas set on the Group sections?
When the 'blank' report comes up, is it only 1 page?

 

[smeyer56]

I didn't change anything and now it works.