I am trying to get the ReportViewer to work in VS2005 Professional.

1) Created a connection to the Oracle 10g Database in the Server Explorer.
2) Created an empty 'report.rdlc' file.
3) Created an report.aspx with a ReportViewer bound to the 'report.rdlc'
file.

The documentation states that I should add a Project Data Source by dragging
tables and fields from the server explorer.  This does not seem to work.
Can RDLC Reports be used with an Oracle Data Source?

thanks,

- Will

Hi, i have used rdlc with the informix database. What is did was add a empty
dataset to the rdlc and i have a business layer (a vb class) which has a
function which returns a dataset. When you add a report to the page add an
objectdatasource and specify the type as the vb class and the select method
as the funtion. This works for me.

Show quoteHide quote

Houston Lucifer wrote:
Can you expand on this?

I'm trying to do a similar thing with the report viewer...I need to use an oracle stored procedure to get the data.

The TableAdapter wizard only works with SQL Server.  But if I could use the object datasource to get the data from a vb class that would be great. 

I created a new dataset.xsd file and added a "datatable" with a couple columns that match to what my object datasource will return.

I save the xsd and it shows in my report designer.  So I drag them onto the report into a "table" object and save it. 

Running the report doesn't return any data. 

How do I connect these two fields in the dataset.xsd/report.rdlc (name, org_id) to the fields that the object datasource returns?  I know the object datasource works fine because I hooked it up to a gridview and it displays what I want.

Normally this would be done in the dataset.xsd file, but like I said I can't do it there since it's with oracle stored procedures.

Thanks,
-Mobes -- Mobes ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

Datagrid only shows the header
Wizard Control - Referencing buttons in <StepNavigationTemplate>
Master Page problem
ck_Problems
CheckBoxList problem. Want to add some javascript to each checkbox
Custom memebrship provider problem
Sorting in GridView problem
User Control First Load
Cant get a gridview to bind to my dataset
Implement form's onSubmit functionality