We are using EM 7.8 with Max 5.0. In the FIM, Costing module there is a FromTo report that we would like to automate to run on a periodic basis. When the report is run from within the Max GUI, the user has several options to choose from. However, the canned Crystal Report itself does not have any builtin parameters that correspond to the options in the GUI. To make it more challenging, this report uses a black-hole staging table called dbo.Report_Extract for most of its functions making understanding the logic very difficult (or impossible).

I'm hoping someone on this list has had experience automating this report or a similar report in Max that uses that Report_Extract table.

Thanks