Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2005
    Posts
    2

    Unanswered: Undefined number of subreports in a single report

    A report (Crystal Reports 10) uses two stored procedures proc1 and proc2. proc1 returns numbers a_1, a_2, ... , a_n (n is undefined). Then I need to use every of theese numbers as in-parameter for proc2. So i need to call proc2 n times for every a_i and every time place the resulting data of proc2 to main report (one group after another).
    It seems to me I should use sebreports to built every group of data. But I don't know how? My problem is undefined number of such subreports (grouping is not a problem).
    Last edited by gpav; 01-09-05 at 06:56.

  2. #2
    Join Date
    Jan 2005
    Posts
    2

    Solution

    I've solved the problem!
    1. Main report uses only proc1 and it must be grouped with the field {proc1.a_i}.
    2. Subreport uses only proc2. I placed subreport into group detailes of the main report.
    3. Then I opened "Subreport Links" (right-click on subreport->"Change Subreport Links...") and linked {proc1.a_i} to the parameter field of proc2.

Posting Permissions

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