I have worked hard and finally gotten my dynamic crosstab report working. Now I would like to add data from a different record source.
The crosstab report has dppm by model & category and month. I need to add a input qty as another row, but it I can't put that in my crosstab query or it will create too many categories and mess up the look of the report. If I made another crosstab query with the same months and used the input qty instead, how could I add that information to my report?