Search results for query: *

I don't have CR8.5 or 9 yet - can anyone tell me if the issues mentioned in this thread had been addressed in these version? Can a subreport be printed to a printer using the RDC integration method? Thanks, Diane

I'm looking for the best way to implement the statistical mode calculation in SQL. Mode is value in a list that occurs the most often. For example I have a table (Temp) that has a column (TempCol) with the following rows: a b a c a a The mode of these rows would be 'a'. This is the code that...

In order for the Oracle stored procedure and the report to communicate with each other you need an IN OUT REFCURSOR parameter (rc1 in my example). If you make it just a regular OUT parameter (not a REFCURSOR) you cannot pass a recordset to the report. If you make the REFCURSOR parameter just...

I'm using Crystal Reports version 7 MR1 Print Engine API calls in VC++. A user has a report open and has maybe drilled-down on a few on-demand subreports (opens additional window tabs in the Viewer). What I need to figure out is the tab that is active in the Viewer (just whether it is the main...

I'm using Crystal 7 MR1 API Print Engine calls in my VC++ app to print the report that is open in the viewer window. The series of print engine calls that I make to print are: (1) PEGetSelectedPrinter to get the printing info from the report, and I use the returned info to set the page...

The way I use Oracle Stored procedures with my reports is by returning the data in a ref cursor. So first I declare a package to use: create or replace package spm as type rctl is ref cursor; end; then you create your stored procedure with whatever parameters you want, returning whatever data...

My VC++ program is being run on a Citrix box, and on Citrix you can have printers installed and you don't have to have one selected as the default. In my program I make calls to get information about the default printer and I'm unclear as to what the behavior is when there isn't a default...

I'm wondering if it is possible to have printers installed, but not have any of them set as the default printer. If so how would I go about doing this? My guess would be that it involves modifying the registry, but which keys? Thanks, Diane

I'm evaluating whether to switch from using Print Engine API calls in my VC++ app to using the RDC (version 8 of Crystal Reports). I've heard that Crystal is no longer going to make improvements to the Print Engine, the RDC is going to be their main integration method from now on. I've found a...

I'm evaluating whether to switch from using Print Engine API calls in my VC++ app to using the RDC (version 8 of Crystal Reports). I've heard that Crystal is no longer going to make improvements to the Print Engine, the RDC is going to be their main integration method from now on. I've found a...

Steve, I'm assuming that you are using the RDC in your app. You can create your own 'Print current page' button and do the following when the user selects this button. The GetCurrentPageNumber method of the CRViewer object returns the current page number of the report being viewed. You can...

I'm wondering if it is possible to pass multiple values into a single stored procedure parameter. As an example let's say I have a stored procedure that returns the number of hours a person has worked when passed in an ID. Would it be possible to pass in multiple ID's (perhaps an array), and...

I've created a cross-tab report that spans several pages down in the viewer and possibly up to 3 virtual pages to the right. The cross-tab is placed in a group header section. When I try to use the page up or page down arrow buttons in the designer an error message occurs. The error has a...

I'm trying to create a formula that returns a string which contains a return character. I can't seem to figure out how to do this. I'm C/C++ programmer so I'm used to the '\n' character as a newline or carriage return character. Is there something in Crystal that will do what I want? Diane

Seagate doesn't seem to have anymore documentation for VC++ besides a couple of example programs. If you are using Crystal Reports 8 checkout the Salaries sample program provided on the installation CD. This sample imports the craxdrt.tlb. Another sample program that might be useful for...