I have a report that shows all employees who have suppressed vouchers to date (most recent paydate). I need to modify the report to show those who just suppressed vouchers beginning on the most current paydate, and not those that previously suppressed. I can't find a way in ReportSmith to get the results I am looking for. Can anyone help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent Employees Who Suppressed Vouchers
- Thread starter lily05
- Start date
CharlesCook
Programmer
The way I would approach this is to create a Derived Field that has a Select in it. The Select would return the Previous AL_CHK_DATA record's SUPPRESS_VOUCHER field. (MAX(INNERALIAS.PAY_END_DATE) Where INNERALIAS.PAY_END_DATE < AL_CHK_DATA.PAY_END_DATE)
You will need to write some SQL by hand to do this. Here is an example of a report with a Select in a Derived Field.
Then you could use the Derived Field in your Selections.
[!]This is where most people would hire an expert.[/!]
Specializing in ReportSmith Training and Consulting
You will need to write some SQL by hand to do this. Here is an example of a report with a Select in a Derived Field.
Then you could use the Derived Field in your Selections.
[!]This is where most people would hire an expert.[/!]
Specializing in ReportSmith Training and Consulting
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question