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

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, 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.

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

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

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?

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?

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.

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.