Can you use information obtained in the report to use as output?

[Former Member]

I am wondering if in XI R2 or 2008 you can use infomation obtained in the report generation to use in output parameters? For example, if my results come back with email addresses, can I then use them to email to?

[Former Member · Accepted solution]

There are several export options. But how about this solution:

Insert a text object on the detail line with the text "E-mail: ". Then drag the data field of the company/person's name and drop it in the text at the end.

Then, right-click the text, and select "Format Text...". Then click the Hyperlink tab and select "An EMail Address". Below, for the e-mail address, it says "mailto:" but you don't want a static address. So click on the formula button on the right. For the formula, enter "mailto:" +

When you run the report, you'll see "E-Mail: John Doe" but when you click on it, it'll open a mail message window with the address as the recipient. (The names of the victims in this example have been changed, to protect the innocent )

I'm sure there are several other ways to accomplish your goal, but without more info on your situation, I can only guess that this is the best one.