Hello,

Is there a way in Event Manager to setup a report to be a 6 month report without having to go into Event Manager each month to change the begin date?

Can you describe your requirement more in depth. It sounds like you wish to kick out a report every month with the previous six months activities listed. Am I correct?

If you base your report off of the current date rather than a prompted date, this is very doable, Create formulas for the start and end dates based on the current date. If you need help with this post again with specifics, and I'm sure we can work it out.

Hello,

We have several reports that are run via Event Manager without having to update the date parameter. Event Manager has a set number of date parameters programmitically setup, for example:
1. {%Last Month Start Date YYYY-MM-DD%}
2. {%Last Month End Date YYYY-MM-DD%}

Normally, my reports are run at month end, so all I would need is to run the reports from the beginning of the prior month to the end of the prior month. This can be done using the parameters that Event Manager has setup above, however they don't have a parameter that says something like {%Six Months Prior YYYY-MM-DD%}. I have to go into Event Manager manually each month and change the begin date.

Has anyone found a way around this? I would really appreciate your help.

Thank you in advance.

Remove the date parameters from the Crystal report(s) and instead setup the selection criteria within the report(s) themselves to reflect the 6 month range i.e.

{Table.Date} in DateAdd ("m", -6, CurrentDate) to CurrentDate