Search results for query: *

Thanks LB, I will try this out when im back in the office. Will let you know the outcome.

OK leave the sort part out for now. How would i find the difference?

Sorry for the urgency, my apologies. The problem is that I don't know how to subtract the most recent months '% average' from the latest '% average' for each interface and then sort the report on this value e.g interface 111111 the formula would need to result 45.23% - 71.14% = -25.91% <<...

bump

great thanks! never come accross that command.....used instr etc

Sorry should have posted the nested formulas.... {@Link Speed} = {Interfaces.OutBandwidth}/1000000 {@Max} = If {@MaxBPS} > {@MinBPS} then {@MaxBPS} else {@MinBPS} {@MaxBPS} = If {InterfaceTraffic.In_Maxbps} > {InterfaceTraffic.Out_Maxbps} then ({InterfaceTraffic.In_Maxbps}/1000000) else...

Hi again,s. CR11 SQL Server Not sure how to do this..so here goes. Data Output in Crystal Interface Month % Average Ex of Result (% Change) 1111111111111 12/2010 71.14% 01/2011 65.02% 02/2011 45.23%...

Hi, CR11 How would I just extract "Connaughty" from the string below? "Nortel Ethernet Routing Switch 5510-24T Module - Port 9 - Connaughty" Many Thanks

Pretty please?

Hi All, I need some help on the following SQL Query below which I have been given by the DB guys, I am using the add command to build the table in CR11. It isnt what I want to see in my crystal report as its summarized.What I would like to see is the last three months data on a rolling basis...

Hi All, I need some help on the following SQL Query below which I have been given by the DB guys, I am using the add command to build the table in CR11. It isnt what I want to see in my crystal report as its summarized. What I would like to see is the last three months data on a rolling basis...

pretty please?

Hi, CRXI, SQL server. Hopefully I can explain this enough for the forum to understand. We have a helpdesk call logging database which we need stats from. The report needs to show calls created and resolved by an analyst in a bar graph (each analyst will have two bars calls resolved count and...

Sorry can you explain in more detail please?

Hi All, CR11 ORACLE DB. I have a date range parameter in the main report 'Start date' which is passed to my subreport and selects the data accordingly. What I want to do is suppress all the records for group 1 in the main report where the subreport is blank? Let me know if you need anymore...

Brilliant LB works a treat!! Thanks very much.

{@Start Date} = Minimum(ReportPeriod) and {@End Date} = Maximum(ReportPeriod) where ReportPeriod is a parameter. No DateAdd is not available. Thanks

CR v7 Oracle 9 DB Hi All, I have a date range, {@Start Date} and {@End Date}, I need to create a formula that will calculate the same Start and end period for the previous year (factoring in leap years) for my subreport. Its so the user can see current and previous years data for the same...

thanks lbass, I did think of that option but as there are 10 odd maybe more codes I thought the crosstab route could have been taken. Thanks again for all your help! Regards Deeya

Are you sure your talking about CR7 as i cant see any percentage summary options? Thanks