Add custom fields to "Report" tab

[rafaelsds]

In my company we use the Custom fields to store information about server functions. For example, File server, Domain Controller, ERP Server. We define that info on "Funções" field.

The information appears on "Summary", but when we generate the Report it doesn't. Is there a way to include the Custom Fields?

[rafaelsds]

Too bad, it would be an awesome feature... Thank you for the Quick Support!

[Susan_A · Accepted solution]

The Report tab of individual computer webpages cannot be customized. I recommend building a custom SQL report under Reports\Create New Report that lists the information you are after. Custom field data is stored in the tblAssetCustom database table. Keep in mind that:

• The custom fields will still have their original names within the Lansweeper database. You can assign aliases to the fields to rename them within your report.
  
• You won't be able to include all of the same information as in the Report tab. The Report tab is a special page that combines information from several unrelated database tables. Including all of this information in a single SQL report would lead to duplication.

If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, more information on which can be found here. The dictionary explains in great detail what each table and field stores.