Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Planet_x
Starting Member
15 Posts |
 Posted - 2010-05-19 : 10:44:36
|
| I am having slight trouble with paramaters. I am using one paramater called Retailer_ID that is set to a string of numbers like 729030788.In my query of the report it says select all records where Retailer_ID = @Retailer_ID. I am having problems because I also want the user to be able to select no Retailer ID and have all records display. How is this possible? I tried messing with the parameter properties such as allow blanks, using a default value which is a query of all fields from Retailer ID but i keep getting an error that the retailer ID parameter depends on itself or something along those lines. Am I doing this wrong? Just need the user to be able to insert the numbers and search based on records matching them and *also* to be able to leave the field blank and have all records returned. Thanks for any advice/suggestions. |
|
|
|
|
|
Question on Report Services Parameters