Another manual cross tab

[DozAdmin]

Sorry for duplication, searched through other cross tab questions but didn't get me there.

I need to create a manual cross tab report CR 2008. The report is to show investment_model allocation percentages of employee, by fund. If I didn't need cross tab it would be simple group ss#, group fundid, group investment model then the %. Don't know how to make this work in columns.

Personname
fields FundID Fundname Model1name model2name
data sampleid samplename 10% 7%

Hope I'm giving enough info for help.

 

[dhookom]

If the model names will be dynamic, you need a method for aliasing them to constants for your report. There is a solution at Cross Tab Report

Duane
Hook'D on Access
MS Access MVP