Can someone point me in the right direction or tell me how to use a query in a report that resides in a different report? I remember doing this way back when during training classes but can't for the life of me remember the details on how to do it.
Thanks so much
hi,
may i ask what exactly your goal is? do you want to connect different reports, relate them, calculate and receive new information?
as far as i understand queries, there are just a declared "question" to the data base to receive special information, therefore you might copy paste queries and might modifiy them for your need. please give a further instruction into what you are going to do, maybe i will be able to help.
cheerz :P
I am creating an Ops Scorecard. I have about 8 different reports that supply parts of the data needed. There are a couple reports that I need the final query which consists of more than 10 other queries. Rather than copying all those queries to the new report I'd just like to link/reference the query from the original report.
Can't be done in Report Studio. You can use a layout component reference to reference objects in other reports, but not queries or data items.
What you could do to make the queries re-usable is to move them to the model. The proper way would be to model the logic from that query in one query subject. The quick and dirty way would be to take the generated sql from the query and copy that into the sql tab on a data source query subject.