//
you're reading...
ASP.NET, Database, IT-Center, SQL Server, Web Based

Publish Reporting Service SQL Server 2005 in ASP.NET

A. CREATE REPORT (.rdl)
1. Create new project from VS2005 (installer from SQL Server 2005), NEW > Business Intelelligence Projects > Report Server Project

2. At Solustion Explorer right pane, right click Report > Add New Report >. Set your dataset and query.

3. Using tab dataset if you want add new Dataset

4. Parameter.
filtering data with automatic object filtering list with parameter menu.


5. Run, click run in ReportName right click

<OPTIONAL : DRILL DOWN>
a. Right-Click on Body > Insert Group
b. Right-Click in Your Group Row and choose Edit Group (have icon like Number “1”), In General tab added Expression and save.

c. Right-Click in Row (Non-Group) , choose edit group and Choose Visibility tab, setting like picture.

B. PUBLISH .RDL REPORT at  IIS
Start Menu > run > inetmgr
If you have SQL Server 2005 Installation, in WebSites folder will have Report Virtual Directory. Right Click at Report Virtual Directory and browser.

Create New Folder if you want grouping your report, and choose upload file to publish your .rdl file.

Don’t forget to set your DataSource host and database name to make connection :

Important to set Datasource like “Data Source=host; Initial Catalog=DBNAME”

Using view to showing your report, Using properties to handle config connection and security

PUBLISH REPORTING USING SOLUTION
1. Right-click at solution and properties, set Datasource target Folder,Target Report Folder and Target server URL = http://hostname/ReportServer , if using not default instance   http://hostname/InstanceName$ReportServer
2. Right -Click Solution and Deploy

 

C. OPEN REPORT WITH ASP.NET
Create New Project ASP.NET using VS2005 sp1 with Web Project. File > New > Visual Basic > Web > ASP.NET Web Application.
Drag ReportViewer to design form and setting Report Server URL=http://localhost/reportserver and Report Path=/LatReport/ReportUserList  with leading /   (  /FOLDER/REPORT_NAME  )

Run your website and see the report include in your form.
Example Link : http://localhost/ReportServer/?/FOLDER/REPORT_NAME

About berbagisolusi

Berbagi merupakan sebuah bentuk simbol keikhlasan untuk membantu dan menolong, sedangkan solusi adalah cara menyelesaikan masalah. Setiap manusia pasti mengalami masalah, tetapi kita tidak perlu mengalami masalah yang sama jika orang lain pernah mengalami dan kita tahu hal tersebut.

Discussion

No comments yet.

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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 9 other followers

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Archives

Web Statistic

Blog Stats

  • 149,580 hits
%d bloggers like this: