Report Parameters

[darude]

Good morning,
I am using a stored procedure for a report that accepts 1 parameter - 'Summer' and 'School Year'. Is there a way to store just those values in a drop-down without having to create a select statement?

Thank you in advance.

 

[ousoonerjoe]

Yes. If you open the "Report Parameters" Property Page, you'll see a section called Available values. Using the option Non-queried, enter your values.

Lable = What the user will see.
Value = What the system will return when a specific Lable item is selected.

--------------------------------------------------
Bluto: What? Over? Did you say "over"? Nothing is over until we decide it is! Was it over when the Germans bombed Pearl Harbor? No!
Otter: Germans?
Boon: Forget it, he's rolling.
--------------------------------------------------

 

[darude]

Got it! Thank you.