Search results for query: *

Greetings, I have a DTS with a VBScript component that has a Function Main() and a Sub Test() in it. Is there any way I can call the sub within main and using error handling, set Main = DTSTaskExecResult_Failure? Ex. Sub TestArray(aTest) On Error Resume Next aTest(1,2) = "This is out of...

Greetings, I have a DTS with a VBScript component that has a Function Main() and a Sub Test() in it. Is there any way I can call the sub within main and using error handling, set Main = DTSTaskExecResult_Failure? Ex. Sub TestArray(aTest) On Error Resume Next aTest(1,2) = "This is out of...

Greetings, I am attempting to develop both year to date and 1 year rolling Standard Deviation for a set of data recorded monthly across several years which would be based around a date reference point input by the user. Ex. Stock Returns on a monthly basis for two different companies. 1 A...

Greetings, CR Professional 9.2.14, SQL Server 2k, Investran Report Wizard, 3rd party viewer. I've searched through the archives and couldn't quite find anything similar so... I have a cross tab with the following output: Vehicle Name Strategy Fund Name...

Greetings, CR 9.2.3.1256, SQL Server I attempting to use the Covariance function but keep receiving "A number field or currency amount field is required" when attempting to take the covariance of one field containing a list of returns, and an array of numbers computers on the same report. Ex...

Greetings, Crystal Reports Professional 9.2.3.1256 on a SQL Server 2000 Database. I have a report with several Crystal Parameters, some text, some numbers, and when I run the report on my machine, via Crystal Developer, enter some parameters, run the report, close down Crystal, reopen it and...

Greetings, Crystal Reports Professional 9.2.3.1256 I've read a few other threads concerning the message that pops up when you make a structural change to the underlying driver datasource for a crystal report, but none of them mentioned a way to eliminate or suppress the little alter dialogs...

Greetings, Crystal 9 Professional, Custom OleDBProvider, Investran. I have the following 2 datasets in Crystal: - DS1: One Data set with a set of Batch#'s - DS2: Another data set showing all the batches I want to Inner join DS1 with DS2 on the Batch # in the Crystal 'Links' Tab, in the...

Greetings, Crystal Reports 9 Professional. I have a data set of Investors and the rates they pay. An investor either pays a 5% fee or a 0% fee (represented usually as a null). Investor fees are stored at two levels, first a check if their fee is stored at Level1, if not, check if it is...

Greetings, CR Version 9, SP4: I have a report with Crystal Parameters where the user enters in a large block of text, usually over bit over 1000 characters. Since the block is variable, I have my parameter field on the design view with "Can Grow" checked. I run the report and in Crystal...

Greetings, I have a fairly straightforward report that has a group header, details and 2 items in the group footer, 1a and 1b. I am attempting to suppress both of the group footers if a certain field in the details section only has one record in it. Ex. There are two components to an...