Skip to Content
Former Member
Dec 11, 2012 at 09:19 PM

extracting where clause info out of crystal report stored procedure


On dec 5 I asked this question and got a really good answer

I been about to extract all the info out of CR which is great

I have only one question left


If that a way to read whats in the where clause of the stored procedure attached to the crystal reports and be able to report it.

If i could do this it be really really great.

Or really just be able to read the where statements of stored procedure and report them.

Thanks in advance for all your help

The main problem we have like so many I am sure that the stored procedure does not match the name of the report

Is there a way to get this info?

if i open a crystal report


set datasource location

drill down for the name to the properties

its the table name

i found some stuff saying it is in the reportdocument.database.table true or not?

i am a VB .net programmer

thanks John