Results 1 to 2 of 2

Thread: Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jan 2007
    Location
    England
    Posts
    64

    Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source

    hi all

    Can i set a Crystal Parameter to be the Paramter of a storedprc which is the data source?

    Using a SQL Server Stored Procedure to populate a crystal report. the stored prc requires parameters. Im running the crystal report via VB automation.. how can i tell crsytal to use parameters im passing to it as the parameters for the storedprc call??

    thanks

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Can i set a Crystal Parameter to be the Paramter of a storedprc which is the source

    It should be automatic. Crystal creates a report parameter for every parameter in the sproc, at least it does for me... The parameter's value is then automatically passed to the sproc when the report executes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width