One of the reports I am creating has dynamic number of columns - a datatable gets returned from the stored procedure, the number of columns depend on the number of items defined in the database (one column for each item, other than some fixed columns).
Is it possible for me to use RDLC report to generate a report in this case? All the calculations are already done int he report, I am looking at RDLC only for the sake of export to excel/pdf and repeating header/footer.
It is possible, but there is no simple solution. Here is a link to a former answer of mine on this topic.
An additional investigation later
Here is an article describing the mentioned report generation with a self generated RDL object model in detail.