Display Vlaue

Hi I am reporting off a dataset and I want to have a Display Value witch is the code rather then having the value witch is a Id is it possible?

All fields returned in your query should be available in design mode. If not then you may need to click the refresh button on the data tab for Visual Studio to re-create your dataset filed definitions. To access fileds from your dataset just use the following expression template:

= Fields!<<column_name>>.Value

When grouping of when you want to reference a filed outside of the context of a containing control e.g. matrix , table, list, then you have to use an aggregation function e.g. Sum, Avg, Max, Min, First, Last, and pass the dataset name as a scope e.g.

= First(Fields!<<column_name>>.Value, "<<dataset_name>>")

|||

Hi Adam

Thank you for replying but what I mean is having the actual column should be the ID but the display should be the Description or the code from a other dataset and I can’t use a join because I have the data in memory of my dataset

|||You need to do the join in your query and bring back an extra column (the description) in the same dataset as the ID. Use SQL for joins and use RS for presentation. RS has no capability for joining disperate datasets - not that I know of anyway.