Skip to Content
0
Former Member
Mar 20, 2007 at 11:21 PM

Multiple Queries in a Workbook in 2004S

9 Views

Hello Experts,

We are using the 2004S front end and are on patch 11 with BI 7.0 backend. I have two queries in a workbook one on top of the other, say Q1 is on top and Q2 is below. I positioned them at a distance of 2 empty rows. Now the problem is when I drilldown on Q1 it expands downwards overwritting the Q2.

I am trying to find a way to push the Q2 down so that after Q1 expands Q2 is still positioned at 2 empty rows below it. Again when the drill down is removed on Q1, Q2 moves back up along with it. I tried different options in the "Clipping" (full size, clip, & scroll) tab of the table properties in the design mode but didnt get the desired result.

Can anyone help me get this done ? any suggestion will be highly appreciated.

Thank you.