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 TouchToneTommy 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 gortuk

  1. gortuk

    Best Printer Diver to Install for larger reports

    I use the Acrobat PDF printer for this purpose - you can define a custom page as large as you want.
  2. gortuk

    CE, Scheduled Instances, Parameters & The "Run Now" Button

    I just noticed that APOS offers a freeware add-on for CE 8.5/9/10 which will apparently add a Reschedule button to your InfoView - check it out here: http://www.apos.com/Freeware/
  3. gortuk

    New error since upgrading to BOXI Release 2...

    Bessebo - it is in the Advanced Rights page of the CMC, under the "Report" section (which isn't visible by default so you'll need to expand it).
  4. gortuk

    CE, Scheduled Instances, Parameters & The "Run Now" Button

    InfoView is not a 3rd party product, it is the end-user interface to Crystal Enterprise. It was called ePortfolio in CE 9 and is called InfoView in BO XI, not sure what name it goes by in CE 10 but it should be one of the two main links on your launchpad page. I believe as of CE 10...
  5. gortuk

    template update for reports with scheduled instances

    If I understand what you're asking, you just need to use File > Save As to save to Enterprise. This will allow you to overwrite the report on the Enterprise server. If all you've changed is layout then you won't need to reschedule the existing reports. However, you may need to re-enter the...
  6. gortuk

    Scheduling reports on Crystal Enterprise

    Success/failure notification was introduced in CE 10 so if you are running CE 9 this won't be available. If by 'checking manually' you mean you are currently checking each report history to see what failed, a faster way of doing this in CE 9 is to use the Instance Manager from the CE Launchpad...
  7. gortuk

    Email report with message

    Depending on the complexity of your output, you could try accomplishing this using Alerts. Create a alert in your report that will trigger every time the report runs (eg whenever a field that always appears in the report is not null). Set the text of the alert to a formula incorporating the...
  8. gortuk

    Exporting to CSV results in the page header appearing with every recor

    Have you tried the solution indicated in the Business Objects link you provided? Despite those comments in your link, the BO fix does work - or at least it did for me when I was running a CE 9 environment. You should at least give it a shot.
  9. gortuk

    Can we Delete output sub-folders under Filestore folder?

    This is not a good idea - if you delete files under the Filestore/Output folder, it will produce errors in Crystal Enterprise when users try to pull up historical instances of reports. The better way to do this is to delete instances via the Crystal Management Console - this will remove the...
  10. gortuk

    Report generates different data depending on computer

    You might want to make sure that what you think is the same database on both computers actually is the same database. For instance, if it's an ODBC connection you might have the same name but be pointing to different servers. Or if it's an Oracle database and was recently moved, you might be...
  11. gortuk

    Wildcard and % in formula

    If you Google "escape character" you'll get a more thorough explanation, but basically an escape character ensures that the following character is not interpreted, but just treated literally (eg "this is just a percent sign, not a wildcard").
  12. gortuk

    Wildcard and % in formula

    Have you tried using an escape character in your select statement? eg Not ({PM00200.PYMTRMID} like "*\%*")
  13. gortuk

    Formatting an address field

    I was going to suggest using the ProperCase function but it appears this was only added in CR 9. However, there is a UFL available to do the same thing in CR 4 and higher: http://support.businessobjects.com/communityCS/FilesAndUpdates/uflcaps.exe
  14. gortuk

    Is it possible to access and analyse the log files created by CE10?

    If you're referring to the IIS web server logs, they're located at c:\WINDOWS\system32\LogFiles\W3SVC1 on your server. You can actually use Crystal Reports to report off of these files using the "MS IIS/Proxy Log Files" connection type. The IIS logs are not terribly useful, but you can obtain...
  15. gortuk

    Batch Processing

    You'll need to use a 3rd-party add-in that offers "Bursting" functionality in order to do this efficiently as there's no good way to do this with out-of-the-box Business Objects Enterprise. I'm familiar with APOS Bursting Manager as one option, but there are a number of 3rd party tools listed...

Part and Inventory Search

Back
Top