Results 1 to 2 of 2

Thread: Report/Sub-Report Parameter Linking

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Feb 2002
    Location
    Allen, Texas
    Posts
    125

    Report/Sub-Report Parameter Linking

    Greetings,
    I have one report that gets data from a stored procedure, I have a sub-report that is ran with its own stored procedured.

    They are both grouped together.

    Heres what I want. I want [Report 1].[Field 1] to be passed to the parameter of the second report so each time it changes the group, the subreport is updated.

    Any ideas?

  2. #2
    Hyperactive Member ARPRINCE's Avatar
    Join Date
    Mar 2003
    Location
    Pinoy in NJ
    Posts
    381
    This is how I do it for CR9.

    I create my main report using the SPROC. After all is well and done, I insert a SUBREPORT using the "Insert Subreport" icon on my toolbar. Proceed to create a subreport with reference to your other SPROC. When done, click on the "LINK" tab to link your MAIN REPORT to your SUB REPORT using a field that is common to both.

    Hope this helps.
    Attached Images Attached Images  

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