We are creating PDF reports for our customers using Excel templates. Now I am experiencing a problem when grouping the output. The output should be grouped on 10 columns, but the grouped row only shows two of these columns.
The desired output should be
1. Grouping row containing two columns
2. Grouping row containing ten columns
3. A "normal" data row.
I attach the code that is used to create the PDF document as well as the desired and the actual output. The desired output is generated by loading the XML data into a Excel file, converting it to a plain XSL-file and generating the data from the template and the data xsl file - the grouping works as expected then. When using the typed data in the format IEnumerable, some of the grouping columns are skipped.
Could you please help?