Tuesday, November 25, 2014

SSRS - Dynamic ordering the fields based on the Customer

excel input? You mean based on order in which columns are arranged in excel?


If you want to cater to such a requirement, you need to maintain a position attribute against columns in the db based on the order in Excel (this needs to be populated using your ETL process from excel -> SQLServer).


Then this can be utilized for sorting inside SSRS matrix in column group to generate the columns in the same order.




Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page


No comments:

Post a Comment