Designing a report in SQL Reporting Service 2008 R2 and showing that report in asp.net web application

Total 2 steps:
Part-1: Design & Deploy the report in SQL Server Business Intelligence Development Studio
Part-2: Call that report in asp.net application

Part-1: Design & Deploy the report in SQL Server Business Intelligence Development Studio
1. Design: coming soon
2. Deploy:
2.1. Project–>Report Properties

2.2TargetServerURL: http://ms10-mmi:8080/ReportServer

2.3 Build–>Deploy Report

 

2.5

Part-2: Call that report in asp.net application
1. Add a scriptmanager from ajax extension

2. Add Report–>ReportViewer from tools

3. asp.net Code for aspx file.

All Done

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s