Shared variables from subreport that are only showing last values on Main Report per group

Hello,

I have a report with 2 Date parameter fields in the RH of the Main Report.. These are used as links to 2 subreports in addition to a  {Item} field..

Both subreports are in the GH2b of the Main report...I am using a Shared variable in each of these subreports

1st subreport @SharedAvailQty
WhilePrintingRecords;
Shared Numbervar AvailQty:=Sum ({MrpRequirement.AvailableStock}, {@@Date}, "weekly");


2nd subreport @SharedJobQty
WhilePrintingRecords;
Shared Numbervar JobQty:={MrpDetailPegging.Quantity}*-1

I am calling both of these variables in the GH2b report...I realize that is probably not right...

The subreports are displaying as example
subreport 1                                                             subreport2
Widget                                                          Widget
09/01/2013       400.00                               09/01/2013 400.00
09/10/2013      300.00
09/25/2013       200.00                               09/25/2013  200.00


but the returned value(s) to the Main report are only the last values of each subreport ..  for

MainReport     @SharedAvailQty                   MainReport    @SharedJobQty
Shared Numbervar AvailQty;                        Shared Numbervar AvailQty;

I am trying to calculate the qty's between both subreports for each date and display that on the main report..but with only the last value showing per subreport...its obviously not working
Mikeyman_01Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mlmccConnect With a Mentor Commented:
Need to reset the value to 0 in the group header.

Do you realize the totals you are displaying are for the previous group.  I moved the formulas to the group footer and added a reset formula to the group header 2A

mlmcc
MRP-Custom.rpt
0
 
mlmccCommented:
What total are you trying to show?
In your sample is that a single Group header or is it 3?

BY the way it is shown I suspect it is a single group header.

Change the subreport formulas

1st subreport @SharedAvailQty
 WhilePrintingRecords;
Local NumberVar CurrentAvailQty;
 Shared Numbervar AvailQty;

CurrentAvailQty  := Sum ({MrpRequirement.AvailableStock}, {@@Date}, "weekly");
AvailQty := AvailQty + CurrentAvailQty ;
CurrentAvailQty 

Open in new window


Similarly for the other subreport
2nd subreport @SharedJobQty
 WhilePrintingRecords;
Local NumberVar CurrentJobQty;
 Shared Numbervar JobQty;

CurrentJobQty :={MrpDetailPegging.Quantity}*-1;
JobQty := JobQty + CurrentJobQty;
CurrentJobQty

Open in new window


mlmcc
0
 
Mikeyman_01Author Commented:
it is picking up running totals
MRP-Custom.rpt
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Mikeyman_01Author Commented:
Well if anyone could figure it out.. You could...
0
 
mlmccCommented:
Is that what you needed?

mlmcc
0
 
Mikeyman_01Author Commented:
Yes...nicely done.. again
0
 
Mikeyman_01Author Commented:
This report keeps crashing   'Resources not Available'  how do I fix this??
0
 
mlmccCommented:
Is the database up?

Is this from the Crystal designer?

mlmcc
0
 
Mikeyman_01Author Commented:
Yes the database is up... Yes it is from Crystal Designer
0
 
mlmccCommented:
Try a verify database

mlmcc
0
 
Mikeyman_01Author Commented:
I did that.. Says its Up to Date
0
 
Mikeyman_01Author Commented:
It also looks like the bottom Records and info is all mixed up as well
0
 
mlmccCommented:
Is the report running now or do you still get resources not available?

If you get the eror again can you post a screen shot of the message?

mlmcc
0
 
Mikeyman_01Author Commented:
0
All Courses

From novice to tech pro — start learning today.