Passing Values from a sub report and using in formula

[CARLEENHOP]

Hi

i have a report with some date and qty values (invoices). I have a sub report with some date and qty values (orders relating to invoices). i can view the order information from these invoices via the subreport. However I want to create some formulas to compare values from each report. e.g find the date difference between the invoice created date and the order due date to identify delivery performance. How can i create this formula using fields from both reports? I know how to create formula when looking at fields in the one report. Any help would be great. Thanks

 

[IanWaterman]

Use a shared variable as per post from yesterday

"How to bring a value from sub-report to main report"

Ian

 

[CARLEENHOP]

Thanks, worked great

 

[CARLEENHOP]

Another problem, not sure if it should be logged under a new thread? My values passed from sub report are within the details section. My formulas therefore using these values are in a group footer. I now have a formula comparing the two values in group footer and printing a 1 if true to my statement. I want to sum the value of these 1's if that makes sense however my formula cannot be summarised? Any suggestions?

Thanks

 

[IanWaterman]

You need to use another Variable which increments by 1 based upon the conditions you describe.

Ian

 

[CARLEENHOP]

Are you able to show me how I would do that? Thanks My statement is as follows:

if {SORD.TYP} = 2 and {@Date Difference} = 0 then 1

 

[IanWaterman]

Modify Formula

whileprintingrecords;

global numbervar datediff;

if {SORD.TYP} = 2 and {@Date Difference} = 0 then
datediff:= datediff + 1 ;

Ian

 

[CARLEENHOP]

Thanks Ian. I have attempted this and it works OK for an overall total. I neglected to tell you I have two groups and need a total for each group. If you could help with this it would be much appreciated. Thanks

 

[IanWaterman]

Add a group count to formula

whileprintingrecords;

global numbervar datediff;
global numbervar datediffgrp;


if {SORD.TYP} = 2 and {@Date Difference} = 0 then
datediff:= datediff + 1 ;

if {SORD.TYP} = 2 and {@Date Difference} = 0 then
datediffgrp:= datediffgrp + 1 ;

In group header add a reset formula and suppress it.

whileprintingrecords;

global numbervar datediffgrp:=0;


Ian

 

[CARLEENHOP]

Have been on holidays. Found another problem. Not sure if should keep in this thread? I have my orders delivered column which checks if it is an invoice and if so returns a 1. I then sum the 1's to get my number of orders delivered for each group. However just realised where there is more than one record for each invoice my sum is incorrect as it shows 2 orders delivered when there is only one order delievered with 2 products on it. I am not sure how to only return a 1 for each invoice (e.g where the invoice changes). Knowing the rest of my report, are you able to help? thanks, much appreciated.