Search results for query: *

Hi, I'm sure its been done a thousand times and I'm just asking the search box the wrong question! But I'm trying to chart the number of open tickets by day. So if a ticket was opened on the 1st January and Closed on the 10th January I'd want to count that ticket in the chart as being open on...

Hi Mike, Had a little time to sit down and look at this and gone with the now seemingly simple method of creating a command, with 6 unions, one for each month, put a field in each to identify the month then grouped/charted on this. Works a treat. Cheers Marc

Thanks Mike. Fair comment on the formula, it was in for good reason orginally, can't remember why though to be fair and lives on in that format thanks to lazy "text box" formula copying between reports! Sadly Excels not an option, looking for something that can be scheduled so its automatic...

Hi Mike, Yes its just a count of what was open on the first of each month, trended over 6th Months. So for example; Ticket 1 opened on the 10th January and closed on the 5th February I'd want to be counted as being open on the 1st February. Ticket 2 opened on the 10th January and closed on...

Hi, I've not been able to find an answer that quite gives me what I'm looking for, but I'm sure thats me asking the search funtion the wrong question! I'm trying to calculate the number of tickets open on the 1st of a month in a helpdesk system then trend this over 6 months in a graph. So to...

I should add, but missed from the above, my best stab so far involves a running total via a variable using a count as follows; whileprintingrecords; numbervar Sev4TailCount; if {@End to End} < 120 then Sev1Count:= Sev1Count + 1; Then Displayed in the footer as; whileprintingrecords...

Hi, I'm running Crystal 2008 against a SQL Server 2005 Remedy database. My problem is I'm trying calculate the end to end time of a help desk ticket minus the time the ticket had a status of "pend" I am then trying to compare that to Service Level Targets on a month by month basis. Remedy has...

Seemed to have fixed it, it appears in Webi it will only run if you alias all the fields in the sub query. Cheers Marc

Nothing helpful I'm affraid, it seems the error message in Webi is pretty generic; A database error occured. The database error test is; [Microsoft][ODBC SQL Server Drive][SQL Server]Statement(s) could not be prepared (WIS10901) I can't test the SQL outside of Webi as I don't have access to...

Hi, I'm trying to build a custom SQL statement in Business Objects and thanks to the error message Webi generates can't tell if I'm making a school boy error with the SQL statement or trying to get Webi to do something it can't do here's my statement; SELECT Incident_Number , Fields_Changed...

In the end grouped them up using a formula then split them out into columns using this formula 3 times; if ubound(split({@Sport Group},",")) >= 1 then split(Sport Group,",")[1] With @Sport Group being a String Var that collects them all into one field in the group footer displayed as...

Hi, Typically there will be 2 or 3 per person, I've not seen any examples with more than 3, so I'll be taking that as the maximum likely number. Entries can change against each person so there not static. Its Oracle 10g, but other than knowing its an oracle database I've no means of doing...

Hi, I'm using Crystal 2008 off an Oracle database and looking to take data currently displayed in rows and show them in individual columns in a group header/footer. So my data currently looks like; Col 1 Col 2 Joe Bloggs Rugby Joe Bloggs Football Joe Bloggs Cricket Joe Bloggs...

Hi lbass, thanks for your help, I've sorted it by creating a view that flags an event on the first call the machines have against them, I've then used this flag in an if then else statement that only brings through the days installed once per machine, job done! Thanks for that link to Kens...

Thanks lbass, I'd been through Kens site but missed that one, its not going to work for me I get a "Not Supported" "OK" pop up box and a blank screen, but re-reading the text I breach the 1000 unique records. There are 16500 machines, each tending to have 5 or 6 calls against them. Not had...

lbass - I'll take a look at SQL Expressions, its a part of Crystal I've always tended to under utilize. jmd0252 - I did try the averages idea, but it doesn't roll up for the higher groups, even if I got it to work I'd have trouble when the request to break down the monthly value into shorter or...

Hi thanks for the reply. I can't do the running total option to identify the first record in a group as I then can't go on to sum this at a group header level. Again Maximum and Minimum are no good to me as I may need to perform other summaries on the value eg; Its a monthly value if they...

Hi, I am trying in effect to perform a distinct sum once per group, I had thought if I could identify the first record in the group then sum this I'd be fine, but its proving harder than expected. Previously I've used running totals or variables to bypass the problem, however the manager...

Hi, I am trying to schedule a report on Crystal Server 2008. It works fine if I set the destination to "Default Enterprise Location" however, when I change the destination to "File System" I get the following error; "source file error. [CrystalEnterprise.DiskUnmanaged]: [Invalid argument]"...

Gone with this is the end to generate the row numbers over the union, probably not the prettiest solution, but its done what I needed to do! select ROW_NUMBER() OVER(Order by Contract_Number ASC), t1.Contract_Number,t1.Contract_Status from ( (SELECT Contract_Number,Contract_Status from...