run report not linked to feature

Permanently deleted user

July 17, 2018 00:23

I am trying to create a workflow that opens a report that is NOT linked to any feature. I have the report configured and populated with a SQL command (I can print the full report through Report Designer), and just need to be able to open the report in a viewer. Does anyone have any ideas on executing this seemingly simple task?

0

• 

  Berend Veldkamp

  July 17, 2018 07:41

  The usual way is:

  1. Use Create Temp File to store the bytes resulting from the Template Report as a temporary file, this will give you a 'partial url'
  2. Use Get Request Info to get the Application URI
  3. Use Display Hyperlink to show the full url, e.g. requestInfo.ApplicationUri & "/" & partialUrl

  0
• 

  Permanently deleted user

  July 17, 2018 14:56

  What sort of parameters would need to be passed in to each activity? Would I need to create variables, or call specifics?

  0
• 

  Permanently deleted user

  October 29, 2018 23:49

  Hi Benjamin,

   

  The ability to assign a data source within Report Designer is an unfortunate extra feature for Essentials.  While you can do it, and the Designer will let you print/export with that data, Essentials will remove the data connection and replace it with a new DataSet when you run the report (either from a layer or from workflow)

   

  The best solution is to move the data connection / query from your report and do that in Workflow using the SQL Query activity.  The resulting DataTable can be added to a DataSet and then you can use the Template Report activity (in Common Server) to get a byte array representing your report.

   

  You'll need a variable for each of the outputs from the SqlQuery, AddToDataSet, and TemplateReport activities, plus some means of getting the URL from CreateTempFile.

   

  Regards,

   

  -Malcolm

  0

Please sign in to leave a comment.