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

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

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

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, 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]"...

Hi, I've got a list of 15,000 contract numbers I'd like to order them and then group them in batches as follows; 1-100 101-200 201-300 301-400 etc. The contract number tends to be in the following format; CN/000000001 Although there are some anomolies every now and again such as; CH/H5105...

Hi, I think I've pretty much answered my own question in that it can't be done, but been looking at this so long I may be missing something simple. I working in Crystal v9 and my data sources are a range of SQL databases and excel spreadsheets. My hands are tied, there is no chance of...

Hi, I have an excel data source I am trying to link to a table from a SQL database. Ideally the common links would be consultant name and week number however, the data in the excel spreadsheet is presented as follows; Consultant Week 1 Week 2 Week 3 Joe Bloggs 20...

Hi, Has anyone else come across any perfomance issues running reports based on Crystal Reports XI Release 2? Its more of a general question rather than a quest to get to the bottom of the particular issue, that could very well be an isolated issue based on our environment. As a bit of...

Hi, I am working on site at a company who has purchased an off the shelf ERP system that distributes reports created in Crystal Reports XI, and I believe is based around the XI release of RAS. The reports are viewed in the Active X viewer. Recently the company has had a massive upgrade in the...

Hi, Has anyone any experience creating a report from an Internet Inquiry File (IQY)? If so what connection type did you use to connect to it? I am using Crystal Reports XI, but am abit vague about the data source other than knowing its IQY, its not something I've come across before and can't...

Hi, its late and I am having a total mental block! I am using Crystal XI reporting off a SQL 2000 database. My question is around formatting drill downs. My top level has the following columns; "Region" "Number of Sales" "Number of Potential Sales" 2nd Group; "Region" "City" "Number of...

Hi, I've got a series of reports created in Crystal 9 from a Postgres database. I'm in the process of updating these reports using Crystal XI and a new Postgres database. When I go to Set Data Source Location everything goes as you'd expect and is straight forward, until I come across a text...

Hi, When I try and "Append all Database Values" within a parameter Crystal Reports closes down, with no error message, no option to save the report. Just a straight close, with all work since the last save point lost. Its Crystal Reports XI, with service packs one and two installed running on...

Hi, I'm trying to view a crystal report via an ASP page, but in my test environment I can enter the parameters but the Crystal Viewer returns page 0/0 with no report displayed. I'm convinced the problem must lie with the test machine as if I try one of the reports for the third centre in...

Hi, I've held off posting this for a couple of days as I'm sure its blindingly simple, but I can't find an answer anywhere! I'm using Dreamweaver MX and SQL server 2000. I've created a page with the intention of using it to update records that have been entered into my database. I used the...

Hi, I'm running Crystal Reports Server XI on a Windows 2000 machine, with the 5 user licence, reporting off a Postgres database, using the Advanced DHTML viewer, with the CMS database using MSDE. The problem I'm having is with reports that require Parameters, the intial page is taking upwards...

Hi, I'm Crystal Server, and Crystal Reports XI, reporting off a Postgres Database. I've a problem with one report that contains three subreports, if I run the report in Crystal Reports it returns ok, if I run the report as a one off instance in Crystal Server it runs ok, but if I schedule the...