Creating reports and dashboards | Stimulsoft community forum

Code: Select all

SELECT TOP(40000) FORMAT(ROUND(a.column1 - a.column2 - a.column3, 3), 'N3')AS [Column 1],
	   FORMAT(ROUND(a.column4, 3), 'N3') AS [Column 2], 
	   FORMAT(ROUND(a.column5, 3), 'N3') AS [Column 3], 
	   FORMAT(ROUND(a.column6, 3), 'N3') AS [Column 4],
	   a.column7 AS [Column 5],
	   b.column8 AS [Column 6],
	   c.column9 AS [Column 7],
	   c.column10 AS [Column 8],
	   d.column11 AS [Column 9],
	   e.column12 AS [Column 10],
	   f.column13 AS [Column 11],
	   h.column14 AS [Column 12],
	   i.column15 AS [Column 13],
	   g.column16 AS [Column 14],
	   g.column17 AS [Column 15]
	   FROM table_a AS a
LEFT JOIN table_b AS b
	   ON a.column_a = b.column_a
LEFT JOIN table_c AS c
	   ON a.column_a = c.column_a
LEFT JOIN table_d AS d
	   ON c.column_a = d.column_a
LEFT JOIN table_e AS e
	   ON c.column_a = e.column_a
LEFT JOIN table_f AS f
	   ON a.column_a = f.column_a
LEFT JOIN table_g AS g
	   ON a.column_a = g.column_a
	   AND a.column_b = g.column_b
LEFT JOIN table_h AS h
	   ON g.column_a = h.column_a
LEFT JOIN table_i AS i
	   ON g.column_a = i.column_a