have another issue with a report. I am trying to set up a parameter that prompts the user when the run the report to make a selection of either one value or multiple or a range.

Unfortunately it is not working.

Let's start with what I think is the main thing here:

In the over all report I have numerous Groups.

The very first grouping is on Project #, then Project name, Project Manager.....

 

I am trying to set a selection parameter on the Project #

 

What I did:

New Parameter ->Name -> Value Field List and select Proj.PSPID->Actions and select Apend All DB Values -> False for custom Values, True for Range and single and multiple values.

 

Then I go to the Record Selection. Select PROJ.PSPID and set it to is equal to and select my parameter. I click ok. Then when refreshing the report I get prompted for the parameter. I make a selection. But it runs the whole 9 yards and returns all values.......

 

I am not sure if I need to make a Group specific record selection. I looked into that but did not know how to set that up.

 

Any suggestions?

 

Thanks,

Stephan

 

Post your record selection/ saved data selection restriction formula.