cancel
Showing results for 
Search instead for 
Did you mean: 

Linking Subreports based on group in the main report

Former Member
0 Kudos

Hello,

I have a main report that groups by department, month, and then employee name. I put a subreport in at the month and name level (it brings back statistics for a particular employee for the chosen month). The subreport is based on a completely different set of data. I want the subreport to pull just the data for the individual month and employee into that employees monthly section. How do I link the subreport? It seems like it should be pretty straightforward, but I can't get it to work. Do I need to set up groups in the subreport? I am a beginner and appreciate your help.

Thanks,

Al

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Right click on the subreport in employee section and go to change subreport links and add month field and employee fied from main report and link them with corresponding fields from subreport.

Regards,

Raghavendra.G

Answers (1)

Answers (1)

Former Member
0 Kudos

How I would do it is as follows

Create a Formula Field and choose the group name e.g.

GroupName ({migsol_oppact.COMPANY})

Then link the sub report using that Formula Field