Search results for query: *

Charles - thanks for the suggestions. I went down the mathmatical road regarding non numericals but will look at using aliases. Do you happen to know the character limitation - binary something?

Is there a limitation to the number of operators you can have in a decode statement? ie I want to calculate annual 401k eligible earnings - so Gross pay less 24 earnings codes. Is 24 too many. I'm returning an immediate blank report. My derrived field has 0 for all null values. I remove...

My 2 cents... ...slow reports questions return a "don't use that table, use this one" type reply from our ADP partners. No attempt to ADPbash, they're learning this product too. Tough to find depth of knowledge, hence this forum.

Hi all - I have a report I'm attempting to run via macro and having difficulty setting date format/parameters. Here is syntax that compiles ok, but not running correct. I need variable 1 to be 1st of the month and variable 2 to be the last day of the month. LoadReport "*report...

ReportSmith is pretty straight forward. It uses 'menus' to write SQL. I find the logic with the menus to be a bit more novice user than the sql and therefore fairly simple to learn. As a new user, I believe it taxes your understanding of relational databases, table structure of the data, and...