Re: Web Application Project - ReportViewer Control

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Steven,

My project already contains business object classes that return datatables,
for accessing all data, so it would be good to be able to utilize them and
not have to create new datasets for every report.

Therefore, I am trying to go with your option 2.
The smart tag choose datasources does not work the way you indicate. The
option is not available until a report has been created and then there is no
option for 'new data source', or for 'show only data components'.
Therefore, I followed your aspx example.

The thing here is that the report does not recognize the datasource, so it
can't be designed.

How can I get the report to recognize the datasource in order to design it?

--

AG
Email: discuss at adhdata dot com
"Steven Cheng[MSFT]" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OH8YFjw4HHA.6140@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi AG,

From your description, you're wondering how to supply the DataSource for
the webform reportviewer control in an ASP.NET Web Application Project,
correct?

Based on my understanding, for webform reportviewer, you can supply the
datasource through the following means:

1) if you use the .NET built-in typed DataSet/TableAdpater components, you
can simply add a new typed DataSet(with TableAdapter) and the DataSet
class
will appear in the VS 2005 ide's "Website Datasource" window. You can drag
the certain table's properties(columsn) onto the client report(rdlc)'s
design surface.

#Walkthrough: Using a Database Data Source with the ReportViewer Web
Server
Control in Local Processing Mode
http://msdn2.microsoft.com/en-us/library/ms252123(VS.80).aspx

#the DataSet approach will work in both website project and Web
Application
Project.



2) Or if you're using some custom class(which return the DataTable or
typedDataTable ), it seems the built-in "WebSite Data Source" windows can
not display it at design-time. One way to workaround it is as below:

1. In the SmartTag for the Report Viewer control, click Choose Data
Source.

2. In the Choose Data Sources dialog, click inside the Data Source
Instance
column and choose New Data Source.

3. Choose Object in the list of data sources.

4. In the Choose your business object combo-box, you should already see
the
name of the Table Adapter that your report will use when it pulls
data...choose it. Or if you do not see your custom class, uncheck the
"show
only data components" option so that all businesss classes will be
availale
in the list:

5. Finish off the wizard...you now should be in good shape.



Or you can also manually select to use a custom class in aspx template:


============================
<rsweb:ReportViewer ID="ReportViewer2" runat="server" >
<LocalReport ReportPath="ClientReport1.rdlc">
<DataSources>
<rsweb:ReportDataSource
DataSourceId="ObjectDataSource2" Name="DataSet1_rpt_table" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:ObjectDataSource ID="ObjectDataSource2" runat="server"
SelectMethod="GetDataTable"

TypeName="WAPTestProj.MyDataSourceClass"></asp:ObjectDataSource>
=============================

Here the "WAPTestProj.MyDataSourceClass" is a custom class as below:

===========

public class MyDataSourceClass
{
public DataSet1.rpt_tableDataTable GetDataTable()
{
DataSet1TableAdapters.rpt_tableTableAdapter ta = new
DataSet1TableAdapters.rpt_tableTableAdapter();

DataSet1.rpt_tableDataTable table = new
DataSet1.rpt_tableDataTable() ;

ta.Fill(table);

return table;
}
}
==================

In addition, you can also programmatically create and add datasource for
ReportViewer control. Here is a web forum thread discuss on this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1770944&SiteID=1

Hope this helps some.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.






.

Relevant Pages

  • RE: Data Source View - Copy from OLAP to Reporting?
    ... manage the DataSource and DataSourceViews through the .ds and .dsv files. ... in new Report Module projects from another existing Analysis project, ... | I have a Data Source View in my Analysis Services Project project. ...
    (microsoft.public.sqlserver.olap)
  • Changing datasource for a report at run-time
    ... Below is the my code for running a report through the Crystal Reports ... How can i change the datasource at run-time (this ... I couldnt see a property for changing the data source. ...
    (microsoft.public.vb.crystal)
  • Re: Starting a Pen-Testing Career
    ... Perhaps my perceptions of the business are a bit naive, ... Buinsesses don't care about security and vulnerabilty and exposure. ... How else would they be able to provide such a report in isolation - ... written vulnerability scanner' to produce reports. ...
    (alt.computer.security)
  • Re: Starting a Pen-Testing Career
    ... How else would they be able to provide such a report in isolation - ... and making their business plans work to worry so much about security. ... they hire a pen-tester or ethical hacker to tell them the things ... informed as to how the vulnerabilities exisit, how they can be exploited and ...
    (alt.computer.security)
  • Re: OT ~ RatherGate Resurfaces
    ... it's right there in the report. ... MY point is that the Bastard Media only prints or brodcasts ... the way the business works. ... carried the story and one of these phantom power plants was supposed to be ...
    (rec.outdoors.rv-travel)