SQL Builder - Fast Reports ?

Questions related to using nuBuilder Forte.

SQL Builder - Fast Reports ?

Postby n9yty » Sun Oct 18, 2020 9:58 am

I build a query in the SQL Builder, although I see no way to run/test it to know if it is working.

I went to build a Fast Report, and picked this SQL from the list, but it doesn't populate the fields for the report. If I select a table it does populate them. The SQL is manual, is that the problem?

Also, does not work with a query build using the GUI.
n9yty
 
Posts: 38
Joined: Fri Oct 16, 2020 4:13 am

Re: SQL Builder - Fast Reports ?

Postby n9yty » Sun Oct 18, 2020 10:13 am

RESOLVED:

My mistake, these were tables brought in from another system, including some views and the definer did not have access to the nubuilder database. I resolved it and now the fields show up in the Fast Report.
n9yty
 
Posts: 38
Joined: Fri Oct 16, 2020 4:13 am

Re: SQL Builder - Fast Reports ?

Postby admin » Mon Oct 19, 2020 8:37 am

.
admin
Site Admin
 
Posts: 3372
Joined: Mon Jun 15, 2009 9:53 am


Return to General