As your advised I worked out on sql server's view and now I have two view how can I do data comming from few fields from one view and other fields from other view
mean how can I use two store procedure in one report
great this working and it's and how can do I sort (Ascending) on this field . I do not see this formula in record sort expert. or is there any way to sort the record on this field
Thanks dgillz,
I have created as synapsevampire advised two formula
one is New3MonthAvg
code is
{avReports_Safeway_DM_03.LedgerAllocChgAmount}/3;
and then I create summery to get the correct value
second is NewAvg1month
code is
if (Month ({avReports_Safeway_DM_03.InvoiceDate}) =...
Hi nothing works
So I worked on store procedure and now I getting calculated value for
I create formula name "New3MonthAvg"
Using simply {avReports_Safeway_DM_03.LedgerAllocChgAmount} from view
then I create summery field from it
and Next
I modified formula for first month just modified little...
Month1LD is summery of @Month1LD
formula is
dateTimeVar invDate := {avReports_Safeway_DM_03.InvoiceDate};
numberVar MnthsToSub := -1;
dateTimeVar prevMonths := DateAdd ("m", MnthsToSub , currentdate);
if (Month (invDate) = Month(prevMonths) And Year(invDate) = Year(prevMonths)) and (Right...
I have report having following fields and I'm including data for 4 rows as sample
Mnth1LD Mnth1Loc Mnth2LD Mnth2loc Month3LD Month3Loc
320.83 682.39 197.00 696.46 31.89 798.85
395.11 1137.26 430.86 1152.85 16.19 1249.93
458.22 569.35 255.82 578.33 19.69 713.48...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.