Crystal Reports & Stored Procedures

January 31, 2007 4:07 PM

I have a Crystal Report which loads data from a stored procedure. The client wanted some new fields added to the report, so I added them to the stored procedure. (They've been added to the database, as well.) I cannot add them to the report, though, because they are not showing up in Crystal Reports' field explorer.

I have tried hitting Refresh repeatedly, disconnecting and reconnecting to the database, and have verified that I updated the right SP, but crystal reports still doesn't list the new fields. I am afraid to remove and re-add the stored procedure because I don't want to have to recreate the report. My google-fu have only yielded one similar question, and the corresponding answer is useless. I've also restarted Crystal Reports entirely and Verified the Database.

Any help would be most appreciated.

Thanks!

posted by chillax to Computers & Internet (4 answers total)

I'm no expert - so maybe this is a stupid thing to say - but if the new fields were added to the database, can't you just modify the query so you grab those fields?
posted by crapples at 6:09 PM on January 31, 2007

This would be easier to diagnose with the actual SP code. What DBMS are you using? I'm assuming the SP returns a cursor, so I take it you added the fields to the cursor it's returning? What happens when you run the SP from somewhere else?
posted by cerebus19 at 6:33 PM on January 31, 2007

Chillax posted this question on my behalf, so I'll answer your questions.

crapples - The query in the SP has been modified to SELECT the new columns from the database, however the new fields are not showing up in Crystal (although they are returned as expected in the result set from the SP).

cerebus19 - I don't think the problem lies with the stored procedure. I am using MS Sql Server and have executed the stored procedure from Query Analyzer (a program used to, among other things, execute queries). The stored procedure returns the new fields as expected.
posted by !Jim at 8:16 PM on January 31, 2007

Best answer: You may have to delete the sp datasource on the CR client and reload it to get the new fields.

There's a way to replace a sp with another that escapes me at the moment, but you could replace the sp with itself and it should reload the fields.
posted by koudelka at 8:55 PM on January 31, 2007