Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals

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: 4619
Joined: 28 Feb 2006, 09:56
Sage Version: v28 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 :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 20 guests