Is there anyway in BO to use the same query to produce the same report on a regular basis, but using different tables/data each time? i.e. without having to produce the query each time.
OK........basically I will be running a report schedule every week using the same queries and the same tables each time........i really want to know if there is a way of saving queries within BO so all I need to do is alter them when required.
Are you doing a Free Hand SQL report??? Also there is an edit SQL option in the QP. I don't know any way of storing the SQL within BO but all BO reports have an associated SQL which you can see through that option. When required you can modify that or add or delete objects in QP the SQL will be regenerated.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.