Forum Discussion
Solved
Displaying multiple reports on one screen
I have 3 reports which use direct query to get data from 3 different databases. I want to see all 3 reports on the same page so we can compare the results from the 3 databases. This is easy if I...
The reality is I started from scratch and resolved this myself by adding the SQL query at the beginning when creating the connection to reduce the data set being imported.
I don't get an option to amend the query when importing the data so it always tries to import everything and then do the necessary filtering of the data for the report unless I do a direct query.
The reality is that this needs to be almost a real time report so we can see that our orders are being passed across the 3 databases that they need to be fed into.
The reality is I started from scratch and resolved this myself by adding the SQL query at the beginning when creating the connection to reduce the data set being imported.