Variable Field on RS
Hello! Is there any way to writte an expression as this on RS 2008 R2: =Fields!(Fields!FieldName.Value).Value Where Fields!FieldName.Value is the Name of the Field which contains the actual value I want to display. Thank you!
October 4th, 2011 6:47pm

Hi DataAnalyst, It is not clear what you are trying to achieve because in SSRS we filter a dataset using a report parameter. You could try using Lookup - http://msdn.microsoft.com/en-us/library/ee210531.aspx or using .NET aasemblies for your expression.Sergei
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2011 6:22am

Hi Sergei, Thanks for your reply... What I was trying to Achieve is: I stored the field name on a table and when I retrieved those fieldnames from that table I wanted to display those FieldNames Values on a Dynamic Tablix. I worked it out like this: =Fields(Fields!FieldName).Value eg: =Fields!FieldNameRetrievedFromDB.Value I just had to remove the sign ! Thank you, will research lookup, seems to be a useful function... CheersElias
October 5th, 2011 6:29am

you may have to write your own function to achieve this functionality.stong
Free Windows Admin Tool Kit Click here and download it now
October 5th, 2011 11:49am

Hi Sergei, Thanks for your reply... What I was trying to Achieve is: I stored the field name on a table and when I retrieved those fieldnames from that table I wanted to display those FieldNames Values on a Dynamic Tablix. I worked it out like this: =Fields(Fields!FieldName).Value eg: =Fields!FieldNameRetrievedFromDB.Value I just had to remove the sign ! Thank you, will research lookup, seems to be a useful function... CheersElias
October 5th, 2011 1:23pm

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

Other recent topics Other recent topics