Using SQL in CR 9

[Daviboysmith]

Hi,

I am new to CR and have come accross an issue and have hit a brick wall. What I need to do is run a SQL on a DB2 DB which will fetch client records in a decending order (by date) and get the latest record. I have to create few summary fields based on that record. The problem I am having is that the Month and Year fields are seperate. But before I can even get to that Issue, I have been unable get any SQL to work in CR 9 Adv ver. Your help is greatly appreciated.

Thanks

Dave

 

[TimT12]

Can you create a stored procedure which will do what you need? Probably be much faster than SQL in the report.

If that's not an option, there are so many complexities, that it would be tough to answer your question without having someone troubleshoot your setup.

-Tim