cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
myousufhk
Engaged Sweeper
Dear Support,

I'm facing difficulties in creating custom report because there are SQL table and views to add and I'm not very good in SQL. Is there any guide on how to create a custom report?
2 REPLIES 2
Esben_D
Lansweeper Employee
Lansweeper Employee
Lansweeper reports are made in a standard SQL editor. We don't have any SQL tutorials.

Since there are many free online courses which teach the basics of SQL we generally advice people interested in custom reports to try those.

https://www.codecademy.com/learn/learn-sql
https://www.w3schools.com/sql/

Additionally, you can find all our built-in reports and some community reports in the Reports Center here on the forum. You can use those as a starting point or inspiration for your own reports.

You can also use our database dictionary to find what is stored in the database tables if you are looking for specific information.

Lastly, you can also ask for helps with reports you are building in this forum category.
bfreemannh
Engaged Sweeper
I am interested as well.