difference between the two statement?

Question

User1977787504 posted

What is the difference between the two statement

First(Fields!customerloannumber.Value, "spReport_LoanSummaryBatch_edit") and Fields!customerloannumber.Value

Answer 1

User-1528094326 posted

First(Fields!customerloannumber.Value, "spReport_LoanSummaryBatch_edit")

This is taking the very first value returned by the spReport_LoanSummaryBatch_edit dataset assuming there are multiple values available, and it will populate it to the spot on the report you have it placed.

Fields!customerloannumber.Value

This is just going to try and populate the customerloannumber data supplied from ANY dataset tied to the page that contains it. It will populate based on the control type as well. If that is inside a regular textbox then it will populate the first value as well automatically. If its inside of a Tablix or List control then it will auto populate the list supplied to the dataset in that control.

Answer 2

User559774174 posted

First(Fields!customerloannumber.Value, "spReport_LoanSummaryBatch_edit") returns first row value of mentioned column of entire dataset

while Fields!customerloannumber.Value is used in data repeating controls in details section of report so it returns value of mentioned column sequential order