Sage 100

A customer who "upgraded" to Sage 100 2018 and who uses TimeCard noticed that the Time Track report does not include the cost code field on the report. That's simple to fix.

They want to also be able to select the cost code range right on the report screen. I'm not sure that will happen if I add a parameter field but it's been a while since I've had to fine-tune selection criteria like this.

Is there a secret to me adding selection criteria so this user can select a cost code range to include on the report from the main report screen (ie not from a second pop-up prompt for parameters which is what I'm afraid will happen)




------------------------------
Wayne Schulz
Schulz Consulting - Consultant
Schulz Consulting
Glastonbury CT
860-516-8990
http://www.s-consult.com
------------------------------

One method is add a UDF to the main table the report runs off and use a script to mirror the value from the field you want to the UDF. The UDF should then appear in the report selection grid.

The other method which is a bit more hacky is to use a UI post-load event to add the field to the grid but this will only work if the field i part of the primary grid, at least that has been my experience. 

I don't have any experience with the time card/track in 2018 so i can't say for sure either of these methods will be feasible.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------

If you add the parameter/selection inside the .rpt, that additional prompt should appear upon running the report.

------------------------------
- Brett
------------------------------

Original Message:
Sent: 01-17-2019 13:24
From: David Speck II
Subject: Add selection criteria to report setting

One method is add a UDF to the main table the report runs off and use a script to mirror the value from the field you want to the UDF. The UDF should then appear in the report selection grid.

The other method which is a bit more hacky is to use a UI post-load event to add the field to the grid but this will only work if the field i part of the primary grid, at least that has been my experience.

I don't have any experience with the time card/track in 2018 so i can't say for sure either of these methods will be feasible.

------------------------------
David Speck II
Tennessee Software Solutions
------------------------------