don't want suppressed data in grand totals.

[FrequentUser]

I have to sort sets of plans reviewed and I need only the date of the first completed review.

I tried:
Minimum({APACT.COMPDTTM})
but some of the reviews are completed simultaneously, but I still only need the first to display.

I incorporated a Group Sort Exports to suppress when:
{@Plan #}=previous({@Plan #})
but it still includes the plans in the grand totals.
I need total number of first reviews performed.

how do you not include suppressed date in grand totals?

 

[synapsevampire]

Yeah, you'll need to manually do the aggregates.

In future posts, please include your coftware version and the database involved, you hamstring responders by not supplying the environment.

Try:
whileprintingrecords;
numbervar MyTotal;
if onfirstrecord
or
{table.field} <> previous{{table.field}) then
MyTotal:=MyTotal+{tale.value}

Now after that section you can display the total using:
whileprintingrecords;
numbervar MyTotal

I don't know what is in @plan, if you reference formulas, show what's in them.

I also don't know if there's any grouping, if there is, then you need the 3 formula method:

Group header formula:
whileprintingrecords;
numbervar MyTotal:=0;

Details:
whileprintingrecords;
numbervar MyTotal;
if onfirstrecord
or
{table.field} <> previous{{table.field}) then
MyTotal:=MyTotal+{tale.value}

Group footer (where you display)
whileprintingrecords;
numbervar MyTotal

-k

 

[FrequentUser]

using Crystal Reportx XI, SQL Server 2000, with ODBC

When I tried your suggestion as a formula it states:
"that must be evaluated at a later time." (referencing the {APACT.COMPDTTM}

Formula: [/b]{@Plan} =
If IsNull({VBRBLDG.PLANNO}) or length(trim({VBRBLDG.PLANNO})) = 0 then
{VBCBLDG.PLANNO}
Else
{VBRBLDG.PLANNO}

Group Sort Expert: Suppression for Details section:
{APACT.COMPDTTM}=previous({APACT.COMPDTTM})

2 options:
I need to either not include the suppressed date in the totals
or
only display the first date of each plan review

 

[synapsevampire]

Post the formula you tried...

-k

 

[dgillz]

Why are you suppressing the data instead of excluding it from the report with a record selection formula?

If you exclude the data from the report rather than suppress it, it will not be included in the summaries.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[FrequentUser]

Ok, this might be easier to solve . . .

Formula: {@CompDttm} =
If {apact.compdttm}=previous(apact.compdttm) then "1" else "0"

I made this formula and then tried to do a Select Expert setting the value equal to "1", but the formula is not available in the choose field box (in Select Expert)

any suggestions . . .
I also cannot perform a Count of this field.?