Results 1 to 2 of 2

Thread: CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.How do

  1. Mar 19th, 2007, 09:21 AM #1
    ragstta
    ragstta is offline

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

    CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.How do

    CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.

    How can i make the subreport pass the parent reports Parameters to the subreports sql-stored-prcs.

    i.e. how do i map parent report parameters to the subreport storedprc parameters so that it does not ask for them during VB Automation?
    Reply With Quote Reply With Quote
  2. Mar 19th, 2007, 09:58 AM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: CrystalReport with a subreport that uses a SQL StoredProcedure with Parameters.How do

    Right click on the Sub-Report and then choose the "Change Sub-Report Links" menu item. On the screen that appears it is just a matter of setting the right options. Just make sure the fields/formulas you select from the main page, have the same datatype as the parameters of the stored procedure.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width