Search results for query: *

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

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

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

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

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

Hi all, Crystal v7, Oracle 9. Hope you can all help me with my crosstab dilema. What I want to do is calculate % against Columns and Total Figures, the following is what i would like to see, I have created the crosstab as below but without the % so far. Group = School Type Nursery...

CR7 Oracle What i want to do is findout a students age between two dates in the past i.e [term startdate] and [term enddate]. Once the age is established between those dates I want to find at age 14-15 what school they were at alongside teher current school. Many thanks

CR 10 oracle db. Hi All, Im totally picking your brains and dont know how to go about this....hopefully you guys can help! What I want to do is randomly select 10% of helpdesk calls within a specified time period. This should not be the first 10% of records the report hits. i.e total = 100...

Crystal 11 Oracle 9 Hi all, Hope you can help.... Im in the middle of upgrading reports from v7 to v11 and have found the following issue. When verifying the database any view cannot be found although data still gets pulled into the report. After some investigation I found in 'Set...

Crystal 11 Oracle v9 Hello All! Im in the middle of upgrading our reports from v7 to v11 and have the following issue veryfiying the DB. We have 2 schemas one for 'test' and one called 'main'. In v7 the views and tables come prefixed with EMSMAIN or EMSTEST e.g EMSMAIN.LK_NON_ACTIVE but in...

CR10 MYSQL Group1 Host Name Group2 Counter Name Group3 Trend Date 11/02/2007 45,884 10/02/2007 45,909 09/02/2007 46,408 08/02/2007 45,872 07/02/2007 23,000 06/02/2007 25,548 What I want to do is capture the most recent value(45,884) and use...

CR10 MySQL Guys hope you can help. I have a field [DiskSpace] which calculates the difference in Diskspace on a Day by Day basis excluding increases. What i want to do is add the totals up.... The groups are: Server Group Disk Space Group C, D etc Day Space [Disk Space]...

Hello all, Just some advice, pointers, warnings..... 1. I am going to start converting crystal reports from v7 to v11 and want to know if there are going to be any changes/problems I will encounter be it fields, formatting, data and so on? The Database is Oracle. 2. Do you think the best...

Hello all, CR10 SQL SERVER. I have two groups Server Name and Trenddatetime. What I would like to do is calculate the diff in disk space from the previous days disk space ?? 3rd column. Second i want to calculate the average diskspace usage a day 4th column. Finally from the average i...

Hello all, CR10 SQL SERVER. I have two groups Server Name and Trenddatetime. What i want to do is calculate the change in diskspace day by day result will be the third column. Now the hard part: The next thing I want to do is calculate how long it will take by average(result) for the memory...

SQL Server CR10 This may be a simple one for you guys. How can I have a Top N report but letting the user define the N via a parameter? I have 3 groups, I only want the top N to apply to the 1st group and select all for groups 2 and 3. Many Thanks

SQL SERVER, CR10 I have a table CALL_LOG CALL ID SRL_NO NOTES 00001 1 TXT11111 00001 2 TXT22222 00001 3 TXT33333 00001 4 TXT44444 What i want to do is only select the most recent note so in this case 'TXT44444', what is the best way to do this? I...

Crystal 10 SQL Server, When im trying calculate percentages in crosstabs for some reason I cannot get the % correct. Whats the best way to handle %'s in crosstabs? I.e i have a formula that calculates the percentage correctly in a normal report but when adding the formula to a crosstab it...