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 |
|
fabri
Starting Member
16 Posts |
 Posted - 2011-07-08 : 05:57:27
|
| Hi I have created a report where multiple parameters are passed to multiple tables and lists. I dont want to create a report for each list and table.Is there a way i can pass multiple values to the same table and compare those to multiple fields. eg one of the list's filter on users. So if you click user I would pass the user parameter to the user field.but if is there a way for lets say you click client instead of jumping to another list and filtering on client use the same user table but ignore the user parameter and field and use the client parameterr and field? i have about 6 different fields i will need to do all these on one table?Live for nothing or Die for something |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-07-08 : 10:59:56
|
| Try something likewhere (user=@user or user is null) and (client=@client or @client is null) and ........MadhivananFailing to plan is Planning to fail |
 |
|
|
fabri
Starting Member
16 Posts |
Posted - 2011-07-11 : 05:03:00
|
| Thats not quite what i'm looking for, I have a table on the report layot with 5 graphs, each one filters on different fields with different parameters. We have limited space so what i want to do is no matter which of those charts you click they must all drill to the same page with one table on the page. Now depending on which table you ckicked you need to pass the relavant parameter and field to the table and ignore the rest.Live for nothing or Die for something |
|
|
|
|
|
|
Tough one