How to connect Oracle Data Source for Reporting Service

I have the problem to connect Oracle data for my Report designer.

1st I used ODBC, it does not work, and my reference book "MS SQL server 2000 Reporting service step by step" tells me that I must select Oracle data provide instead of the generic ODBC.

I created a new data source and after I enter the userId/pswd and click "Test Connection" button, it is OK. But when I click "run" icon to try, it gives me the following error messages:

An error occurred while executing the query, ORA-00936:Missing expression

Additiona information:

ORA-00936:missing expression(system.Data.OracleClient)

My version of reporting service is 2005. The setting of "Connection Properties" as follows:

Data Source: Oracle (OracleClient) Server name: creonpra Log On to the database: UserId/Pswd= qmprodviewer/*********

I have very less knowledge about Oracle. I do not know Oracle Client software's coverage. I checked my program and only find Oracle 8i of "Net8 Assistant", "Net8 Config Assistant" and Oracle ODBC test" on my desktop PC.

Please help me to resolve the problem

Hi,

This looks like a query syntax error.

Did you use the query builder to create your Oracle query?

If you paste your query in a new database project can you execute it?

I would recommand to use the database project or Toad to debug the query, then when it is working, paste it back to your report dataset.

Philippe

|||

Yes definitely a syntax problem. Along with the other suggestion of trying it in the Oracle also try simple expressions first like...

select * from Table1

etc.

If your still stuck past the Syntax here and I can have a look at it since I connect primarily to Oracle DB's using the Oracle connection.

Craig

How to combine different data regions in a single report?

Hi, all here,

I am trying to use report designer to create a single report with chart data region and table data region combined within the same report. Would anyone here please guide me how to work it out? Thanks a lot.

With best regards,

What do you mean by combined? You can put several data regions in a report and each can have their own datasource or share the same. If you want to have a chart data region inside a table data region, then I believe that cannot be done. If you could be a little more specific as to what you want to accomplish that would help to answer your question.|||Hi,Itzeld,thanks, got it done.