Hi all,
I am working on a couple of matrix reports for an asp.net web app using ssrs report viewer.
I would like some advice on best practises for loading the data for the report. ie. is there a preferred structure or order to return the data in which would help performance ? can I take advantage of tsql pivot to help improve efficiency ? or any other general information on the best way of providing data to a matrix report.
cheers,
russ