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
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
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] <pcipriani@chubb.com> wrote in message news:1162328460.537155.295090@h48g2000cwc.googlegroups.com... > 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 >
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] Chris Conner wrote: > 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 > > <pcipriani@chubb.com> wrote in message > news:1162328460.537155.295090@h48g2000cwc.googlegroups.com... > > 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 > >
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] <pcipriani@chubb.com> wrote in message news:1162407301.813963.216760@f16g2000cwb.googlegroups.com... > 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 > > > > Chris Conner wrote: >> 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 >> >> <pcipriani@chubb.com> wrote in message >> news:1162328460.537155.295090@h48g2000cwc.googlegroups.com... >> > 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 >> > >
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] Chris Conner wrote: > 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 > > <pcipriani@chubb.com> wrote in message > news:1162407301.813963.216760@f16g2000cwb.googlegroups.com... > > 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 > > > > > > > > Chris Conner wrote: > >> 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 > >> > >> <pcipriani@chubb.com> wrote in message > >> news:1162328460.537155.295090@h48g2000cwc.googlegroups.com... > >> > 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 > >> > > >
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] <pcipriani@chubb.com> wrote in message news:1162934127.012520.9370@m73g2000cwd.googlegroups.com... > 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 :) > > > Chris Conner wrote: >> 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 >> >> <pcipriani@chubb.com> wrote in message >> news:1162407301.813963.216760@f16g2000cwb.googlegroups.com... >> > 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 >> > >> > >> > >> > Chris Conner wrote: >> >> 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 >> >> >> >> <pcipriani@chubb.com> wrote in message >> >> news:1162328460.537155.295090@h48g2000cwc.googlegroups.com... >> >> > 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 >> >> > >> > >
Don't see what you're looking for? Try a search.
|
|
|