all groups > sql server reporting services > october 2006 >
You're in the

sql server reporting services

group:

Sub-reports not in the same order as designed when the Main Report is generated



Sub-reports not in the same order as designed when the Main Report is generated pcipriani NO[at]SPAM chubb.com
10/31/2006 1:01:00 PM
sql server reporting services: Hi,

I have a main report with multiple subreports. I need to insert a new
subreport between two existing subreports. When I run the main
report, a pre-existing subreport is now jumping and printing out of
sequence.

Any idea how I can fix this problem? Does anybody know why the
sequence where I place the subreports is not maintained when the main
report is executed?

Thanks,
Patricia
Re: Sub-reports not in the same order as designed when the Main Report is generated Chris Conner
10/31/2006 5:02:18 PM
Open the RDL file in notepad and move the subreport section to the correct
place.

Make a backup copy first. I can't remember off the top of my head, but I
believe each subreport section has an ID to it as well. You may have to
resequence it - no big deal. :)

=-Chris

[quoted text, click to view]

Re: Sub-reports not in the same order as designed when the Main Report is generated pcipriani NO[at]SPAM chubb.com
11/1/2006 10:55:01 AM
Hi Chris,

Are you refering to the ZINDEX? If it is, the zindex appears to be the
sequence the subreport was freshly inserted into the report, as opposed
to the order the sub-report is actually being displayed in the main
report.

Should they be in sync?

Thanks,
Patricia



[quoted text, click to view]
Re: Sub-reports not in the same order as designed when the Main Report is generated Chris Conner
11/2/2006 11:24:15 AM
No, the ZINDEX refers to how the controls are layered on the report.

Was the subreport in the XML file in the correct place between the other two
subreports that were defined?

=-Chris

[quoted text, click to view]

Re: Sub-reports not in the same order as designed when the Main Report is generated pcipriani NO[at]SPAM chubb.com
11/7/2006 1:15:27 PM
Hi Chris,

The order of the Subreports bare no resemblance of the order of the
actual report (which is why I am so stumped on how to fix this
problem). The most recently added sub-reports are on the top of the
XML file, and yet are imbedded within the main report.

Patricia
p.s. I really appreciate you talking to me about this :)


[quoted text, click to view]
Re: Sub-reports not in the same order as designed when the Main Report is generated Chris Conner
11/14/2006 2:08:55 PM
You know what, this sounds stupid, but can you try to create the report from
scratch and insert the subreports in the order that you expect them to be
displayed in?

=-Chris

[quoted text, click to view]

AddThis Social Bookmark Button