| Groups | Blog | Home |
sql server reporting services : Setting a subreport to bottom of page
I have a subreport that contains signatures that are dynamically generated thought the code in my application. I need these signatures to show up at the very bottom of each page in the grouping. For example, if a patient has 3 pages of information I would like the signatures to show up on the 3rd page on the bottom. It seems that Reporting Services will not allow a subreport in a footer and this is a big problem for me, does anyone know a work-around or a property to get these subreports to dock/anchor to the bottom of the page no matter how many records come back on the main report? Any help would be greatly appreciated.
Thanks for your reply,
However, I tried this and it works well to put the signatures on the last page, but I need to place the signatures on the bottom of each page for each particular patient grouping by patients in a list control. For example, patientA has half a page of records to be shown, then signatures at the bottom of that page, patientB has a page and a half of records, then signatures should not show up on the first page, but rather the bottom of the second page and so on. I have tried the rectangle control and it seems as though if I put any white space between the items to be shown in the list control and the subreport (If I wanted to hardcode the spacing to be at bottom) this doesn't work because when the patient has 3/4 of a page then the signatures show up on a second blank page with just the signatures. This is no good. Anyway, thanks for you time, does anyone else have suggestions? [quoted text, click to view] Steve Dearman wrote:
> Im only guessing here but if you actually put this sub report at the bottom > under any other data on the page( with the spacing set out so that the > report is at the bottom of what would be a a4(or what ever) page then it > should appear at the bottom no matter how many lines are returned and not > move up past the point that you have placed it, Maybe place the signatures > in a rectangle at the bottom of the page, they should stay there, and to get > it to apear on the last page only you can write a expression to put in the > visibility part of the rectangle thats hlding the signatures that finds out > how many pages the report has and shows only on the last page( the functions > are general ones that are listed). > Hope this works and helps > Steve D > > "jwhampton" <jhampton@netalytics.com> wrote in message > news:1149692048.999430.207490@i40g2000cwc.googlegroups.com... > > Hello all, > > > > I have a subreport that contains signatures that are dynamically > > generated thought the code in my application. I need these signatures > > to show up at the very bottom of each page in the grouping. For > > example, if a patient has 3 pages of information I would like the > > signatures to show up on the 3rd page on the bottom. It seems that > > Reporting Services will not allow a subreport in a footer and this is a > > big problem for me, does anyone know a work-around or a property to get > > these subreports to dock/anchor to the bottom of the page no matter how > > many records come back on the main report? Any help would be greatly > > appreciated. > >
Im only guessing here but if you actually put this sub report at the bottom
under any other data on the page( with the spacing set out so that the report is at the bottom of what would be a a4(or what ever) page then it should appear at the bottom no matter how many lines are returned and not move up past the point that you have placed it, Maybe place the signatures in a rectangle at the bottom of the page, they should stay there, and to get it to apear on the last page only you can write a expression to put in the visibility part of the rectangle thats hlding the signatures that finds out how many pages the report has and shows only on the last page( the functions are general ones that are listed). Hope this works and helps Steve D [quoted text, click to view] "jwhampton" <jhampton@netalytics.com> wrote in message news:1149692048.999430.207490@i40g2000cwc.googlegroups.com... > Hello all, > > I have a subreport that contains signatures that are dynamically > generated thought the code in my application. I need these signatures > to show up at the very bottom of each page in the grouping. For > example, if a patient has 3 pages of information I would like the > signatures to show up on the 3rd page on the bottom. It seems that > Reporting Services will not allow a subreport in a footer and this is a > big problem for me, does anyone know a work-around or a property to get > these subreports to dock/anchor to the bottom of the page no matter how > many records come back on the main report? Any help would be greatly > appreciated. >
If you are using grouping by patient then you could try the group footers,
this would put the signature in the group footer after each group, but no i dont know how you would get it to insert in the middle of a group, are you sure theres no way of putting the signatures in the footer, Do they have to be a sub report or could you incorperate the data set in to the report? [quoted text, click to view] "jwhampton" <jhampton@netalytics.com> wrote in message news:1149697647.704494.188470@h76g2000cwa.googlegroups.com... > Thanks for your reply, > > > However, I tried this and it works well to put the signatures on the > last page, but I need to place the signatures on the bottom of each > page for each particular patient grouping by patients in a list > control. For example, patientA has half a page of records to be shown, > then signatures at the bottom of that page, patientB has a page and a > half of records, then signatures should not show up on the first page, > but rather the bottom of the second page and so on. I have tried the > rectangle control and it seems as though if I put any white space > between the items to be shown in the list control and the subreport (If > I wanted to hardcode the spacing to be at bottom) this doesn't work > because when the patient has 3/4 of a page then the signatures show up > on a second blank page with just the signatures. This is no good. > Anyway, thanks for you time, does anyone else have suggestions? > > > > Steve Dearman wrote: >> Im only guessing here but if you actually put this sub report at the >> bottom >> under any other data on the page( with the spacing set out so that the >> report is at the bottom of what would be a a4(or what ever) page then it >> should appear at the bottom no matter how many lines are returned and not >> move up past the point that you have placed it, Maybe place the >> signatures >> in a rectangle at the bottom of the page, they should stay there, and to >> get >> it to apear on the last page only you can write a expression to put in >> the >> visibility part of the rectangle thats hlding the signatures that finds >> out >> how many pages the report has and shows only on the last page( the >> functions >> are general ones that are listed). >> Hope this works and helps >> Steve D >> >> "jwhampton" <jhampton@netalytics.com> wrote in message >> news:1149692048.999430.207490@i40g2000cwc.googlegroups.com... >> > Hello all, >> > >> > I have a subreport that contains signatures that are dynamically >> > generated thought the code in my application. I need these signatures >> > to show up at the very bottom of each page in the grouping. For >> > example, if a patient has 3 pages of information I would like the >> > signatures to show up on the 3rd page on the bottom. It seems that >> > Reporting Services will not allow a subreport in a footer and this is a >> > big problem for me, does anyone know a work-around or a property to get >> > these subreports to dock/anchor to the bottom of the page no matter how >> > many records come back on the main report? Any help would be greatly >> > appreciated. >> > >
Thanks for your return reply...
Yes I am sure that you cannot have subreports in a report footer. I cannot pull the signature information back in the dataset, because I don't know how many signatures will be on the report. For example, the customer might want only one signature centered, 3 signatures straight across, etc. I have a subreport that has six distinct locations to let the user pick the location. I can put the signatures in the group footer, but the signatures show up right after the grouping which could be at half a page if the patient doesn't have many records or anywhere the grouping ends, it just looks bad not being consistent. Thanks for your help. Any other suggestions would greatly be appreciated. Jonathan [quoted text, click to view] Steve Dearman wrote:
> If you are using grouping by patient then you could try the group footers, > this would put the signature in the group footer after each group, but no i > dont know how you would get it to insert in the middle of a group, are you > sure theres no way of putting the signatures in the footer, Do they have to > be a sub report or could you incorperate the data set in to the report? > "jwhampton" <jhampton@netalytics.com> wrote in message > news:1149697647.704494.188470@h76g2000cwa.googlegroups.com... > > Thanks for your reply, > > > > > > However, I tried this and it works well to put the signatures on the > > last page, but I need to place the signatures on the bottom of each > > page for each particular patient grouping by patients in a list > > control. For example, patientA has half a page of records to be shown, > > then signatures at the bottom of that page, patientB has a page and a > > half of records, then signatures should not show up on the first page, > > but rather the bottom of the second page and so on. I have tried the > > rectangle control and it seems as though if I put any white space > > between the items to be shown in the list control and the subreport (If > > I wanted to hardcode the spacing to be at bottom) this doesn't work > > because when the patient has 3/4 of a page then the signatures show up > > on a second blank page with just the signatures. This is no good. > > Anyway, thanks for you time, does anyone else have suggestions? > > > > > > > > Steve Dearman wrote: > >> Im only guessing here but if you actually put this sub report at the > >> bottom > >> under any other data on the page( with the spacing set out so that the > >> report is at the bottom of what would be a a4(or what ever) page then it > >> should appear at the bottom no matter how many lines are returned and not > >> move up past the point that you have placed it, Maybe place the > >> signatures > >> in a rectangle at the bottom of the page, they should stay there, and to > >> get > >> it to apear on the last page only you can write a expression to put in > >> the > >> visibility part of the rectangle thats hlding the signatures that finds > >> out > >> how many pages the report has and shows only on the last page( the > >> functions > >> are general ones that are listed). > >> Hope this works and helps > >> Steve D > >> > >> "jwhampton" <jhampton@netalytics.com> wrote in message > >> news:1149692048.999430.207490@i40g2000cwc.googlegroups.com... > >> > Hello all, > >> > > >> > I have a subreport that contains signatures that are dynamically > >> > generated thought the code in my application. I need these signatures > >> > to show up at the very bottom of each page in the grouping. For > >> > example, if a patient has 3 pages of information I would like the > >> > signatures to show up on the 3rd page on the bottom. It seems that > >> > Reporting Services will not allow a subreport in a footer and this is a > >> > big problem for me, does anyone know a work-around or a property to get > >> > these subreports to dock/anchor to the bottom of the page no matter how > >> > many records come back on the main report? Any help would be greatly > >> > appreciated. > >> > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |