Crystal Reports - Browse Data Shows Nothing

Question

I just created a new table and filled it with data. When I run a simple select query, I can see all the data.

But when I try to build a report in Crystal with this table, I get no data. It doesn't matter if I have other tables included or not, so it isn't a linking issue.

If I right click a field and choose "browse data", I get nothing, which tells me that somehow Crystal can't read the data at all.

I created the table with the same user name/password that I used when connecting to the database from Crystal Reports.

Any ideas?

(If it matters, I'm using Oracle 10g Release 1 and Crystal Reports XI Release 2. We use a direct Oracle connection, not an ODBC.)

Answer 1

I found the problem. I hadn't yet committed the data on the database.

This taught me something about Oracle. I rarely use the "commit" command - but when I have created tables and filled them with data it's been via a "select" statement. Those tables have always worked. This time I did it via the insert all command. I needed to commit for that to work!