Search results for query: *

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

I want to add 'ALL' wildcard character in parameters so that when users select 'ALL' then all the records should be displayed. Which formula should i write in select expert to do this..?

It worked but looking for easiest approach.. Thanks fisheromacse.. you saved my day..

I already tried that . But of no use.. To be more clear .. I have multiple static prompts First prompt is 'status' second is 'Type' and third is 'branch' If i selected status as 'X', type as 'ALL' and branch as 'ALL' then the summary value i.e., count(ID) is giving 25. If i selected status as...

I have been told to use static parameters. So an alternate solution to this will be good.

Hi, I have a report with parameter named status. Database has status values as 'c' and 'x' only. I want to count the number of records selected with respective status. For example if there are 20 records with status value 'c' and 30 records with status value 'x' And if i select parameter as...