Search results for query: *

Hi CR Version - 11 I am producing a report based on a job status and having to use subreport to bring certain parts of the information that is needed Main Report Tables Call Location Status Sub Report Tables Call Controlled_Event I have a report that has the data grouped by the...

Hi I am using CR9 I have a main report that is using group based on the call code. I have a subreport that calculates the Labour & Parts for each Call (In the subreport there is another group based on the call number). The reason for this is that the Oracle database duplicates events such as...

Hi Using - CR 9 I have a date parameter and a cross tab table that displays call for each week what I want is to change the user to be able to choose the date range (NO PROBS HERE) But also choose what day should be the starting day for the week as things are grouped. Or is there a way that...

Hi I am using CR 9 I have a cross tab table displaying resolution for members of staff example user incomplete complete Total Dave 1 25% 3 75% 4 Lisa 3 30% 7 70% 10 what I want to do is get the tabel to look like the below user incomplete...

Hi I'm Using CR9 I am trying to create a cross-tab table that consists of staff performances using figures and percentages. Grouping in Reporting Grouping 1 - @Staff Grouping 2 - Call.Call_Number I have a formulas call "Call_Status" & "Staff" Formula - "Call_Status" IF...

Hi I Am Using CR 9 I have a field that may or mynot contain data. Fields used Description Reference @Formula what I want is the @formula table above to display "Unknown" if there is a reference No. but the Description table is blank, but if there is information in the Description table then...

Hi I am using CR9 I have a date field and a product value field (In the same table) what I want to do is display the value based on the last date the value was entered. For Example Product 1598 - 12/05/07 - £3.42 Product 1598 - 12/09/07 - £3.49 Product 1598 - 15/07/08 - £5.42 Product 1598 -...

Hi, I am using CR 9 I am putting a creating a report based on our stock and I want to compare the 2008 price with the 2009 price. In the table we can update the price and insert the effictive date of the new price. So one product can have many different values over the time it is on our...

Hi I' Using CR 9 Let me just just start by saying this is a wierd and a pain in the bottom and I need help as I have troied all diferent formula and have no luck. I have in a nut shell 3 tables containg data Table 1 - Call Call_No Call_Recieved_Date Call_Close_Date Table 2 - Event Call_No...

I am using CR9 I have a cross-tab table in my report collecting totals The fields I am using are Region Call-No Month I am running a distinct count on Call-No for each Region Per month. What I want to do is it to sort the cross-tab in descending order based on the total and not the region...

Hi I am using CR9 I want to split my calls into 2 catagories. Catagory 1 - Business Time Catagory 2 - Out Of Hours Working Hours Monday - Friday 08:00 - 17:00 how do I create a formula that looks at the date feild and then returns either one of the 2 values below based of the criteria...

Hi CR Version - 9 & 11 I am creating a cross-tab table in my report and the table contains the following fields Product Description Symptom Product ID What I want is to shaw the top nth term (1) of the symptom but when the top nth term (1) equals "OTHER" i want it to display the next one...

Hi I am using CR9 I want to use a parameter so the end user selects a date fot the report (This is done and easy) what I want it to do is the user select the date normally the current date and the report automatically does it for the day before for example the user puts in 01/02/09 the...

Hi CR Version - 9 if CurrentFieldValue = 0 then crWhite else if gridrowcolumnvalue ("@type")= "downtime" and currentfieldvalue >0 then crred AND if gridrowcolumnvalue ("@type")= "TRAVEL" and currentfieldvalue > gridrowcolumnvalue ("@type")= "WORK" then crred I have the above formula in...

Hi CR Version using - CR9 I am trying to use a cross tab to display total time for events for each person. I do have a datediff formula to calculate between the start and stop time. this brings back a standed decimel no so I then use a fomurla to get it to represent as a hh:mm time. The...

HI Guys, This is simple Iknow it is just can't put my fing on it. I am currently using CR9 and will be upgrading to CR11 In August I have a report that contains multliple sections that contain various amounts of data. the problem I have is that if a user puts a lot of information in one...

Hi I am using MSOFFICE 2007 What I have is a table containg the following Region Part WEST Table South Table EAST Chair WEST Table WEST Sofa WEST Chair What I want to do is have a cell that will say either WEST, SOUTH, EAST or NORTH. I then want a second cell that will lookup the information...

Hi I Am Using CR9 (Soon To Be CR10) To Pull Data From A Oracle Database. What I want to archive is a report that tells my the 1st fix YES/NO and who the 1st person to deal with the issue. The informaion is coming from the the following fields/Tables Call.CallNo (This is the Call Number...

Hi Using CR9 (Soon To Be CR11) I have a report that is doing a job of telling me the resolusion if and if it was resolved the first time. The thing is I have a formula (RES) in that has a basic function displaying YES or No based on the following formula Formula is called RES if...

Hi I am currently using Excel 2007 & 2003 My question is how do you do a wildcard vlookup let me sure you what I want Table 1 A B C Row Part Description 1 YY67HH Screw 2 UY6900 Table Leg 3 KJ78HB Carpet Table 2 A B C Row Part Description 1 HH67TK =vlookup(B1,'[Table1]'$B:$C...