Pass result set from main report to sub report RRS feed

  • Question

  • User1956776465 posted


    I am using crystal report XI. I have one SP which I call in my main report and sub report. I want to avoid calling SP twice. Is there any way?

    Or Can I generate a report without sub-report in below format.

    Department wise report

    Report Name                Dept Name                Member Count

    Contract                       Distribution Centre      4

    Employee                     Distribution Centre     10

    Contract                       Customer Service       3

    Member Details

    Report Name              Member Name        Dept Name       

    Contract                       name1                  Distribution Centre

    Contract                       name2                  Distribution Centre

    .....                              ......                       .....

    Friday, August 17, 2012 12:36 PM


  • User-578610739 posted

    Hi Vc_ind,

    There is no option to stop calling sp twice. Because If it not executed then your sub report data will not comes.

    For your problem, you can do it by simply make one sp which give the same result as you mention above. For that make function or inner query or sub-query.

    So grouping will done in sp and give column name for that. The same column in use in report.


    In your case, Dept Name  and Member Name, use 2 sp in report and in report formula give join formula. so it works as a one sp in grouping.


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, August 23, 2012 12:50 AM