Oracle 9i view not showing data in CR XI

[bigodwg]

Oracle 9i & Crystal reports XI.

I have a new view that I am trying to select detail data from and the report does not return data.

There are no filters or parameters. I can select from the view in SQL*PLUS, toad, Excel etc....
I can see all other views in the schema.

I have been using Crystal for several years and have never seen this before.

I can cut and paste the SQL from the report and run it in SQL*PLUS and get results.

Any clues?

 

[synapsevampire]

It might be your connectivity.

Try switching to the Native connectivity for Oracle (listed as Oracle Server). In either case, explain how you're connecting if this fails.

-k

 

[Turkbear]

Hi,
Can we assume that other reports accessing this same database instance run OK with both tables and views?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bigodwg]

The database is defined as an Oracle Server connection and all of the other views produce data.

 

[bigodwg]

Yep - every other table and view run just fine

 

[Turkbear]

Hi,
Juat a couple of thoughts:

In the report, are there any Group or Record selection formulas that may not be in the Sql Query ( not passed through)?

Can a new simple report that just uses that view return data ( no selection criteria, no formatting, just drop 1 or 2 fields from the view into the details section and let 'er rip..)?








To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bigodwg]

I had attempted to do exactly what you second point was. To create a no frills report with just to fields from the view.

And no - no data was returned. Yet, I can still extract data from the view in either SQL Plus, Excel, or even BRIO.

 

[synapsevampire]

Very odd indeed, providing you're using the same connectivity and user/pw.

Perhaps there's another View or a Synonym by the same name in a schema that you're inadvertently hitting?

You might also try ODBC...

Ask the dba to do a trace on the query.

-k