Post reply

Find list of stored procedure is used by crystal reports.

  • July 1, 2015 at 9:36 am

    #318646

    Hello

    We have more that 500 crystal reports and we would like to find out list of stored procedure used by crystal reports.

    Can we find out ?

    Thanks

  • July 1, 2015 at 9:48 am

    #1809577

    There's nothing in the properties of a stored procedure that says what it's used for. I'm not familiar with Crystal Reports - does it create stored procedures that have a comment block of a certain format at the top? Or can you interrogate the Crystal Reports database to look for stored procedure names (you can't in SSRS because the definitions are hashed)? Are we talking about stored procedures on one server here, or several?

    John

  • July 1, 2015 at 11:14 am

    #1809610

    Only One Server

  • July 1, 2015 at 11:20 am

    #1809614

    patla4u (7/1/2015)

    Only One Server

    Crystal Reports report files have the .RPT file extension, and the data is not readily consumable, so I know of no possible way to programmatically get such a list.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

  • July 2, 2015 at 2:04 am

    #1809736

    You could run a trace or extended event or something to capture the SQL that is being run by Crystal Reports. Obviously this isn't going to capture stored procedures for reports that are never run, though.

    John

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply