Search results for query: *

Have you tried a formula like : {field}-1

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 have now managed to use the shared numbervar feature to pull the value to the main report and display the correct value depending on the group Example Group = Call No Call No. Cost 67863 44.00 67864 55.00 67965 47.50 What I want to do now is a grand total but 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...

yeah I tried it but They all get the same percentages I have 3 levels of grouping in my report Group 1 - Region Group 2 - User Group 3 - Call The reason for a group on the call is that there is loads of history within and I only want to know if it was closed complete or closed incomplete

hi Thanks for both the responses, I have tried the above and the percentage don't work correctly as they come back 100% I want there true value without having to show the completed section. Sorry to be a pain

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

Cheers, Works a treat

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

I have tried this but doesn't seem to work as I can't use the header as I have in excess of 1000 items that I need to list, So I have tried using group, Isn't there a formula that can look for either the latest date or the last entry kind regards stephen

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 Sorry about that, I am using Oracle

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

Cheers this works a treat, I just have a small problem that I didn't take into account. the report wants to pull all previous dates as well Kind Regards Stephen