jchewsmith
Technical User
I am trying to pass the total count per month from a subreport to a main report to the same month.
So I will have a main report with # of widgets created by month, then the subreport will have a count of widgets destroyed by month.
I want to share a variable so I can display the destroyed widgets count next to the created widget count for each month then create a formula to show % of widgets destroyed vs. widgets created.
Main Report
1/22 450
2/22 500
3/22 700
Sub Report
1/22 40
2/22 10
3/22 15
I want to show:
1/22 450 40 8%
2/22 500 10 2%
3/22 700 15 2%
Currently I am getting all 3 months of destroyed widgets next to each month in the main report
1/22 450 40
10
15
2/22 500 40
10
15
3/22 700 40
10
15
So I will have a main report with # of widgets created by month, then the subreport will have a count of widgets destroyed by month.
I want to share a variable so I can display the destroyed widgets count next to the created widget count for each month then create a formula to show % of widgets destroyed vs. widgets created.
Main Report
1/22 450
2/22 500
3/22 700
Sub Report
1/22 40
2/22 10
3/22 15
I want to show:
1/22 450 40 8%
2/22 500 10 2%
3/22 700 15 2%
Currently I am getting all 3 months of destroyed widgets next to each month in the main report
1/22 450 40
10
15
2/22 500 40
10
15
3/22 700 40
10
15