Monday, August 9, 2010

Creating and Publishing a report with Report Builder 2.0 in SQL Server 2008.

Start -->All programs--> Microsoft SQL Server 2008 Report Builder 2.0 will bring up the following display. Click on Report Builder 2.0.

The Report Builder 2.0 gets displayed as shown then Double click the Table or Matrix icon.

Configuring the data source.
This displays the New Table or Matrix window as shown.
Click on the New... button.

This brings up the Data Source Properties window as shown. Click on the drop-down handle for "Select connection type:" as shown. Then Click on the Build... button.

Fill the Server Name and Select or enter the data base name then click on the Test connection--> OK

After completing the data source connection configuration above then click next to design a query for your report.

Click the table EMP then NEXT.

Click next to get the Arrange fields-dialogue box where you can drag and drop your data fields into the Row groups.

 Click next to choose the layout for your report.

Choose a style feature different fonts and color schemes for your report then click finish.

 After the finish this displays window as shown.

Click the RUN or F5.

Report is shown.

1 comment:

sonu said...

Very Helpfull, thank you for posting!

Recent Posts