String Concatenation

  • Hi,

    I have an expression in my text field as:

    =First(Fields!FirstNameEnglish.Value, "Members_DS") & " " & First(Fields!LastNameEnglish.Value, "Members_DS")

    in which "Members_DS" is a dataset.

    when I build my report I get following error message:

    Aggregate functions cannot be used in data set filters or data region filters.

    The filter which I've set in "Members_DS" is: =First(Fields!PersonnelCode.Value, "shared_DS")

    Could I know where I'm wrong?:unsure:

  • Hi,

    what is your dataset for the table? Member...ya..Shared..??

  • Try using:

    =(Fields!PersonnelCode.Value)

  • Thanks for replies

    my problem is solved. That was due to a mistake in creating data set I removed it and created again and it resolved 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply