I've created a report in XL reporter that looks great. I've setup a package, job and everything. The problem I have is that I need it to run weekly for the most recent week. I need to know if it's possible to set the parameters so that it will run for dates relative to today's date. In Excel Composer, I have the criteria set to select data like the following:
FACT FIG( RefDate = "7/1/2008":"7/31/2008" ) Group By FIG.RefDate
I need it to be like the following:
FACT FIG( NOW() - DAY(7):NOW() ) Group By FIG.RefDate
This second method obviously doesn't work, but if I can do something like this, please let me know.
Also, I thought about setting up a parameter and entering the parameter in the package, but I need the package to be able to enter dates relative to the current date, and I don't think it can do that.
Please prove me wrong.
Thanks,
Robert