Search results for query: *

Hi, We're using Crystal Reports 2011 and SQL Server 2005. I have a chart in which I'm trying to display all accounts opened per month, over the last year (rolling date - currently 13th June this year to 13th June last year). Even if no accounts were opened in a given month, I still want to...

Hi Dell - Thanks for the suggestion, but that option is already switched off in the report. Gavin

Hi all, We're using Crystal Enterprise 10 and Crystal Reports 9 against a SQL Server 2005 database (I know - old versions). I'm experiencing an issue when trying to schedule two reports... The reports each have 7 input parameters (a mixture of strings and dates). When I preview the reports...

Thanks again Dell. After a bit of messing around I think this was a combination of 1.) The Data Execution Prevention on Windows Server 2003 was preventing some servers from starting up and 2.) I think the domain admin account I'd requested for the Crystal services wasn't quite right. When I...

Thanks Dell - But I'm not sure why not? The installation was normal and I have since manually configured the CMS to use the CE10 datasource (I get a message that this has beeen set up successfully), but I am still getting the same error. Any ideas why it might not be able to connect to the CE10...

Hi all, I've just installed Crystal Enterprise 10 (old technology I know) and the services failed to start during installation. I assumed this was becuase I wasn't logged on as domain admin, but even with a domain admin account for all services, I am getting the following error when trying to...

Hi lbass - Sorry things are a little crazy here just now, it's just been decided (for non-crosstab reasons) that we'll take the calculations back to the database instead of doing this in Crystal. I appreciate your help. Gavin

Thank you Madawc and lbass. Because of the complexity of the cross-tab, a manual cross-tab isn't really viable. We've made a little progress where we build up a string prior to the cross-tab, and then using that for calculations within each cell of the cross-tab, but I will update with...

Hi, We're trying to find out whether Crystal (Version 10) is able to perform some calculations for us within a cross-tab object.The database is Oracle 11g. We will have around 80 calculations that could be performed, in the following format: Column Name Calculation Operands Column...

Thanks for your response. It was supposed to end up in a file location, but we've resolved the issue. The issue was that the report server service needed to be configured to log on with domain admin privileges.

Hi all, We're having some problems scheduling in CE10 (Oracle 11g DB). The issue actually came up when trying to schedule reports programatically, but the same behavious applies when trying to schedule within the CMC. Essentially we are able to preview a report without any problem within the...

Sorry, should have said that I did try that but it initially generated an error because val was looking for a string, not a number. But I've noticed we have a similar string field that I've tried using for which val works perfectly. - Thanks for the help. Gavin

Thanks both - but I don't think I've been very clear. The field I have on the x-axis is a concatenation of a numeric field, some spaces, and a non-numeric field. For example... " " {GET_CONTRIBUTION_PAGE.CM_TIME_POINT_NUMBER} & " " & {GET_CONTRIBUTION_PAGE.CM_TIME_POINT_UNIT} would...

Hi, Using CR10 against Oracle 11g. We have a graph which currently uses a field directly from the database (i.e. not a formula) for its x-axis data. An example of the graph presentation would be: 4 3 gm 2 1 0 0 7 14 21 28 35...

Turkbear, Many thanks for that. Had a read about the Import Wizard and I'm not sure why I haven't used this before. Seems far more straightforward than the route I've been going down. Gavin

Hi, Well, that crossed my mind, but if that is the case I'm not sure how to correct it. The auditing data source on the live server is pointing to the same database as the CMS data source. The method I used was: - I backed up the live DB then copied the live Filestore folder to a network...

Hi all, Using CE10 with SQL server as its DB, all services running on the same server. I've just installed CE10 onto one of our test machines, then migrated across the contents of our live CE10 database. The migration seemed to go fine, but I am now unable to start the CMS on the test...

Hi all, I have a couple of general questions about Crystal in Visual Studio 2005 and 2008. Essentially we have just finished phase 1 of a project which has ended up with about 150 Crystal 10 reports, all very similar to each other. So...for phase 2 we thought that it might be much easier to...

Hi all, When previewing some reports with dynamic parameters in BOE XI R1, a 'List of Values failure' error message is displayed (below). The error isn't consistent; sometimes the same report will run without any problems then will fail with the error below 2-3 minutes later. The error doesn't...

hilfy, sorry, just got this when looking through my older threads...for some reason I'm not getting notified of replies by email just now... Thanks for that information. Spoke to BO support in the end and played around with a few configuration settings, but they essentially said that <30...