472,982 Members | 2,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Reportviewer Control - data not displaying

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 control. The help files state that
in the form the contains the reportviewer control there is a tasks smart tags
panel in design view. I don't see any such thing. Where do I need to look
to see this panel?

So I have been trying to follow an example on the web that sets up the
reportview control through code. I created the data soucrce (my .rdlc file)
which I named Report1 and planted the following code in the form load event.
When I execute the form, the reportviewer control shows some gif that says
"generating report". When it is done, I do not see my test data.

The data source is a plain table called "tbl1" which resides in a
sqlserver(2000) DB. The table contains 4 columns and about 6 rows of
data. I can see the data in visual studio designer when I preview the data
from the .rdlc. Here is the code:

Me.Tbl1TableAdapter.Fill(Me.Subscriber6DataSet.tbl 1)
RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
RV1.LocalReport.ReportPath = "C:\Code\TestProj\Report1.rdlc"
RV1.LocalReport.DataSources.Add(New
Microsoft.Reporting.WinForms.ReportDataSource("tbl 1"))
RV1.LocalReport.ExecuteReportInCurrentAppDomain(Sy stem.Reflection.Assembly.GetExecutingAssembly().Ev idence)
Me.RV1.RefreshReport()

Could someone tell me what I am missing or need to change? or could someone
tell me what the reportviewer control tasks smart tags panel is? Or where to
look for it?

Thanks,
Rich
Sep 15 '06 #1
1 17769
I got it going. The key is to be able to read the instuctions. So here is
what I did (for posterity)

First I add a dataset from the Solution window - right click on the solution
title - goto Add - add the new dataset. Then I use the wizard in the
datasource tab of the solution window. Right -click on the new dataset I
just added and grab a table from the sqlserver DB. Now I have a typed
dataset with a datatable.

Next I add a Report to the project. From the solution window - solution
title - right click -goto Add - Add a new Report - which will be of type
..rdlc. In the report designer I drag a table from the toolbox onto the
Report canvas. Then, from the solution window/datasource tab, I expand the
dataset, expand the table and and drag each column of the datatable to the
desired detail cells in the table I just dragged into the Report canvas in
the Report designer. This automatically binds the dataTable columns to the
cells in the Report Table.

Next, I drag a reportviewer control to the form from the toolbox. The
control will have a dropdown asking what report to bind to. I select the
report I just added to the project. This will generate some autocode behind
the form in the Form_load event: It add this code:

'TODO: This line of code loads data into the 'DataSet1.tbl1' table. You can
move, or remove it, as needed.

Me.tbl1TableAdapter.Fill(Me.DataSet1.tbl1)

Me.RV1.RefreshReport()

Now I can see the data. Ideally, I would like to do this more dynamically
so I can report on data not stored on a disk, I guess that would be a list.
Well, at least I can now see some data.

"Rich" wrote:
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 control. The help files state that
in the form the contains the reportviewer control there is a tasks smart tags
panel in design view. I don't see any such thing. Where do I need to look
to see this panel?

So I have been trying to follow an example on the web that sets up the
reportview control through code. I created the data soucrce (my .rdlc file)
which I named Report1 and planted the following code in the form load event.
When I execute the form, the reportviewer control shows some gif that says
"generating report". When it is done, I do not see my test data.

The data source is a plain table called "tbl1" which resides in a
sqlserver(2000) DB. The table contains 4 columns and about 6 rows of
data. I can see the data in visual studio designer when I preview the data
from the .rdlc. Here is the code:

Me.Tbl1TableAdapter.Fill(Me.Subscriber6DataSet.tbl 1)
RV1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
RV1.LocalReport.ReportPath = "C:\Code\TestProj\Report1.rdlc"
RV1.LocalReport.DataSources.Add(New
Microsoft.Reporting.WinForms.ReportDataSource("tbl 1"))
RV1.LocalReport.ExecuteReportInCurrentAppDomain(Sy stem.Reflection.Assembly.GetExecutingAssembly().Ev idence)
Me.RV1.RefreshReport()

Could someone tell me what I am missing or need to change? or could someone
tell me what the reportviewer control tasks smart tags panel is? Or where to
look for it?

Thanks,
Rich
Sep 15 '06 #2

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

Similar topics

4
by: Raghu | last post by:
I have developed a web portal that uses ReportViewer web control to connect to a remote SQL 2005 Report server and displays the reports on the client side. The asp.net page has been coded to...
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...
0
by: Rich | last post by:
Hello, I started using the Reportviewer control (very nice) for generating Reporting Services type reports in my VB2005 app. I have been experimenting using a designer Reportviewer control from...
0
by: Fred G. Sanford | last post by:
Firstly, I am a fairly new .Net developer, so please excuse any dumb/ignorant questions or comments. Thanks. I created a VWD Express project, which uses the ReportViewer control, on my local...
0
jgroos
by: jgroos | last post by:
Here is my scenario: I have two different reports processed LOCALLY, lets say Report1.rdlc and Report2.rdlc. They both are populated with data from a database, and they both also take a list of...
10
by: AG | last post by:
I am trying to use a ReportViewer control in a VS 2005 web application project (not Website project). When I try to create a new report (local), I can't seem to find any method to create a...
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 ...
1
by: gandhi.vishal | last post by:
Hello, I have an issue. I'm not seeing the reportviewer data at all. The column names come up fine but there is no data in the report table. Here is what I'm doing I created a dataset with the...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

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.