Attach PDF Reports


If you have the OnyakTech PDF Reports module installed and on a page, you can attach one or more of the reports to your Axon Campaigns. The PDF files are generated at the time the campaign executes and you can use the following tags in your reports SQL Statements to personalize the report specific to the recipient .

The following additional tags can be added to your campaign body to provide more personalized emails.

  • [USR-USERID] - If the recipient is a registered user in your DNN portal, this will display the users User ID

  • [USR-USERNAME] - If the recipient is a registered user in your DNN portal, this will display the users user name

  • [USR-FULLNAME] - If the recipient is a registered user in your DNN portal, this will display the users display name

  • [USR-AFFILIATEID] - If the recipient is a registered user in your DNN portal, this will display the users affiliate id

  • [USR-PASSWORD] - If the recipient is a registered user in your DNN portal, this will display the users password


The following tags will display for all recipients even if they are not registered on your site

  • [USR-EMAIL] - If the recipient is a registered user in your DNN portal, this will display the users email address

  • [USR-LASTNAME] - If the recipient is a registered user in your DNN portal, this will display the users last name

  • [USR-FIRSTNAME] - If the recipient is a registered user in your DNN portal, this will display the users first name


Quick Sample


To see this in action, follow the steps below to attach a PDF file listing all of the registered users in your portal
  1. In the OnyakTech PDF Report module, click the icon to create a new report
  2. Name the report User List and click the link to create the report.
  3. Select "SQL" from the Report Item Type
  4. In the Item Script type "Select * From Users"
  5. For the Item Title, type "Portal Users"
  6. Click the "Add Report Item" link

 

 

Now we need to add the report you just created to your Axon Campaign. 

  1. Open the campaign in Axon
  2. Click on the PDF Reports menu option (this is only visible if you have the OnyakTech PDF Reports module installed and on a page.  It doesn't matter what page the module is on)
  3. Select the "User List" report from the PDF Reports list.
  4. Click "Attach Report"