Sage 100

Sage Intelligence Aging Report Customer wants a consolidated (multi-company) Aging report based on an aging date entered at run time (parameter). Can the run time value be passed either to Excel or to an Excel expression in the Connector so that the aging categories can be calculated? I created a pass through variable ""@aging@ but do not see a way to pass the value to either Excel or connector.

How many companies? We have done consolidated aging report using Access PTQ's and a select query to pull the data into crystal. Once it is set up, very easy to run,

Thanks @JeffSchwenk the customer is moving away from Access reports else I would have done exactly as you have suggested. They want all custom reports (with a few exceptions for Crystal) written and run from Sage Intelligence.

Ugghhh....

Sometimes you forget what you learned and then gratefully stumble upon it again - Sage Intelligence places all the parameters values for a report on Sheet2, by default. So, got my aging date.