Pivot: Crosstab / Matrix in a Report (static) using the web based report designer
This idea is for the ability to have a static "crosstab" or "matrix" layout in a report. Note there is a separate idea for interactive pivoting at http://community.activereportsserver.com/forums/115455-discussion-forum/suggestions/2853169-pivot-interactive-pivot-table
Thanks for the question. I'll try to clarify. For the crosstab/matrix control inside of a report (described in this idea), it will be a special table that could have columns based on data. For example, you could make "Task Type" a "column" and the various task types ("Revision", etc.) will expand horizontally as columns; One column for each task type in the database.
In your example, if "Bob" didn't receive any tasks, he will still show up as a row unless you apply a filter to remove recipients with zero tasks. Same with tasks types: Even if a particular task type (e.g. "Revision") has no recipients, it would appear as a column, unless you apply a filter to remove those task types that have no recipients.
Since you can use Prompts/parameters in filters, you could also make those recipient rows task type columns dynamic at runtime too.
Can you clarify this idea? Would rows and columns both be dynamic at run-time? Or would they be chosen when the report is built so that non-results show up as zeros/blanks on the report?
That is, let's say I'm running a report with task type as the column headers and task recipients as the rows, and I want the cells to show a count. If Bob didn't receive any tasks, will he still show up as a row? If the Revision task type was not used, does it still show up as a column?