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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to format a subreport in main report

Status
Not open for further replies.

Mackooo

MIS
Nov 17, 2005
18
US
hi Guys,

I would like to see a sub report to be formated in my main report. As I have filtered records for my sub report based on a linked field with my main report.

Now I can format the subreport on its own with constant number of lines printed with a funtion called in print event of the header and detail section as shown
GROUP HEADER: OnPrint Event
=SetCount([Reports]![Rpt How To Print a Constant Number of Lines Per Group])
DETAIL SECTION:OnPrint event
=PrintLines([Reports]![Rpt How To Print a Constant Number of Lines Per Group],[TotGrp])

Where setCount and Printlines are function

Now I would like to call this form in subreport, when I do that I am getting an error and I not sure how to call this in my main report which is REPORT1.

Please help me how to call these references in my main report.

Thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top