Sorting on calculated ReportItems columns

Hi,

I need to sort my tablix report where I have several calculated columns like:

=ReportItems!Textbox47.value+ReportItems!Textbox48.value

Now I would like to sort these by using the Interactive sort functions - but I have seen elsewhere that this is not possible..(I'm also getting an error when trying..)

Is there not a way that I can bypass this (using Code function or similar) ?

The datasource for the data is a OLAP cube

June 21st, 2015 6:22pm

Hi,

I checked your requirment, I am also getting error.

In fact I have written function to add values but when passing values to that function using ReportItem key word in Sort expression, it again throws error, reportItems cant be used in sort.

My suggestion would be to create caculated column in MDX query where it will sumup the vaules of different Measures selected for reports.

That calculated column can directly used in the sort expression.

Thanks

Prasad

Free Windows Admin Tool Kit Click here and download it now
June 23rd, 2015 1:26am

Can you try creating a variable in your scope with calculation and then try sorting with it?

https://msdn.microsoft.com/en-us/library/dd255208.aspx

June 23rd, 2015 1:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics