i am trying to build the simplest report using CR XI and an Oracle database, probably version 8i. When just dumping all fields of a table from any table in the database the report just traverses all rows in the table and all subsequent filters seem to work.

 

I have one table though that is not working: I select a column from the table, I click Preview and I get the error message Failed to get data from the database - when clicking OK I get another error message saying the same plus Detail: something about the ODBC connection and and ORA000904 invalid column name.

 

Anybody has any idea what's happening?

If you need more details I am ready to provide them - I just wander if it is something trivial.

Thanks,

kowalsky

It turns out that the table I was trying the report on, was actually generated in duplicate by a script that was supposed to populate it. Apparently SAS is quoting eveything and when I was running the SAS script that was supposed to populate my table MYTABLE, actually it was looking for mytable (lower case) did not find it and created one with the same columns - hence: some of the columns were of different type than the original ones in MYTABLE which were created with a CREATE statement and the ones (columns) that "were working" reported double the number of rows because CR 11 did traverse both tables mytable and MYTABLE and brought back all rows encountered.

Next time I will use sqlldr to populate my table,

Thanks a bunch,

kowalsky