Total Rewards Statement?

We created our own Total Rewards Statement. Years ago we paid an outside vendor to do it for us and then we stopped doing anything for a few years. A couple years ago we had small project team organized to see if it was possible to do in house. We looked at other examples and came up with ideas. I created a few crystal reports as examples and finally landed on a final version. I don't recall how long it took but it was received well. We created a yearly and bi-weekly statement. I am bursting by userid in the report and created a bookmark within ESS to link to the bursted pdf. The biggest roadblocks were on the technical side. The report is built with sql and some codes hardcoded so when changes are made to plans or codes, we have to review the reports to make sure they are still working. I would add that your employee's will analyze the statement so make sure it's accurate and correctly identifies employee vs employer contributions .

Hi Greg, thanks for your input. Do you happen to have a template of a Crystal Report you can share, or perhaps a screenshot of what your final output looks like (with actual data hidden of course .

I'd likely be the Analyst that puts the statement together, and trying to get a feel for what tables are used. Just trying to get the creative wheels turning. Thanks!