subreport and formula parameters

[TerriO]

I have a report with several variations of the same report as subreports. Below is one of the formulas I am using for data in some of my columns. For lack of better words and ease of explanation This is needed to pull historical data for certain columns (freeze time?)

if {JC20001.Document_Source}<>&quot;PDU&quot;and
{JC20001.DOCDATE}in {?Start Date}to{?End Date}
then {JC20001.Cost_Code_Act_Cost_TTD} else 0

My main report parameter is the Project number and the date parameters applicable to those columns. My problem is that regardless of how I link the report because this formula exists in all of the subreports I am still getting date prompts for all of the subreports.. Is there any way around this?

Terri

 

[synapsevampire]

First, the subreports don't require parameters, you can join directly to the field, though you will have to then manually modify each subreports record selection formula to reflect <= and >=.

You can link the subreports by the main reports parameters to the subreport parameters, but I'm guessing that you have the legacy record selection formulas in them, so it's prompting for those as well.

Remove the record selection formula in each subreport PRIOR to joining the main report to the subreport, the redundant promnpts should disappear.

-k

 

[TerriO]

This formula is only for one column
{JC20001.DOCDATE}in {?Start Date}to{?End Date}
then {JC20001.Cost_Code_Act_Cost_TTD} else 0
which is gathering a specified period of historical data in All of the subreports. I am pulling all information pertaining to a project number. I am still getting the prompts for start and end date for all of the subs.

Terri

 

[synapsevampire]

If the subreports don't have parameters, they can't prompt.

Please reread my suggestion.

-k