Stránka 11

Report with a temporary table

PříspěvekNapsal: ned 06. pro 2015 11:20:22
od andesys
(Translated from another language)
We need to do a complex report with several tables. At this moment we use a stored procedure for that where we create a temporary table which we fill in several steps. Is it also possible in ObjectGears?

Re: Report with a temporary table

PříspěvekNapsal: ned 06. pro 2015 11:21:08
od andesys
You can use whatever SQL Server possibilities for SELECT statement in the query or you can call a stored procedure. You can find more information here
http://doc.objectgears.cz/Help.aspx?H=a_data_query_sp