Forced to use ReportViewer

  • 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

  • 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