Passing dates from subreport

[pomster]

I am developing a response time report where I need to make allowances for public holidays. Simple you may say, use Ken Hamady's business days formula.
In Australia, and probably elsewhere too, we have holidays that are state based so this formula wont work.
In my ERP I have table of public holidays that I use to populate a report giving the date and state on a detail line.
My idea is to pass these dates from a subreport into the main report using a date array? so that I can modify the Business Days formula to suit.
My question, how do I do this or is there a better way?

Using CR2008

regards,


David

CRXIR2 with CRXIR2 server and SQL 2005
CR2008 with CR2008V1 Server and SQL 2005

 

[IanWaterman]

Your appraoch is right, holidays SR will need to run in Report header. YOu can hide all the SR fielsd and make the object as slim as possible. Do Not suppress it or the section as it will not execute. If you are tight on space you can make the section holding the SR underlay following sections.

Populate a shared Datevar array in the SR.

Then in Ken's solution call the shared array instead of the list of holiday dates

Ian