How to reference subreport field in formula

[lbunch]

I have a subreport that has a date field on a main report - I need to use that field in a formula on the main report but I do not see it listed with the other fields so is there a way to do this???

 

[lbass]

If the date you want is in the subreport, then in the sub, create a formula like:

whileprintingrecords;
shared datevar subdate := {table.date};

Then in the main report, in a section below the one in which the subreport is executing, you can reference the date in a formula like:

whileprintingrecords;
shared datevar subdate;

-LB

 

[lbunch]

I get an error "date is required" on the {table.date}

whileprintingrecords;
shared datevar subdate := {table.date};

 

[lbass]

You have to substitute your actual datefield for {table.date}. If you are trying to share a datetime, then use:

whileprintingrecords;
shared datetimevar subdate := {table.datetime};

How you set up this formula also depends on the layout of the subreport, how it is linked to the main report, etc., but you didn't provide that information. I think you should explain in more depth what you are trying to do with the date field. Also indicate in what report section the subreport is placed.

-LB

 

[lbunch]

Thanks - I think my actual field has time in it also so will try your last post.