Running Total - start count with value of 2 1

[tkschief]

Is there a way to to set up my running total fields count to start with the value 2 each time? This is what I have:

Summarizing field = L_Event_Type.Event_Type_Name
Type of Summary = count
Evaluate = for each record
Reset = on change of group T_Case.Case_Num

I'm speculating I maybe need to use a formula for the Evaluate section instead of Evaluate for Each record?

I'm using Crystal Reports 11.

Thanks for your help!

Teresa

 

[lbass]

Use a manual running total. Create three formulas:

//{@reset} to be placed in the group header for case_num:
whileprintingrecords;
numbervar cnt := 2;

//{@accum} to be placed in the detail section:
whileprintingrecords;
numbervar cnt := cnt + 1;

//{@display} to be placed in the case_num group footer:
whileprintingrecords;
numbervar cnt;

-LB

 

[tkschief]

Hi LB,

Another situation has presented itself with this solution after I ran my report. Sometimes, I will not have a number 2 record; how do I not get 2 to display if there is no event_date_time record? Instead of a blank 2?

Thanks!

 

[lbass]

I don't know what you mean by a "blank 2" or a "number 2 record". Are you saying you want nothing to show if the event_date_time record is null? You could try:

//{@reset} to be placed in the group header for case_num:
whileprintingrecords;
numbervar cnt;
if not isnull({table.event_date_time}) then
cnt := 2;

Not sure, as I'm not really following.

-LB

 

[tkschief]

Thanks LB you followed just fine. We decided to use the blank 2 as an integrity point. This is what occurs when there is not an event for the case:

1. Normandale
2.

In most instances I do have an event so it displays as:

1. Normandale
2. Transcript delivered: 06/15/10
3. Transcript reviewed: 06/15/10

Thanks!

 

[lbass]

So are you all set?

-LB

 

[tkschief]

Yes I am - Thanks!