Monday, May 24, 2010

Creating and Publishing Report on Local Server in SQL Server Reporting Services 2008 express (SSRS)



Go to Start--->All Programs--->Microsoft Sql Server 2008---> SQL server business intelligence development studio.



How to open new project in SQL server business intelligence development studio?
The instruction given below.

Then click File
---> New --->Project.

How to Select Report Server Project Wizard template? The syntax given below
 

Click Report Server Project ---> Name the new report ProductReport1 and pick a convenient location to save it in---> OK.

How to add Data sources.
Right click shared Data Sources 
---> Add  ---> New Item.

How to Select Report Wizard template? The instruction given below.

Then Click Report
--->Add

How to add Report2 in SQL Server Reporting Services. Follow this step.

Right click Report
---> Add --->New Item.

How to add Report in SQL Server Reporting Services. Follow this step.

Click Report
--->Add
                                                    
   How to open toolbox in report project.

    Then click toolbox
 

How to Add Table in report design.

Click Table
--->Drag the Table.

How to create Dataset in report project.

Go to New 
--->Dataset drop-down and select to open the Dataset properties dialog box.

How to open Dataset properties.

Click New
                                                        
   How to open Data source properties.
Then click Edit


How to fill Server name and Select a database name.

Fill the Server name
---> Select or enter a database name---> OK

 Click OK.

How to write the query in query box. Follow these steps.

Write the query
--->Click the Query Designer toolbar button inside the Data tab to display the full query designer user interface. --->OK
 


How to drag the name in table column of Dataset.

Drag the name in table column. 


How to drag the type in table column name of Dataset.
Drag the type in table column name.  


How to drag the create date in table column name of Dataset.

Drag the create date in table column  name.


How to set Background color in table column. Follow this step.

Click format--->Background color


Go to format  ---> Background color  --->  Select color --->OK.
 How to Set Foreground color in table. Follow this step.

Go to format --->Foreground color


Go to format ---> Foreground color---> Select color ---> OK.

Go to report properties.

 How to fill target server URL.

Go to report properties
--->fill the target server URL   for your Report Server. If you're developing on the same computer where Reporting Services is installed, and you installed in the default configuration,--->OK


How to build the Report Project.

Right Click Report Project --->Build


Show output from build.

How to Deploy the Report Project.
Right Click Report Project --->Deploy

Show output from Deploy.

Go to Start---> All Programs---> Microsoft Sql Server 2008--->  Configuration tool--->Reporting services configuration manager.
 

Now click connect.

How many types of URL in Reporting services configuration manager.

Two types of URL in Reporting services configuration manager.
  1.  Web service URL. 
  2. Report manager URL.

Web service URL: - this type of URL fills the target server URL.Web service URL: - This type of URL fills the target server URL. Use the Web Service URL page to configure or modify the URL used to access the report server. A URL reservation will be created based on the URL you specify. The URL reservation defines the syntax and rules for all URLs that can be subsequently used to access the Report Server Web service. It specifies the prefix, host, port, and virtual directory for the Report Server Web service. Depending on how you specify the host, multiple URLs might be possible for a single reservation. The default value for the host specifies a strong wildcard. A strong wildcard allows you to specify in a URL any host name that can be resolved to the computer that hosts the report server. For more information about URL configuration and reservations

Then Fill user name and password ---> OK
   
Report manager URL: -Report manager URL: - Use the Report Manager URL page to configure or modify the URL used to access Report Manager. By default, the Report Manager URL inherits the prefix, IP address, and port of the Report Server Web service URL. This is because Report Manager provides front-end access to the Web service that runs within the same Report Server service. If you are isolating the service applications and using Report Manager to access a Report Server Web service on a different computer, you must edit RSReportServer.config file to point Report Manager to a different instance. For more information about configuring a Report Manager connection to a remote report server
 

Right-click on the report and select View Report. The report will open in your Web browser.The final report below.

4 comments:

Anjani kumar said...

very nice this step by step ssrs.

vikash said...

i want to joint this blog becuz its helpful for me

Anonymous said...

Very usefull for beginner.. thanks

sumit said...

very nice post

Recent Posts