Firstly I would like to know if we can create jump queries between workbook and a query. I know I can jump from query to query and workbook to query but how about query to workbook.
Secondly is there a problem in creating graphs in a workbook based on just one category in the report and if so can we dynamically change the title on the graph.
Example I have 4 regions N, E, W, S and based on the sales rate I need to create graphs. I wanted the graph title changed depending on my selection criteria. Is it possible or I need to create them in WAD?
I am sure you guys would have a solution for this and expecting for an appropriate answer, thanks for all the prior help and ideas.