October 10, 2012 at 11:19 am
I have a developer who wants me to produce a report from a dataset he passes in like a parameter or multiple parameters. The dataset does not exist in a database, only in memory from the screen the customer would call the report from.
I don't believe this is possible without lots of custom code to parse through parameter data to produce the dataset to be used by the report. My stance is he needs to persist the data before we expect SSRS to report from it.
Is there any known solutions that resembles what the developer wants or would you agree this is beyond the reasonable capabilities of SSRS?
Rodney Workman
October 11, 2012 at 8:41 am
If it is just a few columns you could use a multi value parameter for each column of data. I did a report where the user had a spreadsheet were they needed to take a column of data and use it as a filter for a report. I gave them a blank multi value parameter and they copied the column and pasted it into the parameter window and ran the report, no problem. I blogged about it here: http://www.bidn.com/blogs/Daniel/ssas/1649/don%E2%80%99t-use-ssis-to-import-simple-data-for-a-report-use-a-multi-value-parameter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply