SQL query and reports

[Fandango]

You can use a matrix and put the AuditTypeID in the column group field, this would in give you a dynamic number of columns based on the distinct number of AuditTypeIDs you have across the rows. Effectively a Pivot table.

This vid demonstrates it in SSRS so should be applicable in RB3 although he parameterises which columns he wants to use but should give you the idea

The only caveat though is I'm pretty sure you would get a column for every AuditTypeID that appears in your dataset, and that would be applied across all your rows(invoices) regardless of whether each row has a values for each audittypeid

https://youtu.be/vgtVJf21EXU


the other option is to flatten the rows in the SQL statement and concatenate the AuditTypeID into a single string

http://www.sqlmatters.com/Articles/C...%20string.aspx

[Drkarnivore]

Late to the party.

If you are sans reporting tool, many databases have a PIVOT / UNPIVOT function for dealing with such problems in SQL.