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

can't link formula in subreport

Status
Not open for further replies.

pieter12

Technical User
Sep 30, 2002
4
NL
Hello All,
Im still stuck with the following

I tried synapsevampire's example in a other thread of mine but im still struggle with it for day's, I've made 2 parameters start date and end date both are linked to browse table esapor and browse field st_dat_ser.

I've made 2 formula's
{Esapor.st_dat_ser} = {?startdate}
{Esapor.st_dat_ser} = {?enddate}

I have to following in my select expert in main report
{Esapor.st_dat_ser}> = {?startdate}
{Esapor.st_dat_ser}< = {?enddate}

If i put this in the subreport select expert it gives the error this field is unknown.(i know ,its not there or not linked)

Everything works fine in the main report.
You said link the formula's to the subreport. My problem is i can't choose subreport field because it's empty i can only chose the subreport and the subreport table if i run the report the 2 links are gone.

Where do i go wrong ?
 
I don't know what this means:

&quot;My problem is i can't choose subreport field because it's empty&quot;

If you have a single date parm or formula of the same type as the field you want to limit in the subreport, they should link, it doesn't matter if there's any data.

-k kai@informeddatadecisions.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top