Preview multiple reports on one Main report?

  • Thread starter Thread starter Freddie
  • Start date Start date
F

Freddie

What I want to accomplish: I want to be able display and sort several
different reports in one report.\

Here is what I've done so far:

I'm creating a report which will allow me to view multiple reports in
preview mode. I have a Rpt called RptMain, and I created on this report 3
footer section, each will house my SubRpt's, sub1, sub2 sub 3. All my
SubRpt's source object are full reports including headers and detail section
respectively. For some unknown reason I cannot see the headers of my
subRpt's. How can have access to these subRpt's control and display my
headers? If there is a better way, please advise.


Fred
 
Page Headers do not work in subreports.
Group Headers do.

Create a group header in each subreport, and set its Repeat Section property
to Yes so that it appears on each new page.
 
Allen,
I've done that and I don't seem to have any control of the controls on
the sub form group header. I allow my users a method of sorting the sub
report, which I have not gotten to work either, and depending on which sort
option they choose, I then toggle the visible property of a label on the sub
report group header to show the sorting i.e "Sort by Alpha", or :Sort by L
Name." Any thoughts?

Fred
 
When are you trying to set this?
Try setting the label's properties in the Format event of the Group Header
in the subreport.
 
Allen,
Thank, that works fine. But I do how ever have one more question. The
user selects a sort option on a form that Call the Main Rpt, all my subs or
sorted the same way. How can I set the SortBy property of each individual
report. I tried on the open event of each report but I get an error stating:
Run-Time error '2101' The setting you entered isn't valid for the property.
Any ideas?


Fred
 
You are trying to dynamically change the sort order of a subreport.

The Open event of the subreport may be called twice, so you just might be
able to work around this error with On Error Resume Next at the top of the
Report_Open event.
 
Back
Top