Welcome, Guest
Username: Password: Remember me

TOPIC: Setup Event Manager to be a 6 month report?

Setup Event Manager to be a 6 month report? #2501

  • dawnh
  • dawnh's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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?
The administrator has disabled public write access.

Setup Event Manager to be a 6 month report? #2502

  • Dkloepfer
  • Dkloepfer's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 92
  • Thank you received: 2
  • Karma: 0
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?
Dave Kloepfer
http://www.synergyexpert.com
dkloepfer@synergyexpert.com
[url=http://www.synergyexpert.com:2v9xq3t1]Tips, Tools & Manuals[/url]
The administrator has disabled public write access.

Setup Event Manager to be a 6 month report? #2503

  • dgillz
  • dgillz's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
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.
www.gainfocus.biz
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
The administrator has disabled public write access.

Setup Event Manager to be a 6 month report? #2505

  • dawnh
  • dawnh's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
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.
The administrator has disabled public write access.

Setup Event Manager to be a 6 month report? #2507

  • pshirley
  • pshirley's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 54
  • Thank you received: 6
  • Karma: 1
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
Peter Shirley
www.erpessentials.com
The administrator has disabled public write access.
Time to create page: 0.043 seconds
Powered by Kunena Forum  Protected by R Antispam