Counting subreport records

[Ray Cacciatore]

I have a main report and a subreport. I need to add a flag in one of the
records in the subreport that indicate that it's the last record in the
subreport.
For example, for each record in the main report there can be 5 corresponding
records in the subreport. The subreport shows the 5 records but I need to add
an asterisk on the 5th record. What is the condition that I can use?

 

[Duane Hookom]

I would add a text box to the detail section of the subreport:
Name: txtCount
Control Source: =1
Running Sum: Over all
Visible: No

Add another text box to the subreport detail section:
Control Source: =IIf([txtCount]=Count(*),"*",Null)