I've got a dataset with the following relations:
1) Top
1.1) Related Table 1
1.2) Related Table 2
1.2.1) Related Table 2.1
1.2.1) Related Table 2.2...
I'd like to show the Related Table 1 (1.1) as the first band under the top band, but the designer forces it below 2.1. Can I change the order programmatically?
Thanks.
I thought I marked Mike's response as the answer. I had another work around in place, so I haven't actually used the SortIndex, nor do I have time at this moment to try it. So I guess it is resolved. I'll resubmit if I have problems with SortIndex.
Seth,
Is your issue resolved?
Michael S.
I think SortIndex was what I was looking for. Sorry, I was unclear in my description. I'll repost if it doesn't resolve the issue.
Hi,
SAbady said:I'd like to show the Related Table 1 (1.1) as the first band under the top band, but the designer forces it below 2.1. Can I change the order programmatically?
You lost me here. What is "2.1"?
You can control the order of sibling bands in the grid using the SortIndex property on the band.
So, for example, if you want 1.2 to appear above 1.1, then you could set the SortIndex in each band to any values you want as long as the value you assign to the 1.2 band are lower than the value you assign to the 1.1 band.
I recreated the underlying dataset and that seemed to do the trick, but my question remains...can I programmatically alter the band order, as long as I maintain relational integrity, i.e. I won't move a child band above it's parent band?