Accessing stored procedures with Crystal Reports
Posted in 2004
Topics: Installation, Setup & Upgrades, Stored Procedures & SPL, Versions, Editions & End-of-Life
Hi, I'm having trouble accessing stored procedures in Crystal Reports on IDS 9.30.UC5. In Crystal, going to main menu -> Database -> Set Location should display tables and stored procedures (if there are any) for a selected database, if "show stored procedures" is checked under Options, which is checked. Only tables are shown and can be selected. I am editing a report that was made when this error apparently was not occuring, so there are references to stored procedure fields already on the report and they are working fine when the report is run. I just can't seem to add any new fields from the stored procedure. Thank you in advance! By the way, same thing is happening with Borland's SQL Explorer. Only tables can be viewed, when I try clicking on stored procedures, "capability not supported" error comes up. I believe this was not the case before an upgrade to 9.30.UC5.