Friday, 24 June 2016

SSRS sorting in report level

Sub report
 master child relationship –

SSRS reports would have 2 tablix and the sorting would be at report level. I,e if Tablix 1 generated 3,4 as data and yablix 2 generated 1,2 as data SSRS report would show 1,2,3,4 as output. On analyzing this functionality was achieved by using the Maser child relationship I,e Subreport concept in SSRS. The main report will have a list of Sl No that has to be in order and the subreport will generate result for every single Sl No. However this reduced the speed of the generating the report. Client was okay with the speed and hence nothing much could be done.

No comments:

Post a Comment