Search results for query: *

I am assuming that you do not want to use the Retrieve XLL that Hyperion provides. You can access Hyperion Enterprise applications via VBA by using the Hyperion API. If you haven't used it before it will take you a LONG time. You can call the Retrieve functions directly from VBA but you must...

Ken - the reports do not have any saved data. Konad - the same install is used for all the machines. That doesn't necessarily mean the files are the same though. Are there any patches to CR 8.5? I'll check the file dates and versions. Many thanks for your input.

I'm calling CR 8.5 from VB6 using CRAXDRT. On some machines the reports work fine, on others it works the first time but for all subsequent runs it displays data from a different table. This 'extra' table is not referenced anywhere in the report but is used as a working area by VB. VB updates...

I have had similar errors which were due to the database location in the report being different to the database being used by the VB program. However, I always got the error before the report was displayed so you might have a different problem. I use CRAXDRT. Anyway, here's the code I use - hope...

You could enumerate the parameters like this: (Create the application object and open the report before you do this) Dim crxParameter As craxdrt.ParameterFieldDefinition Dim nCounter As Integer Dim sParam as string For nCounter = 1 To crxRpt.ParameterFields.Count 'pick off each parameter...

Ngolem - thanks. I haven't done quite what you suggested but you've certainly put me on the right track. I didn't want to put the Company header text in Footer 1 because I thought that even if I could suppress all but the first I would have difficulty formatting the report so that the blank...

Patches for Hyperion Integration server are available at http://custserv.hyperion.com/support/supportchoices.cfm BUT you must have a customer login id and to get one of those you must be an existing Hyperion client or partner.

I don't use RecordSelectionFormula - my reports use parameters and I update the parameters through code eg the report selection says {User} = {?User} and I then update the contents of {?User} by enumerating the contents of ParameterFields. Sample: Create the object and open the report as...

I'm no expert but at a guess I would say you need to instantiate the Crystal Application object before setting crxRpt something like: Dim crxApp As CRAXDRT.Application Set crxApp = CreateObject("CrystalRuntime.Application") You have used: Dim crxApp As New CRAXDRT.Application...

The formula to suppress Group Footer 1 does not suppress the Group Header because the whole group has to be evaluated before the suppression can work. The report counts the number of records printed by using the formula in the details section: if {@Variance} <> 0 then 1 else 0 If the...

I want to suppress the group header where the group itself is suppressed. I have tried all the suggestions in other similar threads but none of them work. It is an intercompany report which lists how much company A owes company B, C, D etc and how much company B, C, D etc owes company A. If it...

You get the 'cannot find physical db file' error when the report was written using a db file that no longer exists eg you wrote the report using the db 'DB1.MDB'; 'DB1.MDB' now does not exist and your program is writing to 'DB2.MDB'. You need to update the location of the db file in your code...

I have a program that does much the same. Sounds like there are some DLLs missing. In order to export to PDF using 8.5 you need (assuming CRAXDRT.DLL is installed) : Windows\Crystal ExportModeller.DLL (must be registered) CrtSlv.DLL (must be registered) CRXF_PDF.DLL as well as the Export...

Background: I am using CR 8.5 with VB6 to export a report with a subreport. A central user needs to create and email a report to a list of users. Each user will get different data on the report. The central user previews the report which contains the data for all the users. When the report is...