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 |
|
gashdc
Starting Member
12 Posts |
 Posted - 2004-11-11 : 13:45:18
|
| Ok, I have a report that is actually a collection of subreports, right now I have it display all of the reports together, which is proving to be pretty large. What I am trying to do now is set up a parameter where the user can select a product and display all of the reports containing that product. That works fine. My issue is that now there is no way to display all of the reports together (as it was originally). I am using an "Available Values" from a query that returns a list of products. What I was to do is use that list plus an additional static value of "All Products" to put at the top of the list. I cant see how this is done and was wondering if anyone knew if this was even possible. Thanks in advance for your help.David |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-11 : 16:46:09
|
| Modify your query to do the following:SELECT ProductID, ProductFROM CustomersUNION SELECT YourValue, 'All Products'Order By ProductThat is change your query so that you get those "Available Values"and now part of the available values is "All Products"Jon |
 |
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-12 : 11:19:38
|
| I tried that out and it works fine, I was hoping there was a way to do that through RS, but this gets the job done all the same. Thanks a ton for your help! |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-12 : 16:53:35
|
| You can do this in RS as well, you need to change the query but it would be in the dataset as a "text" based query.You could also use a non based query but you'd have to enter the darn values.Hopefully MS releases some sort of SP2 on RS, I've noticed so many bugs :(Jon |
|
|
|
|
|
|
Report Parameters - Static and Queried in One?