Create a table with a header using column data

[Kay327]

I need to create multiple tables with headers based on the data in the columns of the table. I tried using the cross-tab tool but it was not giving me the output I desired. My data set looks like this: 

I need a table with a header on separate pages for each code in the table.

Thank you.

[apathetichell · Accepted solution]

I don't think you need to use the crosstab tool - you need to use the table tool grouped on CODE (the fields you don't want displayed  will be dropped from the report - you'll rejoin them later.

Here's what I would do next:

rejoin the data to the table/group records based upon code.

add a report text tool.

attach text to existing field

place text above existing object

and then use the date and group fields in your description. note - you probably want to use a summarize or filter prior to your join so you are only bringing in one entry per group and you don't end up with a ton of reports.

[Qiu · Accepted solution]

@Kay327 
We can use the option in the output tool.