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

Main report Page header is displaying in the sub report in crystal

Status
Not open for further replies.

143Aroul

Programmer
Jul 17, 2003
16
FJ
I designed a report in crystal report and the page header is like

Month Year Emp.No Name Basic

in the same report i added a sub report

with the below heading

Year Name Tot.amount

When i call the report from VB6 is printing well but the main report page header is displaying in the sub report. how to avoid printing the main page header in the sub report


 
That's the way it works.

Consider at least posting the version of Crystal that you're using.

If you want a different page header within the subreport, try creating a faux group and treat it like a page header by using a new page before.

The formula to base the faux group on might be:

if {table.field} = "UFFHEDOE24872391453" then
1
else
0

Since your field won't ever equal that, you'll have everything grouped together and the group header will serve as a page header.

-k
 
This depends upon where you are placing the subreport, but if it is in the group footer of the main report, then you could format the page header (format->section->page header) to suppress using the formula:

{table.groupfield} <> next({table.groupfield})

You might also want to insert a new page before and a new page after the group footer, and in the latter case, add the following in the formula area: Not OnLastRecord

If you use the faux group method within the subreport in order to get repeating group headers, then insert a group on the formula and choose "Repeat group header on each page".

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top