I was wondering if anyone could give me some insight on the creation of a report. I have created a BAQ that displays The employees name, pay rate, and pay rate date. What I need to do is create a report that only displays the most recent rate and date with the name. Since most employees have had numerous pay increases, the BAQ has a list of pay rates and effective dates for each employee. I can’t seem to figure out how to only display either in the BAQ or in a report the most recent only.
Any ideas?
aidacra
(Nathan your friendly neighborhood Support Engineer)
2
in the BAQ, if you select the top 1 row of the table for an employee, and then order by the ratedate desc you should get the latest payrate.
How I did it in SSMS (not sure this is the correct table, but the process would be the same.) Top 1 row, order by the date field desc.
I’m not quite sure how to do that in a BAQ. I’ve not seen a screen like that before. I currently have the PREmpmas and Premprt tables linked by the company and emplink fields.
