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 |
|
webcomber
Starting Member
10 Posts |
 Posted - 2008-09-19 : 13:52:14
|
| Hi -I have a typical report with several datasets and parameters that the user can select. Within the report for organization, for example, the user can select from (A,B,C,D) or all or a combination of each. Recently it was requested to email the report with each organization listed separately. So, for example, instead of the value saying =Fields!Organization.Value, I want each report to have a specific value that I can determine, and list the items for that one value. I would then just stack the reports on each other with this field separately selected in each report. This is a regular table, and not a matrix report as each item should be seen within each row separately.How do I select a value separately in the expression without creating a separate dataset for each? Thanks!WC |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-19 : 14:08:39
|
| you can create a single report and pass the value you want through URL seperately for each organisation so that reports renders with that value as default for param. |
 |
|
|
webcomber
Starting Member
10 Posts |
Posted - 2008-09-19 : 18:10:06
|
| Hi visakh16 -Could you provide an example for what I would input in the fieldto determine a specific value? Thank you,WC |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 02:09:28
|
quote:
Originally posted by webcomber
Hi visakh16 -Could you provide an example for what I would input in the fieldto determine a specific value? Thank you,WC
Suppose if you've a parameter param1 in your report. and you want report to be accessed by four person each with different values of param1 always. what you do is to append this param with report url along with value you want. See below link for more detailshttp://www.mssqltips.com/tip.asp?tip=1336 |
|
|
|
|
|
|
|
|
Selecting One Value from a List