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 |
|
CJ81
Starting Member
9 Posts |
 Posted - 2010-10-14 : 11:04:07
|
| Hello all,I've spent a whole day Googling this and haven't come up with anything useful yet!Could someone help?I have a report which produces a table of results showing the customer name:Customer1Customer2Customer3Customer4If I click on one of the customer names, it takes me to a summary page - works perfectly.However, I want to add an option for taking ALL of the customers through to the summary page. I have made my parameter multi-value, but I don't know how to pass ALL of the customers in the list.I have tried =join(fields!Customer.value, ",") but it doesn't work. I have also tried =join(ReportItems!Customer.value, ","), no luck either.Is it possible to join together these fields and send them as comma separated pieces of data so that my next report accepts them as multiple parameters?Thanks!CJ81 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-14 : 12:53:39
|
| Post the whole query you are using.PBUH |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 02:20:53
|
| just add a custom function in report and pass your field collection to it and do concatenation inside that to return a comma separated list of values. Then in parameter value pass it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
CJ81
Starting Member
9 Posts |
Posted - 2010-10-18 : 07:18:57
|
| Thanks - the problem I have is that the list of customer names is variable depending on what the user selects in the parameters. They can choose a region and/or country and choose to view the top X number of customers. So the list will change every time the report is run. I need something in the report to allow the user to click to the next report which will take all of the listed customer names with it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-19 : 13:06:07
|
| what happened when you used join() in jump to report link?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Joining results from a table to pass as a paramete