sql server reporting services:
I've spent almost a week googling, blogging, attended the intro to Reporting
Services training and still have not found a way to pass multiple parameters
to a report (I don't want to run a report for one employee at a time, but
let the user select multiple employees, then run the report and include the
data for all employees selected at once). It seems there is conflicting
information out there -- some say this can't be done, while I've seen some
references to building an RDL Generator on the fly.
This certainly doesn't seem like something that should be that difficult to
do, and I would think it would be something that Microsoft would have
envisioned since most ASP applications I'm familiar with allow for user
input and then generate the report. The ability to select more than one of
a parameter has always been a requirement on all the projects I've worked on
in the past.
Does anyone have any ideas on how we can do this? Is there a method in the
web service we're missing (the URL approach doesn't work because of the
length constraint, plus I don't think it allows passing multiple values for
the same parameter), or do we have to develop our own RDL generator (argh!).
How about a beta for the 2005 release - Is it available and would it have
something that would make this as easy as I think it should be?
Any help would be great! We're about to abandon Reporting Services and go
back to Crystal Reports (yuck!).