I have a report that uses 3 different manual SQL queries, all of which include Location - Region. I am bursting to our Sharepoint site, which has a folder for each region. This is working... each folder receives it's own bursted report. (This bursts into Excel and each SQL Query has it's own worksheet/tab)
What is not working is 2 of the three queries are not filtering to it's specified Region. The Burst Key is in one of the queries, and that tab is bursting with the appropriate region data. The other Excel worksheets include information for ALL regions.
Any help would be appreciated. :)
Quote from: Londa on 06 Apr 2016 12:33:26 PM
I have a report that uses 3 different manual SQL queries, all of which include Location - Region. I am bursting to our Sharepoint site, which has a folder for each region. This is working... each folder receives it's own bursted report. (This bursts into Excel and each SQL Query has it's own worksheet/tab)
What is not working is 2 of the three queries are not filtering to it's specified Region. The Burst Key is in one of the queries, and that tab is bursting with the appropriate region data. The other Excel worksheets include information for ALL regions.
Any help would be appreciated. :)
I suspect you're going to need to set up a master/detail relationship between the burst query and each of the other two.
MF.
Try creating a query that only has the burst key in it and refer to it in the burst options. Associate that query to each of your report pages (presumably you have 3 pages, each one becoming a tab in the workbook) and then create a master-detail link between it and the layout container within the page.
edit: ah, the muppet beat me to the punch!
You're both amazing! Thank you so much for the help!