Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue

Discounts on Sage products & subscriptions. Discounted subscriptions for customer using pay-as-you-go support or who are self-supporting.

Want web hosting, email, your own domain name, a shop, sage integration we can do it, from £12 a year!

custom date selection parameter

Report design issues and solutions.
Post Reply
Posts: 1
Joined: 17 Feb 2017, 16:26
Sage Version: Other

custom date selection parameter

Post by MartinD10 » 20 Feb 2017, 10:22

Sage HR v4.0 Sage Report Designer v1.3.2011.30

Complete newcomer to Sage but not reporting; trying to help a colleague. We have a custom report which calculates length of service to today's date 'NOW()'. My colleague works part-time and wants to replace this currentdate evaluation with a custom parameter - ie to be able to input a date (might be a month in the future or 6 weeks past) and have the results calculated and grouped accordingly. Is this possible, if so how? Currently the expression looks like this

TotalWholeMonths(vw_employment.StartDate, vw_employment.LeaveDate) / 12 >= 0 ? TotalWholeMonths(vw_employment.StartDate, vw_employment.LeaveDate) / 12 : TotalWholeMonths(vw_employment.StartDate, now()) / 12

many thanks


User avatar
Site Admin
Site Admin
Posts: 4021
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: custom date selection parameter

Post by brucedenney » 20 Feb 2017, 10:31

Why not keep it simple and add the dates as criteria?

in report designer

Report>Criteria>Add New Criteria
For just about anything Sage :- switch to subscription, pay-as-you-go support, sagecover, upgrades, application integration, reports, layouts, analysis or any other help making life with sage easier/less time consuming Contact me. Image

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest