SQLViewPro Tokens

What are tokens?

SQLView Pro Specific Tokens

• [REPORTNAME]
  • inserts the name of the current report
• [REPORTTYPE]
  • inserts the simple type of the current report (ie. FUSIONCHART)
  • all report types can be found in the table, DNNStuff_SqlViewPro_ReportType
• [REPORTTYPENAME]
  • inserts the friendly type name of the current report (ie. Chart (Fusion))
  • all report types can be found in the table, DNNStuff_SqlViewPro_ReportType
• [PAGEURL]
  • inserts the full url to the current page.
• [FULLSCREENURL]
  • inserts the full url to the current report without the chrome (same as the full screen view of a report), useful for passing the url to a printing app etc.
• [PARAMETER:ParameterName]
  • inserts the value of the parameter, where the name of the parameter is ParameterName
• [QUERYSTRING:KeyName] or [QS:keyname]
  • inserts the value of the querystring parameter, where the name of the querystring key is KeyName
• [SERVERVAR:KeyName] or [SV:keyname]
  • inserts the value of the server variable, where the name of the server variable key is KeyName

Tokens specific to SQLView Pro Parameter Layouts

• [ParameterName]
  • inserts the full parameter caption and prompt for the parameter named ParameterName
• [ParameterName_Prompt]
  • inserts the parameter prompt for the parameter named ParameterName
• [ParameterName_Caption]
  • inserts the parameter caption for the parameter named ParameterName