locked
difference between the two statement? RRS feed

  • Question

  • User1977787504 posted

    What is the difference between the two statement

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


    Tuesday, November 13, 2012 11:06 AM

Answers

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, November 13, 2012 4:22 PM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 14, 2012 4:50 AM

All replies

  • 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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, November 13, 2012 4:22 PM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 14, 2012 4:50 AM