Hello everyone.
I was just wondering if there is anyway I can change the Filter rules in this situation. I designed a chart with data filters using Edit Filters option. The filter mainly focuses on a particular country (Japan for this case). I want to create the same chart but I want South Korea, for example. What I did was to copy and paste the first chart. I clicked the second chart and then change the filter on country to South Korea. The problem I'm encountering is the first chart filter also changes. I realized that when I copy and pasted the first chart, the filter uses the same "Query1." To test a theory, I created a new chart from scratch (rather than copying and pasting it). When I checked the Edit Filter filter (sorry for the redundancy ;) - had to make a point LOL), the filter used for that now progressively "Query2"
Now my question is, is there any way I can copy and paste "chart1" but edit and change the filter to say "Query2" or "Query3" so that when I change some filter parameters, "chart1" won't be affected.
Thanks!
Copy the Chart1 and paste it into notepad or some text editor. You will see the XML fragment for the object and can then change references to the appropriate query. Copy your revised XML fragment and then paste it into workspace advanced.
Note that this is only going to work when the new query and all referenced elements already exist.
Alternatively, open the report in report studio and copy Query1 to make a new query, then copy the chart and change the query property to the new query. Of course edit the filter in the new query as desired.
Lastly, it is possible for your administrator to create a user interface profile for WSA that exposes more functionality so you can do these sorts of things directly in the tool.
Hi Lynn,
Thank you so much for your response. I'm now doing it and, while there are a few other things (referenced elements not yet existing), I'm able to "un-link" the new chart with the parameters of the old chart!
Thanks, again!