September 15, 2010 at 2:20 pm
I'm asked use ReportViewer but I don't have any rdl s(reports). I have a set of views in sql server that I need to send dynamically the view name and columns to the ReportViewer via querystring and serve up the results in ReportViewer.
Any help would be most appreciated...
DeanO
November 8, 2010 at 2:04 pm
Sending view dynamically? I'm not sure if this is possible since your report metadata and structure coudl change if the view changes. If the views have all the same sets of columns, you could consider unifying these via datasets or a straightforward UNION ALL and then specifying a parameter that allows you to change which set of information you are trying gather. For example,
SELECT col1, col2
FROM view1
WHERE @Parameter = 1
UNION ALL
SELECT col1, col2
FROM view2
WHERE @Parameter = 0
Having the user selecting the appropriate parameter will give you an appropriate data selection.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply