namanpatel
asked on
Dyanamically position subreport (Y poisition)
Hi,
I have master report with 6 subreports. 4 on the left handside and 2 on the right hand side. 4 of these subreports are Variable row subreports. 2 RHS subreports are variable row and 2 of LHS are variable row subreports.
I have 2 subreports on detail section 1, 2 on detail section 2, 1 on DS 3 and 1 on DS4
RH
PH
D
D1
SB1 | SB2 (Variable Row)
D2
SB3 (Variable Row) | SB4 (Variable Row)
D3
SB5 (Varialb Row)
D4
SB6 (Variable Row)
RF
PF
Problem:
Whenever SB2 return more rows SB3 pushed down and there will be a gap between SB1 and SB3. Same is with SB3 and SB5.
My requirement is to show 2 columns of subreport without any gap vertiacally between 2 subreports. Both Column size is fixed.
Hope I have described my question clearly. Please feel free for more clarification.
Thanks,
-Naman.
I have master report with 6 subreports. 4 on the left handside and 2 on the right hand side. 4 of these subreports are Variable row subreports. 2 RHS subreports are variable row and 2 of LHS are variable row subreports.
I have 2 subreports on detail section 1, 2 on detail section 2, 1 on DS 3 and 1 on DS4
RH
PH
D
D1
SB1 | SB2 (Variable Row)
D2
SB3 (Variable Row) | SB4 (Variable Row)
D3
SB5 (Varialb Row)
D4
SB6 (Variable Row)
RF
PF
Problem:
Whenever SB2 return more rows SB3 pushed down and there will be a gap between SB1 and SB3. Same is with SB3 and SB5.
My requirement is to show 2 columns of subreport without any gap vertiacally between 2 subreports. Both Column size is fixed.
Hope I have described my question clearly. Please feel free for more clarification.
Thanks,
-Naman.
ASKER
Sorry for that mistake. there are 5 sb with variable row.
Major problem is SB3 / SB5 and SB5/SB6.
Is it possible by any means to dynamically adjust Y position of subreport?
Major problem is SB3 / SB5 and SB5/SB6.
Is it possible by any means to dynamically adjust Y position of subreport?
ASKER
SB5/SB6 are not creating gap as there is no SB beside SB5.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes. It seems there is no solution or alternate way available.
In this case I think the correct answer "it can't be done" was given.
You show 5 as being variable.
If SB1 is a fixed size then you should be able to move SB3 into D1 and remove that gap. (So you now have SB5 and SB4 in D3 and soon..)
However, as far as I can see, that is all you can do.
You cannot also ensure that that there is no gap between SB3 & SB5 and between SB2 & SB4 beacus e the sections will expand to the size of the larget subreport.