Hi, we're using ArcMap 10.5 to design some report for our client and facing really poor performance.
We're trying to do a real simple report on 1 table.
Seing this i've runned a direct query on the database to obtain the same information and i did the same in excel via a database link.
The SQL query i used to get the informations :
select distinct(territoire), statutInspectionFinal, count(*)
group by territoire, statutInspectionFinal
order by territoire, statutInspectionFinal
I've read all documentations available and it seams there is no way to pass a real sql query to the report builder (U can only add expression to the select * query that is generated by the report builder)
Every Comments would be much appraciated.
regarding arcmap performance:
In the past, I Took some suggestions from the Github article to make ArcMap faster By Kevin Godsey