Sub-report size

[jgelpi16]

I have a sub-report that lists accounts for a customer. I need the report all to fit on one page so if the sub-report has more than 4 records in it I need to display "see attachment" and print off an attachment page. Otherwise I just need to print the main report. Any ideas/suggestions/reference links on this? Thank you!!

[ajetrumpet]

not sure. have you looked into using line breaks though? that's a possibility. you can obviously check the recordcount of the subreport, but offering some sort of an attachment might be more difficult, depending on what you're thinking about doing.

[jgelpi16]

Well what I could settle with doing is the following...

If the record exceeds "X" number of records display "See Attachment". When the user prints off the reports they will see the "See Attachment" and then go print the attachment. As I said I'm not very good with reports. Where could I access the "record count" feature?

[jgelpi16]

Ok, I've figured out the record count. My next problem is getting to limit the records, and if the records exceed that, "See Attachment". I have a text box in the footer that counts the number of records on the sub-form. I tried putting a criteria in the SQL statement

IIf([Reports]![SrptPeriods]![txtCount]>10,[BegPd]="See Attachment",[BegPd])

Unfortunately nothing happens...