473,385 Members | 1,927 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How do you use ReportViewer to display a Reporting Services report?

S_K
Hi and thanks in advance for your help.

I have a Reporting Services report that I need to display in an
ASP.NET web page using the ReportViewer. However I can't link the
Reporting Services report (.rdl) to the ReportViewer! I have the
ReportViewer.LocalReport.ReportPath set to the path of the .rdl report
but the report still dosen't display.

Can somebody help me on this?

Thanks

Steve
Jul 1 '08 #1
3 3388
I may miss some steps here, but I'll come as close as I can, from the top of
my head.
It's not as simple as just copying the files -
First - you need to rename the .rdl file to .rdlc
You'll need to create the datasets in your ASP.Net application also
Also - if you're using parameters, you will need to create the controls in
the page, separately, and then use an event of some sort (button, etc) to
trigger running the report

I just copied some code here:
(this is for use with 2 date text parameters - you'll need to make the
reportviewer invisible at the start, then, when executing the code:)
Dim dsSource As ReportDataSource = New
ReportDataSource("DataSetName_DataTableName", MethodName(txtStartDate.Text,
txtEndDate.Text))

rpt.Visible = True
rpt.LocalReport.DataSources.Clear()
rpt.LocalReport.DataSources.Add(dsSource)
rpt.LocalReport.Refresh()

This is fairly close - you'll need to change it up a little for your own
needs, but as you can see, it's not just a drop and use type of situation.
Hopefully this will give you a start

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup
"S_K" <st***********@yahoo.comwrote in message
news:71**********************************@g16g2000 pri.googlegroups.com...
Hi and thanks in advance for your help.

I have a Reporting Services report that I need to display in an
ASP.NET web page using the ReportViewer. However I can't link the
Reporting Services report (.rdl) to the ReportViewer! I have the
ReportViewer.LocalReport.ReportPath set to the path of the .rdl report
but the report still dosen't display.

Can somebody help me on this?

Thanks

Steve

Jul 1 '08 #2
Follow-up:
In the previous scenario, when using the smart tag, you would choose 'NONE'
when choosing datasources, but you can choose the .rdlc file

David Wier
http://aspnet101.com
http://iWritePro.com - One click PDF, convert .doc/.rtf/.txt to HTML with no
bloated markup
"S_K" <st***********@yahoo.comwrote in message
news:71**********************************@g16g2000 pri.googlegroups.com...
Hi and thanks in advance for your help.

I have a Reporting Services report that I need to display in an
ASP.NET web page using the ReportViewer. However I can't link the
Reporting Services report (.rdl) to the ReportViewer! I have the
ReportViewer.LocalReport.ReportPath set to the path of the .rdl report
but the report still dosen't display.

Can somebody help me on this?

Thanks

Steve

Jul 1 '08 #3
S_K
On Jul 1, 3:35*pm, "David Wier" <d...@dw.comwrote:
Follow-up:
In the previous scenario, when using the smart tag, you would choose 'NONE'
when choosing datasources, but you can choose the .rdlc file

David Wierhttp://aspnet101.comhttp://iWritePro.com- One click PDF, convert.doc/.rtf/.txt to HTML with no
bloated markup

"S_K" <steve_kers...@yahoo.comwrote in message

news:71**********************************@g16g2000 pri.googlegroups.com...
Hi and thanks in advance for your help.
I have a Reporting Services report that I need to display in an
ASP.NET web page using the ReportViewer. However I can't link the
Reporting Services report (.rdl) to the ReportViewer! I have the
ReportViewer.LocalReport.ReportPath set to the path of the .rdl report
but the report still dosen't display.
Can somebody help me on this?
Thanks
Steve- Hide quoted text -

- Show quoted text -
Thanks that looks like it will work!

Jul 1 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Fabio Pagano | last post by:
I was wondering why is there so little interest on the reportviewer control and the report designer integrated in VS 2005. It seems very cool and i think it can replace Crystal Reports. Moreover,...
0
by: David Dvali | last post by:
Hello. I have just started using Microsoft Reporting tools and I like it very much. I'm using Microsoft SQL Server 2005 and Microsoft Visual Studio 2005 for generating reports in my ASP.NET web...
4
by: ME | last post by:
I want to generate a simple report that will display information from my customer table in a report format. I created a simple Customers.rdlc file that contains three text boxes bound to ...
0
by: SSunnergren | last post by:
I hope someone can assist me. I am trying to implement the ReportViewer Control using VB.NET in VS2005. I am using server reports on a Reporting Services server on a domain server. ...
1
by: steve | last post by:
Hi All I need help on how to manipulate the data returned from the database for displaying in the new reportviewer at runtime So far I have an rdlc file with a dataset, binding source and...
4
by: Sevu | last post by:
I am working with ASP.NET.I am using ReportViwer Control to show my report.I like to add dropdownlist with in the reportviewer control. ( Not top to the control some thing like that).I need to...
1
by: Rich | last post by:
Hello, I am trying to use the Reportviewer control. I have been following an example from the web, and the instructions from the help files on set up a ..rdlc and binding it to the reportviewer...
4
by: =?Utf-8?B?SGVyYg==?= | last post by:
Using the WebForms.ReportViewer when I export to PDF, the margins of the report are too large. How can I change the margins of my report to make better use of the printed page space?
5
by: =?Utf-8?B?Y2hlY2tyYWlzZXJAY29tbXVuaXR5Lm5vc3BhbQ== | last post by:
I have a VS 2008 ASP.NET webform that has a reportview tag on it, accessing an .RLDC report in local report. The columns for the report are essentially: Month Item #1 Item#2 Item#3 ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.