Counting subreport records

G

Guest

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?
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top