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

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

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

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

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

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

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

Hi, I have a grouping report, its like Group 1 Sum=10 Group 2 Sum=20 Group 3 Sum=30 .. I want to get average of those sum values and it should be (10+20+30)/3=20

Hi, I want to add "ALL" wildcard in dynamic parameter. So that if user selects a region as "IL" and in next prompt he should see all cities in that region in drop down list and a wildcard "ALL". And when ALL is selected, data of all the cities in that region should be displayed on the report..

Hi, How to avoid division by 0 error. I want to display percentage of survey time, so what i did is surveytime/totaltime*100.. But some values in total time is 0 .. so i am getting division by zero error.. Thanks..

Hi, I have a date field and i want to display it as 200101 200102 ... I used ToText(Year(datefield)) &ToText(Month(Datefield)) and i am getting 2,0011 2,0012 .... Thanks ..

Hi, I've a report which contains name, id and salary data. I want to sort the records based on the user input. I created a parameter with no database values appended, i've written ASC and DESC values in parameter. I want to display records based on the user input like if user selects ASC then...