Search results for query: *

I just recently went through the same tumult, yes, you do need Professional to Reverse Engineer a database. I verified this in the Visio 2003 feature comparison. Pretty unfortunate they made someone upgrade to obtain this core functionality. If you can't be troubled with upgrading, I'd...

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

Skip, Ah, yes, now that I've understood the use of Match() to determine the horizontal movement of the target cell. Worked like a charm, thanks kindly. Jeff.

Skip, Yes, that is my problem, and why my 1 year rolling calculation is not working. I basically need something that works just like HLOOKUP, but returns the CELL REFERENCE and not the VALUE as HLOOKUP does. Not too certain what you mean about the MATCH function, could you please elaborate a...

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

Bob, Just wow, I had no idea about CurrentFieldValue. That did the trick exactly! I can apply that to other areas as well. Thanks kindly, Jeff

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

Scott, The viewer, and why I didn't mention it, is actually some very light-weight viewer built by a company called Financial Technologies, released with their Investran Accounting product. I would actually be a bit surprised if anyone on here has used Investran, and even more if they used the...

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

k, That is what I am attempting to bypass, actually having to save the report again, after each change I make. The reason why this is a hassle is say I have 10 different Crystal Reports, all using the the same underlying data driver, stored proc, what have you. If I make a structural change...

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

Madawc, I guess I am just a bit confused as to how joins in Crystal Reports work and having been unable to find a decent reference to show how the datasets are combined. (Sorry, I didn't spell out the problem well enough, slightly hard to explain) I have the two datasets, DS1 and DS2, here is...

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

Dave, Logically I now see I should make certain the value is not null first, before checking if the value is greater than 0, but why does that make a difference in this case. If a value is null, how would it still pass the second part of the test, the not(isnull()) piece? It worked by 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...

lbass, It took me long enough to finally get around to it (I am so ridiculously backlogged on reports), but that distinctcount worked perfectly. Thanks lbass, Jeff.

I just implemented synapsevampire's parameter breakup suggestion, unfortunately still no dice. (Not to down play it, I have a feeling it will be of use to me yet) I dropped them all into one text object and I believe that is still the problem, the fact they are all in one text object still...

synapsevampire, I am of the current service pack (4) for CR 9, so the formatting problem addressed apparently was not the one I am experiencing. I understand exactly what you are getting at with your example to break up the text field, my problem is that the text field in general, regardless...