supernova122
MIS
I am designing a report which need to take parameter input by user when the report is open. Can anyone please tell me how to do this? Using MS SQL 2005 report. Thanks.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
parameter in MS SQL2005 report
- Thread starter supernova122
- Start date
- Status
- Thread starter
- #2
supernova122
MIS
To be more specific,I want a pop-up window to ask user to input a
parameter when I am a report and this parameter will filter out the data.
Say, when I run a product sales report, a pop-up window can ask me for which
state and I input California. So the report only shows California sales
report. Please help. Thanks.
parameter when I am a report and this parameter will filter out the data.
Say, when I run a product sales report, a pop-up window can ask me for which
state and I input California. So the report only shows California sales
report. Please help. Thanks.
You can put a parameters section in the report design. Insert a dropdown box whose contents are bound to a DISTINCT query of the states in the table.
Read the help in Management Studio for details.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
Read the help in Management Studio for details.
Phil Hegedusich
Senior Programmer/Analyst
IIMAK
-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.
- Status
Similar threads
- Locked
- Question
- Locked
- Question