kojak43
Active Member
- Joined
- Feb 23, 2002
- Messages
- 270
I have a job task list. There is a field for Category, Client, Job Number, Job Description, due date and status.
I want to produce a report that shows each Category all by itself (like a one row "header" as wide as the number of columns) Then each client listed under that, by job number, description, due date and status.
If I wanted to see just a particular client, I would filter, within the pivot table, for just that specific client.
But the pivot table "Data area" looks for a count or a sum or something that shows a number within the report table.
I just want a report showing a row "header" of category, and a line by line data of the other data.
Is a Pivot Table the wrong tool? If so, what is the better way to accomplish this report?
I want to produce a report that shows each Category all by itself (like a one row "header" as wide as the number of columns) Then each client listed under that, by job number, description, due date and status.
If I wanted to see just a particular client, I would filter, within the pivot table, for just that specific client.
But the pivot table "Data area" looks for a count or a sum or something that shows a number within the report table.
I just want a report showing a row "header" of category, and a line by line data of the other data.
Is a Pivot Table the wrong tool? If so, what is the better way to accomplish this report?