Search results for query: *

Thanks bro... You rock..

Hi, I have a grouping report which is grouped by "Req Type" and "Work Order Type" and have summaries like, Avg Val = Sum({PN.premium})/Count({PN.AcctNumber}) Req Type WO Type Avg Val A AR 20 B BR 55 C CR...

Hi, I want to create dynamic parameter for Time Period like, Time Period Type Time Period Value Time Period Type--> Rolling12Months --> YearToDate --> Quarter Time Period Value --> It should show list of date values If "Rolling12months" is selected then...

Hi, I want to create dynamic parameter for Time Period like, Time Period Type Time Period Value Time Period Type--> Rolling12Months --> YearToDate --> Quarter Time Period Value --> It should show list of date values If "Rolling12months" is selected then...

Thank you bro.. i appreciate it a lot.

Hi, Please explain me the step by step procedure to create LOVs in Business View Manager. I would really appreciate it.. Thanks

This should work.. Not (currentDate>DateAdd('m',-2,{oeordhdr_sql.ord_dt}))

Oh .. am sorry .. it isnt the sum which is required. Its the average which is needed. Sum({CTL.amount},{CTL.OrderType})/Sum({CTL.gross},{CTL.OrderType}). I can calculate this for Group I and Group III and is correct. But the thing here is there are two groups on same field for Group II and...

Hi, I have 4 groups, Group I - {CTL.MarketType} Group II - {CTL.OrderType} Group III - {CTL.Status} Group IV - {CTL.OrderType} Now, i want to calculate totals say sum({CTL.Amount}) for each group.. For Group IV - Sum({CTL.Amount},{CTL.OrderType}) For Group III - Sum({CTL.Amount},{CTL.Status})...

Group I - MarketType (values: Low, Large, Risk) Group II - Order Type (values: Casualty, Control, Property) Formulaes: Total Accounts=Count{CTL.Accountnumber} GWP=SUM{CTL.GWP} Record Selection Formulae: I have two parameters Req Type and Work order type so the record selection formula is (...

Its working.. I apologise for da mess.. I wrote if Uppercase({Val.Type})= "CLAIM" THEN Sum({Val.2007Count}) // instead of {Val.2007Count} Its working fine now... I rectified it... Thank you very much...

Yes i did.

NO, Its not working.. Its also displaying 0(zeros)..

Hi, I have two groups Group I - Program Group II - Type 2007 ratio -> {Val.2007Total}/{Val.2007Count} 2008 ratio -> {Val.2008Total}/{Val.2008Count} My report looks like this, ---------------------------------------------------- Program Type 2007 ratio 2008 ratio...

Hi, I am designing a report with subreports. I have only one subreport on the main report. I dont want to drill down on subreport i.e., i want to disable the drill down on subreport. Appreciate your reply.. Thanks

I already did it. Thank you lbass. Hats off to you buddy...

Yes, I want a Grand Total of the averages

Sorry for trouble. I hope this explains it better. User selects a date on refreshing the report. I need to calculate WOs and %Survey time for last 12 months from the selected date and show it on report. %survey time =(Sum({RCT_RPTG_RCT05.SURVEYTIMETOT},{RCT_RPTG_RCT05.ENDDATE}, "monthly")...

The same scenario i.e., instead of wo's i want %survey time . %survey time formula =(Sum({RCT_RPTG_RCT05.SURVEYTIMETOT},{RCT_RPTG_RCT05.ENDDATE}, "monthly") % Sum({RCT_RPTG_RCT05.TOTTIMETOT},{RCT_RPTG_RCT05.ENDDATE}, "monthly")) i.e., whileprintingrecords; numbervar wo; if...

Excellent.. Now we calculated number of WOs. What about the same calculation for %Survey time where %Survey time={surveyhours}/{totalhours} By the way Thank you man... You are brilliant.