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

missing field names when inserted as a subreport 1

Status
Not open for further replies.

abhi900

IS-IT--Management
Jul 1, 2010
117
AU
Hi,
A bit unusual over here..

HAve 4 sub reports to be inserted into the main report

3 /4 reports have a common formula {@formuladate}. So when inserting subreport I do link them against this formula field.

However when inserted I can see that Field names in PageHeader goes missing. But its there in the original report.

Why would it go missing ?

At the same time my 4th report is running of different universe -B than the other 3 reports (they are against same universe - A).

So how do I link this 4th to the main report on {formuladate}. Even when this report is inserted into main report the Field names from PH goes missing.
So here are my created formula :-
MainReport >>
@StrMonth >> shared Stringvar StrMonth; {@month}
{@month} >> totext({A_query.Month Start Date},"MMMM yyyy")

Other 3 reports have :-
@formulaDate - totext({A_query.Month Start Date},"MMMM yyyy")

4th report has :-
@FormulaDate - totext({CF_query.Start Date of Current Month},"MMMM yyyy")

CAn you please advise and also comment on why the header field names would go missing ?

 
Subreports don't have page headers. Is that it?

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
hahahha..what?

what does that mean? So when you import import as a subreport then does it NOT import the PH ?? but then how do i get the OLE image used in the PH for the subreport in the main report.

and what about linking the formatedate fields with the main report ?
 
When you import a subreport Page headers become Report headers so will only appear once.

If you want a SR page header you have to create a fake page header group

Create formula
@Fakepageheader
Whilereadingrecords;
' '

Group on this formula in SR then in option check repeat on new page and make it Grp1

Place what ever fileds you want to appear as PH items in this group header

Ian
 
thanks for that advise.

I took that approach as well as moving my headers to Report Headers and that did work nicely...!

cheers
AB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top