Deploy SSRS Report Server Project
To deploy Report Server Project, please go through below steps:
1. Go to Report Service Configuration Manager then click on the Report Manager URL tab in order to get Report Server URL.
2. Now click on the Report Manager URL. We will get a empty screen as below:
3. Let us query catalog table of ReportServer Database.
When we design a report, Report Definition Language File (.rdl) is generated whcih is basically a XML file which contains all the information about our report. So when we deploy the report, the .rdl file gets inserted into the our Report Server Database.
Alternatively we can also go from Project Menu.
5. In both case we will be directed to Project’s Properties Page where we are going to insert our Target Server URL Which is our Report Server Web Service URL.
In my case it is like
6. After click on OK, right click the Project and select Deploy from the context menu.
7. If all fine we will receive Success Message.
8. If here we query our Catalog table of Report Server database we will get results like following.
Here we can see the entries of Our Project and Report.In above result Type 1 means Project and 2 means Report.
If you want to see the XML content, execute following query:
SELECT
[REPORT NAME] = NAME,
[RDL CONTENT] = CAST(CAST(CONTENT AS VARBINARY(MAX)) AS XML)
FROM CATALOG
WHERE TYPE = 2
You will get results like following:
9. Now let us see our report from the browser.Go to Report Manager URL and you will get a screen like below:
10. Now click on StartSSRS and it will show the list of report.In our case it will show only 1 report which is PersonAddresDetails.
11. Now Click on PersonAddresDetails Report and you will get following screen:
Congratulations! Our First SSRS Project is successfully deployed.
1. Go to Report Service Configuration Manager then click on the Report Manager URL tab in order to get Report Server URL.
2. Now click on the Report Manager URL. We will get a empty screen as below:
3. Let us query catalog table of ReportServer Database.
SELECT * FROM CATALOGIt will show below output:
When we design a report, Report Definition Language File (.rdl) is generated whcih is basically a XML file which contains all the information about our report. So when we deploy the report, the .rdl file gets inserted into the our Report Server Database.
4. . Now come back to our SSRS Project. Right Click the Project and click on properties.
5. In both case we will be directed to Project’s Properties Page where we are going to insert our Target Server URL Which is our Report Server Web Service URL.
In my case it is like
http://bhushan-pc:8080/ReportServer
6. After click on OK, right click the Project and select Deploy from the context menu.
7. If all fine we will receive Success Message.
8. If here we query our Catalog table of Report Server database we will get results like following.
SELECT * FROM CATALOG
Here we can see the entries of Our Project and Report.In above result Type 1 means Project and 2 means Report.
If you want to see the XML content, execute following query:
SELECT
[REPORT NAME] = NAME,
[RDL CONTENT] = CAST(CAST(CONTENT AS VARBINARY(MAX)) AS XML)
FROM CATALOG
WHERE TYPE = 2
You will get results like following:
9. Now let us see our report from the browser.Go to Report Manager URL and you will get a screen like below:
10. Now click on StartSSRS and it will show the list of report.In our case it will show only 1 report which is PersonAddresDetails.
11. Now Click on PersonAddresDetails Report and you will get following screen:
Congratulations! Our First SSRS Project is successfully deployed.
No comments:
Post a Comment