Search results for query: *

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

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

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

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 am working on a report which has 2 groups. Grouping is on date field (EndDate). First by year and then by month. No. Of WO's = Count({work order},{EndDate},"Monthly"); No. of WO's 2008 200801 123 200802 547 200803 764 200804 421 200805 232 200806 333 200807...

I have a grouping report which has 3 groups(Repname, ReqType and WOType). Group1- Repname Group2- ReqType Group3- WOType I need to calculate grand total of Avg_Survey_Time. Avg_Survey_Time=Sum(SurveyTime)/Count(WorkOrder) Rep has values = A12,A13,A14 ReqType has Values = Physical, New, Claim...