Saturday 12 May 2012

About DataSet in SSRS

DataSet:

Note:

        your datasource can be stored procedure or table etc. Anyway your result will be a dataset only.
you can see the list of dataset column names(First value of each column. 


Ex:=First(Fields!ColumnName.Value, "DataSetName")) in Expression window.



To Find a last value of dataset, 

Ex: Last(Fields!ColumnName.Value, "DataSetName")

Note:
        If you used(=First(Fields!ColumnName.Value, "DataSetName"))  this in table,the same value(first value) will repeated. For  Example, if dataset contains 100 recordes, it will repeat for 100 times. Because it pointing the first value position of dataset.





    

No comments:

Post a Comment