Editing reports in Remote Mode

Hi All,

I'm wondering how to acheive report editing features (Where users can change the figures (not the report design) in the delivered report and get a print out) under SQL Server reporting services in remote mode To my understanding remote mode delivers the fully rendered report to the application. In local mode the application has access to the data source and It will be easy to provide report editing feature by just loading the data to some editable control. But in remote mode is there a possibility for my application (Windows forms) to access the data (Data XML) which is being used in the report

Thanks
U


Answer this question

Editing reports in Remote Mode

  • Delboy

    You are correct that the data is not exposed in remote mode.  The client receives only the rendered report.  You can use report parameters to filter or modify the queries used to run the report.
  • Haseeb Ahmad

    That should work fine.  Note than in local mode, you can even dynamically change the rdlc file if you want.  The report definition can be loaded from a stream.
  • Leslie Sheldon

    Thanks Brian.

    I'm thinking of giving the users data editing feature in local mode. I feel this is possible if we can expose the data set XML to the users with some sort of custom UI. After they edit values in that UI we render the report again with the altered data set and the report should show up with the altered data.

    Guys..any flaws u see in the above argument

    Cheers
    U

  • aniljain50

    Some good news. I found out that I could use the export feature provided in the report controller it self to extract the report data as an XML. I could provide a custom UI for the users to edit this XML. Now I'm working on how to render the report again with this altered XML data. If any of you guys come across with anything which can help me pls be kind enough to post.

    Cheers
    U

  • Editing reports in Remote Mode