How to add object hyperlinks to your exported list reports

Purpose

When running list reports in the iGrafx Design web application, each object in the results will contain a hyperlink that can be clicked to navigate to the object in your browser. When exporting report results to Excel, this link is not available by default.

You can add a hyperlink column to your exported reports by following this guide.

Step-by-step guide

1. Generate your list report definition and run your report
2. Click DOWNLOAD  to get your .xlsx  result file
3. Open the file in Excel
4. Find the column that contains the object ID (commonly column A ) and the column that contains the object name (commonly column B )
5. Navigate to an object in your Design application's model area in the repository that your report was run in. The URL will be similar to this example
   
   https://sample-customer.igrafxcloud.com/Process/repoName/obj/123 
6. Add a new column to your Excel sheet, where you want the hyperlink to be available and give it a header text like "Web link"
7. Add one of the following formulas to the first data row of the column
   

   1. If you want the URL itself to be displayed as content of the column
      

      CODE

      =HYPERLINK("https://sample-customer.igrafxcloud.com/Process/repoName/obj/" & A2)

      with A2 being the cell that contains the object ID of your first result row.
      Use the URL (without the number at the end) from step 5 for the first text in the function.
      
      OR
      
      

   2. If you want the name of the object to be displayed as the content of the column
      
      

      CODE

      =HYPERLINK("https://sample-customer.igrafxcloud.com/Process/repoName/obj/" & A2, A3)

      with A2 being the cell that contains the object ID of your first result row and A3 being the cell that contains the object name of your first result row.
      Use the URL (without the number at the end) from step 5 for the first text in the function.

8. Now fill the formula down until the end of your report data to add the link to every row

Related articles