database connectivity issue - no data

[Lhuffst]

I created views in sql direct (oracle) and they all return data. In CR 2008, I select the view fine but when I drop the field onto a report or even just browse the field, all are blank.

I checked the options and made sure stored procedures was unchecked but what else can I check.
As an oddity, this report ran a few months back but once we refreshed the test database (area I'm working in), it is not showing any data now.

Any suggestions anyone?
Thanks
Lhuffst

 

[Lhuffst]

Just discovered that while I saw the data in sql (I use toad), it didn't actually run the last commit and that's why the crystal reports side was missing my data.