Recent content by Whippingboy2004

One more thing...depending on what I've entered in for the various parameters, I get locked out of the Preview pane. It will allow me to enter my first date and then begins flashing various entry fields and is basically locked.

Yes, this is VERY confusing! I have my Subreport Parameters, located under Properties, and then there are the Report Parameters, which have both the Main and Subreport Parameters listed. I have two stored procedures. The main one has BeginDate, EndDate, County and Region for query parameters...

Thanks for your help Geoff. I'm coming up with an error message in the Preview pane that says "The value expression for the query parameter WorkerID refers to a non-existing report parameter 'WorkerID'" There's probably one small thing that I'm overlooking. I appreciate your assistance on...

I'm having trouble adding a subreport onto an existing report. The main problem that I'm having is with the parameters. I'm using stored procedures for both the main and sub. They both have input parameters of @BeginDate, @EndDate, @Region, and @County. Is it possible to pass the subreport...

I'm having an issue with a report I'm trying to write in SQL 2000. I'm trying to determine a count for each letter type (NewCert and ReCert, the final report will have about 10 types) AND want to count each Case only once for each letter type. SELECT DISTINCT(tl.CaseID), NewCert=CASE...

Thank you for your responses, however I have a question about leap years, which is represented by the 365.2524 in my original equation. Dividing by 12 doesn't quite cover them. Any thoughts?

I'm having a problem with my age function returning a decimal point with either one or two trailing zeroes. I've tried using LEFT, but since my ages are being returned as either single or double digits, it's not been successful. What I'm trying to accomplish with this is to get the age in...

Hello LBass! Thanks for replying to my post. I have tried unchecking the "Show All Headers on Drilldown" option, but then I have a problem with my report headers not showing up on my drill downs. Any other suggestions Lbass?! Thanks for your help! P.S. I was able to uncheck this option after...

I forgot to mention that I'm using Crystal 8.5. Thanks, T.

Is there a way to suppress the total from GF1 in the various drilldown sections as shown in the following: GH1 Region GH2 County (drilldown) GH3 City (drilldown) D ZipCode (drilldown) GF2 Region Total (drilldown) GF1 State Total I would like the State Total to show on the first page...

Thank you Lisa! Works like a charm.

Thank you Lisa for your quick reply! I've been able to finally take care of Part I of my question, so that is no longer an issue. Here is what the data looks like in the Details B section: Home Mail Phone Group Health Anchondo, I 0 0 0 0...

This is a two-part question. 1). I'm having an issue with all of my data showing up in the detail section. For some reason, only the first CaseName is appearing. I'm using Crystal 8.5 and getting my data from a stored procedure in Microsoft SQL Server. The data is being returned normally in...

Karl, Thank you so much. I'm creating the function now and I'll let you know how it turns out. You've been extremely helpful! T.

Karl, Thank you so much for your help. I've been trying to find a work around for the cursor, but haven't had much success so far. Here's the data from my table: OutreachID Descript CaseID RecipientID ----------- ------------------------------ -----------...