Hi,
I am looking for suggestions or ideas on how to get my end result. The end result would be to store excel compound reports in the library by location with versioning. Location is a hierarchy file and I am using to retrieve parent and all children. This request is two fold. One is to use the library to store the reports and second is to select their main location and the reports run for all the children locations.

Lets say they want all of Michigan's excel reports, so location would grab Lansing, Grand Rapids, and Detroit, but under Detroit, there are more children values, such as Redford, Troy, Dearborn, Livonia, etc. The metro Detroit area consists of several cities.

Client wants them stored in the report caster library with versions, each by location. The reports also need to be printed off to be signed. So, they will more than likely have to run twice, once for the library and again for the printer. They do not want to manually print each report. There will be too many.

I'm currently testing the excel compound report in the library. I was hoping to burst the reports by location. However, if it is going to the library, report caster does not allow me to enter values for bursting. Only for the printer or emails.

My other alternative was to do a loop and execute the fex for each location but report caster only does the last one. But we still want to use the library.

Any ideas or suggestions? Thank you in advance.

Kathy - 7.6.8

This message has been edited. Last edited by: Kerry,

Look up information on Report Library Access List.