Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PrePrinted Forms

Status
Not open for further replies.

Keoki

Programmer
Feb 22, 2000
22
US
I am trying to create reports for a couple of preprinted forms (UB92 and HCFA - medical forms).&nbsp;&nbsp;Data on the top third and bottom third would be in the group header and footer.&nbsp;&nbsp;The detail section in the middle is limited to 23 lines.&nbsp;&nbsp;This section I am planning on handling with a subreport.<br><br>I thought what I would try to do is put a counter in the subreport.&nbsp;&nbsp;Once the counter reaches 24, the rest of the detail would need to go to the 2nd page.&nbsp;&nbsp;What I can't figure out how to handle is the group header and footer.&nbsp;&nbsp;The same information would need to be printed on each page as the detail progresses to the next page.&nbsp;&nbsp;Am I making sense?&nbsp;&nbsp;<br><br>If I were to break page once the subreport filled the 23 detail lines for the first page, then the group footer information would not print out on the bottom of page 1 and at the top of page 2, I would need the information that printed at the top of page 1 in the header section to print again on page 2.&nbsp;&nbsp;Each patient would have their own set of preprinted forms with their information only.<br><br>Also, would CR understand to start the detail section on page two with the data for line 24 and, if required, the detail section on page three with the data for line 47?<br><br>I hope this makes sense and you are able to help me work this out.&nbsp;&nbsp;<br><br>Thanks. <p>Keoki<br><a href=mailto:gb@cardinalhill.org>gb@cardinalhill.org</a><br><a href= > </a><br>
 
I'm not sure why you are using a subreport - could you just put the patient info in the detail, page header, and page footer?&nbsp;&nbsp;Then format the detail to have a page break after every 23 lines?&nbsp;&nbsp;Then the correct patient info will be added to the page header and footer, for as many pages as are required.&nbsp;&nbsp;You will still need to group by patient, but the patient info doesn't have to be in that group.<br><br>The following formula can be used for &quot;page break after&quot; in the detail section:<br>WhilePrintingRecords ;<br>NumberVar RecordCount ;<br>Remainder(RecordCount,23) = 0<br>You will need to reset the value of RecordCount to zero every time the patient id changes, and increment by one for every row.&nbsp;&nbsp; <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top