Hello, can someone help me?
I need to make an active report with a crosstab, very simple.
In columns need to display some measures, and rows months.
Above Crosstab I have a data drop down list, with the stores. When I choose a store want the data to be filtered on the crosstab, but do not want to display the stores in crosstab, just want the values reflect the store chosen filter.
I put the store in the crosstab query, but the Report Studio does not let me make the connection between the data drop down list and crosstab, only if the store is included in the Crosstab.
I tried to include the store in the crosstab and change the visibility of the column, but it did not work.
Does anyone know how to do this?
Tks!!! :)
Hi,
take a data deck, put the store item in the query of the data deck. Drop a crosstab in the data deck and put the store item in that query too. Now link your dropdown list to the data deck on the store item. Finally make a master-detail relationship between the data deck and the crosstab on the store item.
For each store you choose, a new deck will be loaded for that store. Because of the master-detail relationship the data inside the crosstab will be filtered per store.
Hunter
Hi RandomHunter,
You can view it below URL for better understanding of filtering the crosstab using data drop down list.
http://bi-suresh.blogspot.sg/p/blog-page.html
Please let me know if you need more info on this,
Thanks.