Report Builder issues

[Facilities]

Hi

I'm running report builder version 3.5.1.2.
I have two separate installs of Lansweeper on 2 different networks. They are separated by geographic location so scanning from server isn't an option.

Now i want to have the same reports on both servers so I can generate the reports.

If I copy the SQL query from the report builder and copy it into the report builder of the other server the report will save. When i run the report i don't get any data back.

Here is a simple example.

SELECT DISTINCT
tblADusers.Displayname,
tblADusers.Department,
tblADusers.Title,
tblADusers.Company,
tblADusers.email
FROM
tblADusers
WHERE
tblADusers.Title LIKE '%developer%'

Even if I just change one value like "tblADusers.Title LIKE '%developer%'" to "tblADusers.Title LIKE '%analyst%' (on the SQL tab) and use it in a new report on the same server the report doesn't generate any data. If I create the report manually using the builder tab it runs and returns data.

Now it's easy for a quick simple report but redoing some of the other reports which have taken some time to get right manually isn't an option.

Any idea or help as to why the queries don't return any data when you manually edit or create the report in the SQL tab?
Any ideas as to how I can get the reports from one server to the other?

Regards
Nick

[Hemoco]

There is a known bug (which will be fixed soon)

Temporary solution:
After pasting the SQL code, switch tabs to the visual builder, then run the report.