Trying to pull information into the report footer

[Bobbs23]

I currently have a report I have already designed and now I want to pull information into the report footer, but base this information I want in the footer from a week ago. For instance my datetime would be 7 days prior and then I would have conditional statements. Could anyone help me with this?

 

[pgtek]

Hi
Create a sub report and insert it in the report footer

base on your paramter or other filter

cheers


pgtek

 

[Bobbs23]

I thought about the subreport after submitting the post. However, I cannot get the subreport link to work correctly with the main report. Any ideas?

 

[pgtek]

Hi
used a common filed to link both report together

cheers

pg

pgtek

 

[lbass]

You need to provide more information about what you are trying to do. One way of pulling the data is to use date parameters in the main report for start and end of the date period and then create a start date parameter in the subreport also, and use this to link to the start date parameter in the main report. Then in the subreport, use a record selection formula of:

{Orders.Order Date} in {?start}-7 to {?start}-1

-LB

 

[Bobbs23]

Thanks lbass and pgtek this has really helped.