If you have a SQL database, you can use RDS to call a SQL procedure to build your cross-tab, and save it into an RDS data set, which you can then easily format to match your needs.

It's also possible with the embedded DB but its harder and slower.