Need more help now? use pay-as-you-go support, call now 03333 445950

We offer rebates on Sage50 subscriptions, discounts on products, service sagecover (not renewals) and stationery.

We also provide Sage 50 integration and email/web services.

custom date selection parameter

Report design issues and solutions.
Post Reply
MartinD10
User
User
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

Martin

User avatar
brucedenney
Site Admin
Site Admin
Posts: 3909
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