I have 3 reports that are to be done and the users want to see all these reports in one layout. So I had used a workbook to have all the reports displayed in one layout.
While creating each of the reports on an individual basis I had selected the same Characteristics as the Selection Variables and also as the Free characteristics. When I execute each of these reports individually I am able to drill down on the characteristics I have included in each report.
The way I created my workbook is, first I executed Report 1 and then saved it as a workbook and then inserted the other 2 reports by going into the design mode and stuff and successfully merged all of the 3 reports into 1 workbook.
So the issue here is, since the selection variables for all the 3 reports are the same I don't have a problem executing the report, but when I want to drill down on the free characteristics ( For all the 3 reports Free Characteristics are the same ), I am able to drill down only on the Report 1 that I had executed first and saved as a workbook. But am unable to drill down on the other 2 reports that I had inserted into the workbook later.
So I had tried a trial & error method where this time I have first executed Report 2, saved it as a workbook and then inserted the queries for report 1 & report 3 and I am able to drill down only on report 2 which I had executed and saved as a workbook.
So I want to know, is this the way we can work with workbooks or is there a way where we can drill down on all the 3 reports. If we can drill down on all the reports in a workbook, kindly let me know how we go about it. Kindly pass on your suggestions and it's pretty urgent so earlier the better.
Thanks a lot,