SQLTeam.com | Weblogs | Forums

List all records in Actions url that sends an email


I am trying to show all rows not just the first in an email url thru the Actions of an SSRS. Do you know of a way? Its the last field in this code that will show first or last, but not each row. First(Fields!txt1.Value, “TimeHeldEmail”)

=”MailTo:mgallott@wn.com” & “?Subject=My Held Time ” & “&Body=Hello Team, ” & VBCRLF & VBCRLF & “SKU: “& First(Fields!employee_code.Value, “TimeHeldEmail”) & VBCRLF & “Country: ” & First(Fields!txt1.Value, “TimeHeldEmail”)