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 |
|
JoshArmstrong
Starting Member
2 Posts |
 Posted - 2010-02-27 : 16:24:41
|
| SO here is what I am trying to do, I need to create a report that pulls data from an MS Access database. I do not have the choice and must pull from access. So far I have not been able to get multivalue to work. If I select just one option I get the report any more and I just get a blank report. I have tried setting the parameter value to =Join(Parameter!incident.value, ", ") I have also tried using it as a filter all to no avail. Any help would be great. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-27 : 23:58:19
|
| you could just give =Parameter!incident.value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
JoshArmstrong
Starting Member
2 Posts |
Posted - 2010-03-09 : 01:27:20
|
| I wish but I get an error message about "Cannot add multi value query parameter '?' for date set it is not supported by the data extention" If I use the =Join(Parameters!Parmname.Value, ", ") it will work but only for one parameter. If I select more then one I will get the report but with no data. |
|
|
|
|
|
|
Multivalued Parameters to Access Database