Sorting & Grouping ... Change column (field) Titles

[BobC]

I will have 8 different main groups in my report.
I want to change the Text Box contents (Column Titles)as a function of
the Grouping. Thus I want to have 8 different sets of column titles
(consisting of approximately 12 columns)
Recommendations on how to set this up please?
Bob

 

[Duane Hookom]

Are you suggesting the column titles will depend on a value in your grouping
level? If so, I would create a column titles table with the "grouping" value
and "approximately 12 columns"/fields to store the titles. You could then
link this table into your report's record source and replace the column title
labels with bound text boxes.