none
save and load RDL/RDLC with Data(offline mode with reportviewer), load RDL/RDLC with saved data in reportviewer at client machine

    Question

  • Hello every one
    We are new to SSRS.
    we have a client server application and have reports in crystal report, for each request to report from client we run report in server and then send saved rpt(crystal report file that data is embedded in file ) to client and after that load it to client crystal report viewer. clients can saved report file with data and load it in another time(truly we don't use crystal as report server and our application manage reports ).
    we plan to use SSRS in our application instead of crystal report(for problems that there are in crystal version and deployment of crystal report packages ). in our scenario we need use RDL without server truly just application use server but client just receive report file and load it to RDL/RDLC ReportViewer and reportviewr run in local mode without communicate with server like crystal previous solution we need clients can save report with data and reload it in another time. we can't find any solution for it.

    Are there any solution to save RDL/RDLC file with Data and load it again in Reportviewer?

    Can use *.rdl.data for it?


    Why there is not any easy way to embed data in Rdl  or Rdlc file and reload them with data?

    Is it a weakness of SSRS and SSRS has any plan to add this feature?

    thanks all

    Monday, March 01, 2010 4:06 PM

All replies

  • Hi,

    You can use reportviewer to load an existing report from the ReportServer. You need to configure ReportViewer for Remote Processing, more information, you can refer to:

    http://msdn.microsoft.com/en-us/library/ms252075(VS.80).aspx

     

    Hope this helps,

    Raymond

    Wednesday, March 03, 2010 5:05 AM
  • Hi,

    You can use reportviewer to load an existing report from the ReportServer. You need to configure ReportViewer for Remote Processing, more information, you can refer to:

    http://msdn.microsoft.com/en-us/library/ms252075(VS.80).aspx

     

    Hope this helps,

    Raymond


    Hi Raymond, thank you for your asnswer.
    but we need load rdl/rdlc in client without need to SSRS(offline),truly we want just our server application  use SSRS and execute RDL/RDLC report file and save RDL/RDLC with data then sends it to client and reportviewer(without connection to SSRS) load RDL/RDLC with saved data without need to use SSRS.
    Wednesday, March 03, 2010 8:57 AM
  • rdl.data file is the cache of the report designer and only available in design time (BIDS/Visual Studio).

     

    Why don’t you export the report to the file (XML/CSV/Excel/HTML/PDF)? Then you can review the report without connect to the server.

     

    Of cause, report can be running in offline mode. The key point is the datasource, you need to use ODBC data source or customized data source. You can export/download the data from the SQL Server to the file, and then create report base on this local file. After that, you can run report base on this local file or even change the file (keep the same name).

    http://msdn.microsoft.com/en-us/library/ms159219.aspx

     

    If the build-in data source ODBC doesn’t meet some complicated requirement, you can create your custom datasource:
    http://msdn.microsoft.com/en-us/library/ms160918(SQL.90).aspx

    http://msdn.microsoft.com/en-us/library/ms152917(SQL.90).aspx

     

    Hope this helps,

    Raymond

    Thursday, March 04, 2010 4:06 AM
  • rdl.data file is the cache of the report designer and only available in design time (BIDS/Visual Studio).

     

    Why don’t you export the report to the file (XML/CSV/Excel/HTML/PDF)? Then you can review the report without connect to the server.

     

    Of cause, report can be running in offline mode. The key point is the datasource, you need to use ODBC data source or customized data source. You can export/download the data from the SQL Server to the file, and then create report base on this local file. After that, you can run report base on this local file or even change the file (keep the same name).

    http://msdn.microsoft.com/en-us/library/ms159219.aspx

     

    If the build-in data source ODBC doesn’t meet some complicated requirement, you can create your custom datasource:
    http://msdn.microsoft.com/en-us/library/ms160918(SQL.90).aspx

    http://msdn.microsoft.com/en-us/library/ms152917(SQL.90).aspx

     

    Hope this helps,

    Raymond


    Thanks again Raymond *.rdl.data information is helpful i don't know that.

    but Export report in pdf format is an easy but powerless solution for some weakness of converted file format like  accuracy of print or search feature or drill drown   feature or ....

    About second solution if i correctly understand your solution, "Data Processing Extensions" works between "Datasources" and "Report Processing"
    http://i.msdn.microsoft.com/ms152816.6d5e3501-9bce-4746-8de1-320e6d2c5cad(en-US,SQL.90).gif
    and they are good for use SSRS in DataSource offline mode but our application in client side is reporting service offline it
    means reportviewer does not allow communicate to SSRS.

    This scenario is easily reachable in crystal without need to code (execute report in server save report file with data send it to client and load it in client reportviewer without any need to report processing or datasource ).

    Mayebe we have too retrive and execute query of report in server side after that serialize data of query in RDLC file report (custom field), send it to client, deserialze data from rdlc file and after that load RDLC file in reportviewer and feed it with retrived data. It is difficult and need many code.

    Any Idea?

     

    Thursday, March 04, 2010 2:20 PM
  • Hi mojtaba

    I'm looking for the sama solution to ensure that the report will not change after versioning or change of data.

    Did you find a solution for the rdlc to seva (data report ana parameters ) and reload them at any time without the need of old data in the data tables and report definition. I can export it to PDF Excel vs but i want the report to be displaed in the reportviewer.

     

     

    Saturday, May 21, 2011 4:24 PM
  • Hi,

    I am also looking for the same solution and trying for days to find somthing, can you shed some light on the matter

    thanks,

    Mosh.

    Thursday, February 06, 2014 10:06 AM