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