locked
Dynamic Report Columns RRS feed

  • Question

  • I have a crosstab query with fixed columns, but want one with varying number of columns based on choices the user make in a multi-selectable field (new in Access 2010).  I want the report to use the choices the user made as the column headers, instead of the crosstab query using all possible user choices, resulting in empty columns.  I have 5 columns that will always be used, and 3 other columns where at least one will be used, but could be 2 or 3 of them.  Hope this makes sense.
    Tuesday, December 15, 2015 4:30 PM

Answers

  • Hi RobDerosier,

    Could you please tell me in what way did you use to obtain these data?  If you use ado.net,  please try to traverse the datatable. If the column is empty, remove the column.

    Best Regards,

    • Proposed as answer by Fred Bao Tuesday, December 22, 2015 2:51 AM
    • Edited by Fred Bao Tuesday, December 22, 2015 9:46 AM
    • Unproposed as answer by Fred Bao Friday, December 25, 2015 5:37 AM
    • Proposed as answer by Fred Bao Monday, December 28, 2015 7:24 AM
    • Marked as answer by Fred Bao Monday, January 11, 2016 5:32 AM
    Wednesday, December 16, 2015 2:54 AM