none
Access SSRS Report DataSet after binding ... RRS feed

  • Question

  • Is there is any way I can access ReportViewer DataSet after it being filled?

    There is no DataBound Event (after binding data) in ReportViewer so I can access the data.

    What I'm Trying to achieve is :

    1- access data before it's submitted to the report ... 
    2- Get for example:dataset.Tables(0).Rows(0).Item("Price")
    3- Do Some Operation on it : Dim newPrice = DoSomething(Price)
    4- assign newPrice data to a Report Parameter.
    5- assign Parameter Value to a specific Textbox inside the Report.

    Thanks.

    Tuesday, September 25, 2012 5:04 AM

All replies

  • Hello Mahmoud Al-Sharif

    As I understood you want to use some results from your data inside a REPORT PARAMETER,

    If that is right, why won't you try creating a Stored-procedure (I assume that you are using MS SQL X) and do the calculation there?

    You can use loaded Data inside report and calculate some values, but as I know you can not use it to feed one of your Report parameters (because of report run-time order).

    By the way if you need more help, please be more specified of what you are going to do and let me know what are your database server, your SQL Query, and the thing your are trying to do with your data.

    Wednesday, September 26, 2012 8:56 AM