Skip to Content

Need to add totals from one main report to another main report

I have one report (sales module) which shows the total collection of the sales person code for the month,

I want to add that total collection into another main report (payroll) for that matching sales person code.

Is it possible?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Mar 15 at 11:05 AM

    Hi Naveed,

    You can do this by inserting the Sales Module based report as a Subreport inside the Payroll report.

    Here are the high level steps:

    1. Insert the Sales Module report as a Subreport in the Payroll report's Group Header/Footer

    2. Link the Main Report with the Subreport on the Sales Person + Month fields

    3. Format the subreport. Suppress all unnecessary sections and only display the section that contains the Summary

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15 at 03:47 PM

    Hi Abhilash

    I appreciate for your prompt reply.

    I am sorry, it didnt work. I am newbie for crystal report. I may be missing something.

    While printing it was showing "enter parameter values dialogue box"

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15 at 03:53 PM

    Hi Naveed,

    You'd need to link all parameters in the Subreport with the Main Report fields/parameters so that the Subreport prompt gets suppressed.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15 at 04:58 PM

    Hi Abhilash

    I appreciate for your prompt reply.

    https://imgur.com/a/xQn2XZ8

    https://imgur.com/ZoK4gEN

    Only few fields are common in both reports

    Add comment
    10|10000 characters needed characters exceeded