Search results for query: *

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

sql server 2000

do you have any sample ???

Is there any way to get the summary field

Yes I'm using your formula and how can I sort on it

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}) =...

Please don't give up on me I need help

Is there any help I'm still waiting for how can we do division on summery fields

@New1MonthAvg /New3MonthAvg * 100 is not working and I need to sort this as percentage

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...

how can I sort stringVar finalString

How can you calculate 3MnthAvgLD which is @Mnth1LD+@Mnth2LD+@Mnth3LD

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...