Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gav12345

  1. gav12345

    Chart Default X Axis

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

    Crystal Enterprise 10 data display / refresh issue

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

    Crystal Enterprise 10 data display / refresh issue

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

    Could not start Crystal Management Service on Local Computer

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

    Could not start Crystal Management Service on Local Computer

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

    Could not start Crystal Management Service on Local Computer

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

    Performing cross-tab calculations

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

    Performing cross-tab calculations

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

    Performing cross-tab calculations

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

    Problems scheduling in CE10 - Database logon information error.

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

    Problems scheduling in CE10 - Database logon information error.

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

    Ordering graph x axis with formula

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

    Ordering graph x axis with formula

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

    Ordering graph x axis with formula

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

    CE10 CMS will not start

    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

Part and Inventory Search

Back
Top