Post reply

Connecting from Crystal Reports

  • May 2, 2003 at 8:24 am

    #82165

    My users currently run scripts on Crystal Reports to query the SQL Server database. I want to create stored procedures on the SQL Server and have them run the sp's from Crystal Reports. I'm at a loss as to how to have Crystal Reports run the query. Can anyone point me to some good material (BOL, whatever) that I can use to learn how to do this?

    -SQLBill

  • May 2, 2003 at 8:53 am

    #456006

    Build the SQL String using the SP name and all parameters then put where you normally insert the Query string in the code. Works just fine.

  • May 2, 2003 at 11:18 am

    #456048

    SQLBill, when you open Crystal reports, open a blank report and select your ODBC connection and within that you can then select the stored proc that you want to use.

    Works great and it is better security.

    HTH,

    Robert

  • May 2, 2003 at 11:56 am

    #456059

    Thanks to both of you. I wanted to do this for two reasons....better security and some of my user's queries were crashing their systems and taking too long. This way the query will use the power of the SQL server system.

    So, thanks to both of you.

    -SQLBill

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

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