Search results for query: *

[tab]Since there doesn't seem to be any way to suppress both group footers, only when the shared variable is zero, I have decided to approach this report from a completely different standpoint. It makes the main reports record selection a little more complex, but my documentation should clarify...

lbass, [tab]I don't know what changed between the last time I did this and this time, but it's working now. At least as far as the shared variable being with the correct group. However, now I can't suppress GF#2a and GF#2b when the shared variable is 0 (zero). I set section GF#2a to Underlay...

lbass, Thank you for your reply. I have already tried your suggestions. If I put the shared variable in any section below GF#2a (where the subreport is), it always has a zero value. And the only way I've been able to get the reset formula to work, is to place it in the same section (GF#2a)...

I am trying to do something very similar, using CR8.0, to what arachnoid was doing. My main report summarizes dental claims for all groups in a given month by group type (HIPPA, Large Group, & SEHI). For each group, the report must show the total number of group employees that are eligible for...

Gary, [tab]Thanks for the instructions. Unfortunately, our installation of Crystal does not prompt for connection. However, while experimenting with a new test report, I discovered a checkbox in the Data Explorer Options (and in File|Options...|Database tab) called "Reprompt user when...

Thanks to lbass and Turkbear for their help. [tab]In December of last year, per a request from the users, all of the monthly reports were modified to default to the last completed month, but, permit overriding start and end dates to be entered. This solution uses Maximum(LastFullMonth) and...

Gary, Thanks for your quick reply. Yes, I have confirmed that all of the reports in question have the "Save data with report" option turned on. As for opening the reports without connecting to the database, I am not familiar with this concept. Although I'm not a complete Crystal newbie...

We are using CR8.0 running against MS SQL Server database. Our underwriting department has been using numerous parameterized reports, for several years, that have been created for monthly and quarterly reporting. Due to regulatory and audit requirements, each instance of the report is saved...

After a heated "discussion" with all of the principals, we decided to take a performance hit and revamp the report. It's slower but synapsevampire's method using distinctcount({table.groupfield}) works, now. Thank you for the help. A few people who weren't listening before, have openned...

Unfortunately, this has the same issue we ran into when we used running totals. For my current test distinctcount({table.groupfield}) gives a value of 32 (the number of records in the suppressed Details section), while the actual number of records printed on the report is only 19. For some...

When I attempt to include distinctcount({table.groupfield}) in a formula, I get a "This field name is not known." error. In what way am I using this incorrectly? -Jamie

We have created a report in CR8.0 which lists members by Member Number. Because the selection criteria is very complex and requires the use of many linked tables, the only consistent and efficient (report must be generated in a matter of minutes) way to insure that the member appeared on the...

Rosemary, Thank you very much. This corrected the error and produced the expected results. - Jamie

Because the error prevents the code from actually being generated, I can't open the SQL panel. -Jamie

Turkbear & Synapsevampire, CR8.0 doesn't appear to recognize End Select (or even End). It made no difference and I received the same error. I appreciate both of your help very much and would welcome more ideas as to why my code doesn't work. Brian (bdreed35), Thank you for your...

My apologies to Turkbear and bdreed35. I was responding to Synapsevampire when both of you responded, so my last message looks like I was responding to you. I will try your suggestions and then respond to the thread. -Jamie

I'm getting the same error (in the same place) with both your suggested changes. However, using if statements in place of the select case statements (see code sample below) doesn't produce the error (and works as expected). - Jamie Local DateTimeVar EndDate; Local DateTimeVar BegDate :=...

The underscore next to the "to" tells Crystal that you want all dates in the range up to, but NOT including, the EndDate. Basicly, I'm telling Crystal to select dates using the logic: BegDate <= {FaceSheet_vw.Date Received} < EndDate . You can use the underscore on either or both sides of...

I'm getting a "The remaining text does not appear to be part of the formula." error in my record selection formula (CR8 reporting against an Access 2000 DB) when I attempt to use the following Select Case function (Crystal syntax). The 'remaining text' is the actual selection formula (last two...