Recent content by deeya

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