• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Repeating Values from shared Variable

I have a subreport with the following formula in the GH... This subreport is placed in the GH1a of the Main Report


//@SharedSummary
WhilePrintingRecords;
Shared Numbervar SumValue:=Sum ({Command.ChequeValue}, {Command.ChequeDate}, "daily");
Shared DateTimeVar TranDate:={Command.ChequeDate};

This formula is placed in the GH1b of the Main Report .. The problem is that the values are repeating till the next non 0 value....I need this value to show as well

//@SharedSumValue
WhilePrintingRecords;
Shared Numbervar SumValue;
Shared DateTimeVar TranDate;
Global NumberVar SumVal_Summary;
SumVal_Summary:=SumVal_Summary+ If {ArInvoicePay.JournalDate} = TranDate then SumValue else 0;
SumValue;

This formula is placed at the Report Footer of the Main Report.. Which appears correct...

//@Display
WhilePrintingRecords;
Global NumberVar SumVal_Summary;
SumVal_Summary

The only problem is that the Value at the GH1b within the Main Report is repeating Values until the next non Zero appears, and then that value repeats...I only want the value in GH1b to show if the Dates match between the subreport and main report, I also need the @Display formula to show a summary of the values from the GH1b formula

Hopefully this makes sense
0
Mikeyman_01
Asked:
Mikeyman_01
1 Solution
 
mlmccCommented:
I think I understand what you want.

Try this formula

//@SharedSumValue
 WhilePrintingRecords;
 Shared Numbervar SumValue;
 Shared DateTimeVar TranDate;
 Global NumberVar SumVal_Summary;
 If {ArInvoicePay.JournalDate} = TranDate then 
 (
 SumVal_Summary:=SumVal_Summary+ SumValue ;
 SumValue;
)

Open in new window


I that doesn't do what you want can you show in a picture what you want.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now