twincalicos
MIS
When attempting to link tables in the ADP company level jobcode table to the employee job table via jobcode by "edit(ing) the SQL" query in the report. When we added our linking to the from clause of the query, as you can do in true SQL (client and I are SQL people, not Oracle), it failed with an invalid field name msg.
Another time, we got a msg that the query was not properly ended.
I know the ADP system they have is actually Oracle based (via web access), but Report Smith uses SQL as its terminology on the buttons. Perhaps there is an Oracle format to the query that we were missing?
I think we had also tried to link in the where clause and had an issue there too.
Additionally, is there a cosmetic place to link tables in Report Smith (not in the query itself) whereby it will link them for you so you do not have to always edit the query?
Another time, we got a msg that the query was not properly ended.
I know the ADP system they have is actually Oracle based (via web access), but Report Smith uses SQL as its terminology on the buttons. Perhaps there is an Oracle format to the query that we were missing?
I think we had also tried to link in the where clause and had an issue there too.
Additionally, is there a cosmetic place to link tables in Report Smith (not in the query itself) whereby it will link them for you so you do not have to always edit the query?