Recent content by abc567

Now i am onto different report. Its based on grouping too. Group 1 is based on ReqType column Group 2 is based on WorkOrderType column Group 1 Data - Physical and Claim Group 2 Data - New and Old Avg Survey TIme= Sum(Survey Time) / Count(Work orders) Avg Survey Time PHYSICAL New...

You are Genius. Thanks a lot..

I have a grouping report in which average per month is needed to calculate. The report is based on grouping. Grouping is done on date field on monthly basis. %Survey time= Sum({RCT_RPTG_RC100.SURVEYTIMETOTAL},{RCT_RPTG_RC100.ENDDATE}, monthly") %...

Hi, I am required to write a condition like, NumberVar df= Datediff('d',Field1, Field2); if ( 0 < df <=50 ) then 1 else 0 But i am unable to write it in formula..

Thank you very much lbass..

Hi, I am designing a grouping report, i have following fields Rep Status ====================== A Assign B Un-Assign C Assign D Scheduled E Re-Assign F Assign A Re-Assign G Scheduled H Decided I...

No, Workorder is being run from crystal reports version XI

Hi, I have a report 'workOrder.rpt' with a text field "click here for detail report" and i want to link workOrder.rpt and detail.rpt report. I have business objects enterprise environment. So the detail.rpt file is saved in the enterprise. I want to hyperlink detail.rpt to workOrder.rpt on the...

I need to calculate average of month totals for all years For ex: 2009 - GP1 200901 - 15 (this is count of orders for group 200901 GP2) 200902 - 20 (this is count of orders for group 200902 GP2) 2010 - GP1 201001 - 30 201002 - 40 I need the average of counts at the end i.e...

I need to calculate summary of count And Count of summary I already posted this but noone replied it yet..! somebody knows this...?

Hi, I have a grouping report which is grouped as follows GP 1 - Date on Year GP 2 - Date on Month I have count of orders and want to get the average per month i.e., It has data like, 2009 # of Orders 200901 15 200902 20 Avg Per Month ? i.e...

Thank you very much bro... Appreciate your help .. Thanks CospringsGuy and lbass..

Thanks i did exactly as you said but when same account number (102) spread over multiple pages then lines are getting displayed as 101 101 --------------- 102 (As this is page ending it should display a line so i inserted line in page header but this is not working either as this line is...

Hi, I am designing a report which has 'account number', 'branch', etc... I want to design it as ACC Br 101 A 101 B ----------------- 102 A ----------------- 103 C 103 B ------------------ i.e., line should appear if the records are different so i created 2 details section det a and...

Damn !! You are excellent buddy...!! Thanks