Search results for query: *

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

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

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

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