After reading the subject of this post, i think you got a picture of what i am going to do.
I have a report and one of the column is Planner. It displays the name and that name should be hyperlinked and when i click that, outlook mail should open and this Planner name should be in "To" list.
I did it using "MailTo:"
Now the added requirement is, after clicking name in report, outlook mail should open with Subject and the data should be in the body of the email. After some research, i did it with below code.
="MailTo:" & Fields!Email.Value & "?Subject=The SKU and Market " & "&Body=Hello Team, " & VBCRLF & VBCRLF & "SKU: " & Fields!sku.Value & VBCRLF & "Country: " & Fields!countryname.Value & VBCRLF & Blah Blah Blah..
The problem is, in the above code if i add up to 8 columns, then the hyperlink is working. If i add 1 more column (more than 8) and deploy the report and when i click the hyperlinked name, outlook doesn't open. I can see processing symbol on the report tab revolving for more than 15 min and i would stop the processing. If i modify the expression to 8 columns and deploy the report, hyperlink will open the outlook with data. More than 8, it dies.
Is there any specific reason for this. Is there any conditions or anything i am missing. Do we have any limit for Fields or Parameters in the expression. Please let me know.