Construct String or use STRTOX
Hi ,
Is it Good to Construct a MDX String or Use strtoX(@Param) in your Reports for better Performance and Caching?Rakesh M J
May 25th, 2011 2:47am
Hi Rakesh,
Its a good practice to make all the conversion in code and then just displaying them in the report. However on saying this there is no supportive documents that says you need to do it in code or in the report.
Since SSRS reads the data from the dataset it is always good to have the data converted.
HTH,
RamRam
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 8:07am