CoreBOSBB
help with report sql - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: Administrator Support (https://discussions.corebos.org/forumdisplay.php?fid=8)
+--- Thread: help with report sql (/showthread.php?tid=1691)

Pages: 1 2


RE: help with report sql - joebordes - 02-02-2020

yes, you should be able to match the records on smownerid (assigned_to), if that makes sense to your business logic


RE: help with report sql - rslemer - 02-03-2020

it is not frequent ...
of these intermittent errors ...

={

I'll be attention for get any more information

thanks for your reply


RE: help with report sql - rslemer - 03-03-2020

How I can formatted ( put milhar separator ) in sql report?

There another strange situation, at first time, I execute my sql report, system not uses filter condition, but when I clicked button "generate now" reports works right


RE: help with report sql - joebordes - 03-03-2020

the application can't format that number because it doesn't know that it is a currency number, that "field" doesn't exist in the application as it is a custom SQL report. You will have to format it in MySQL