Hi All
I'm new to Crystal XI so have a basic question for you guys. I have a report with 3 subreports and sometimes some of the subreports run onto more than one page. I would like to be able to repeat the subreport header on each page when this happens. Any ideas?
Much appreciated
OzHello I have got the same problem but, I am using the version 8.5.0.217
I have a report with 3 subreports each one giving some totally different information from one to the other and only the Header of the main report has common information. I need to print a subreport header in each page this subreports needs
Example
TITLE
A.- details main rep
B.- subreport_1
b.0 Title Subreport_1
b.1 detail Subreport_1
C.- subreport_2
c.0 title subreport_2
c.1 detail Subreport_2
D.- subreport_3
d.0 title Subreport_3
d.1 detail Subreport_3
The page header involves TITLE + A (details main rep)
The report detail involves the different subreports (B+C+D).
I need this b.0 (Title Subreport_1) line at the top of each page (under the main report Page header) the Subreport 1 is displaying.
Do you have any idea about how to solve this? Thank you very much
Showing posts with label subreport. Show all posts
Showing posts with label subreport. Show all posts
Tuesday, March 20, 2012
Monday, March 12, 2012
Repeating Group headers on reports with subreports
I have a report that contains a table. The group header in the table is set
to repeat on a new page. However, as soon as I place a subreport in the table
of the main report and that subreport causes a page break...the group header
on the top-level report doesn't repeat. Is there a workaround for this
shortcoming?
Regards,
Dean NeroNero,
Did you ever find an answer for this? I am having the same issue...and
its killin' me!
Michael
"Dean Nero" wrote:
> I have a report that contains a table. The group header in the table is set
> to repeat on a new page. However, as soon as I place a subreport in the table
> of the main report and that subreport causes a page break...the group header
> on the top-level report doesn't repeat. Is there a workaround for this
> shortcoming?
> Regards,
> Dean Nero
to repeat on a new page. However, as soon as I place a subreport in the table
of the main report and that subreport causes a page break...the group header
on the top-level report doesn't repeat. Is there a workaround for this
shortcoming?
Regards,
Dean NeroNero,
Did you ever find an answer for this? I am having the same issue...and
its killin' me!
Michael
"Dean Nero" wrote:
> I have a report that contains a table. The group header in the table is set
> to repeat on a new page. However, as soon as I place a subreport in the table
> of the main report and that subreport causes a page break...the group header
> on the top-level report doesn't repeat. Is there a workaround for this
> shortcoming?
> Regards,
> Dean Nero
Repeating Group Footer in a Subreport
I have a subreport that can be pages long. On each page, I need the group footer repeated. I can get the header to repeat, but not the footer.
Any help will be greatly appreciated!I think you can't.. as it appears at the end of the group...
could you use the page footer ?
Luc|||Thanks for letting me know that I can't repeat the group footer - now I'll have to try and take a different approach!
I suppose I could try sticking the subreports in the detail, so that I could have a page footer... I'll try it and see how it goes.
Any help will be greatly appreciated!I think you can't.. as it appears at the end of the group...
could you use the page footer ?
Luc|||Thanks for letting me know that I can't repeat the group footer - now I'll have to try and take a different approach!
I suppose I could try sticking the subreports in the detail, so that I could have a page footer... I'll try it and see how it goes.
Friday, March 9, 2012
Repeat title on every page
Hello all,
I'm trying to find solution to show sub-report title on every page of that
subreport.
What I have in the subreport is the text containing title and two tables
underneath.
The first table is a summary table and will only be shown on the first page.
The second table goes over few pages.
What I need is to get the title (which is above he first table) to show on
every page of that subreport, when exported to PDF.Instead its only shown on
the first page.
I have tried many things, nothing seems to work.
What should be the solution does NOT work: I have set a property on the
title text box to 'Repeat on every page with data region' , where data region
is set to be table 2.
Can anyone help me?
Many thanks
--
NatashaOn Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> Hello all,
> I'm trying to find solution to show sub-report title on every page of that
> subreport.
> What I have in the subreport is the text containing title and two tables
> underneath.
> The first table is a summary table and will only be shown on the first page.
> The second table goes over few pages.
> What I need is to get the title (which is above he first table) to show on
> every page of that subreport, when exported to PDF.Instead its only shown on
> the first page.
> I have tried many things, nothing seems to work.
> What should be the solution does NOT work: I have set a property on the
> title text box to 'Repeat on every page with data region' , where data region
> is set to be table 2.
> Can anyone help me?
> Many thanks
> --
> Natasha
You should be able to add a page header to the subreport (via 'Layout'
view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
repeat on every page when exported to PDF. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
I have tried using subreport headers before, but it doesnot show them at all
- this is another MRS limitation. Only main report headers and/or footers are
displayed.
"EMartinez" wrote:
> On Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> > Hello all,
> > I'm trying to find solution to show sub-report title on every page of that
> > subreport.
> > What I have in the subreport is the text containing title and two tables
> > underneath.
> > The first table is a summary table and will only be shown on the first page.
> > The second table goes over few pages.
> > What I need is to get the title (which is above he first table) to show on
> > every page of that subreport, when exported to PDF.Instead its only shown on
> > the first page.
> > I have tried many things, nothing seems to work.
> > What should be the solution does NOT work: I have set a property on the
> > title text box to 'Repeat on every page with data region' , where data region
> > is set to be table 2.
> > Can anyone help me?
> >
> > Many thanks
> >
> > --
> > Natasha
>
> You should be able to add a page header to the subreport (via 'Layout'
> view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
> repeat on every page when exported to PDF. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||A little clumsy, but you could add an additional dataset in the main
report to provide the subreport heading that you want to repeat - if
you want values from it to appear in the actual header, you need to
use the following trick to show dataset values in the header (or
footer):
Go to Report|Report Properties menu.
Put code similar to the following into the Code tab (for each field
you plan on using in the header, add a global variable and a function
to return it and/or a parameter).
Sample:
Public Shared reportTitle As String
Public Shared reportName As String
Public Shared Function StoreHeaderInfo( title As String, name As
String) As String
reportTitle = title
reportName = name
' we need the assignment statement below, because method must return
something
' otherwise, we can't use it in a table cell or textbox
StoreHeaderInfo = ""
End Function
Then, in the body of the report, add a hidden textbox that has an
expression similar to this:
=Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
ReportName.Value )
Finally, in the header, put in a text box that has the expression:
=Code.reportName or =Code.reportTitle|||Hello Parker,
I'd like to thank you for your response.
Unfortunatelly, I couldnt get it to work using this approach.I'm not sure if
I understood where Function StoreHeaderInfo supposed to go to, into the code
of the main report, or subreport?
I have tried both, but it didnt work..
I could not use the header of the main report, as I didnt want to use the
same header accross all subreports. The main header works fine if it is to be
applied throughout all report (will be applied to all subreports)...from what
I could find is that it can only be hidden on the first and/or the last page
if required...I couldnt find a way to control it accross subreports...
If I try to make use of the header in the subreport , it doesnt work
again...this header is completelly ignored once I run the whole report.
This is what I did at the end:
I have modified table 2 and made table 1 part of the table 2 (created new
group in table one and placed table 1 into it)...
I have then added Title which I wanted to repeat into the table 2 header.
Thank you again!
"Parker" wrote:
> A little clumsy, but you could add an additional dataset in the main
> report to provide the subreport heading that you want to repeat - if
> you want values from it to appear in the actual header, you need to
> use the following trick to show dataset values in the header (or
> footer):
> Go to Report|Report Properties menu.
> Put code similar to the following into the Code tab (for each field
> you plan on using in the header, add a global variable and a function
> to return it and/or a parameter).
> Sample:
> Public Shared reportTitle As String
> Public Shared reportName As String
> Public Shared Function StoreHeaderInfo( title As String, name As
> String) As String
> reportTitle = title
> reportName = name
> ' we need the assignment statement below, because method must return
> something
> ' otherwise, we can't use it in a table cell or textbox
> StoreHeaderInfo = ""
> End Function
> Then, in the body of the report, add a hidden textbox that has an
> expression similar to this:
> =Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
> ReportName.Value )
> Finally, in the header, put in a text box that has the expression:
> =Code.reportName or =Code.reportTitle
>
I'm trying to find solution to show sub-report title on every page of that
subreport.
What I have in the subreport is the text containing title and two tables
underneath.
The first table is a summary table and will only be shown on the first page.
The second table goes over few pages.
What I need is to get the title (which is above he first table) to show on
every page of that subreport, when exported to PDF.Instead its only shown on
the first page.
I have tried many things, nothing seems to work.
What should be the solution does NOT work: I have set a property on the
title text box to 'Repeat on every page with data region' , where data region
is set to be table 2.
Can anyone help me?
Many thanks
--
NatashaOn Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> Hello all,
> I'm trying to find solution to show sub-report title on every page of that
> subreport.
> What I have in the subreport is the text containing title and two tables
> underneath.
> The first table is a summary table and will only be shown on the first page.
> The second table goes over few pages.
> What I need is to get the title (which is above he first table) to show on
> every page of that subreport, when exported to PDF.Instead its only shown on
> the first page.
> I have tried many things, nothing seems to work.
> What should be the solution does NOT work: I have set a property on the
> title text box to 'Repeat on every page with data region' , where data region
> is set to be table 2.
> Can anyone help me?
> Many thanks
> --
> Natasha
You should be able to add a page header to the subreport (via 'Layout'
view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
repeat on every page when exported to PDF. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
I have tried using subreport headers before, but it doesnot show them at all
- this is another MRS limitation. Only main report headers and/or footers are
displayed.
"EMartinez" wrote:
> On Sep 5, 11:12 pm, Natasha <batin...@.hotmail.com> wrote:
> > Hello all,
> > I'm trying to find solution to show sub-report title on every page of that
> > subreport.
> > What I have in the subreport is the text containing title and two tables
> > underneath.
> > The first table is a summary table and will only be shown on the first page.
> > The second table goes over few pages.
> > What I need is to get the title (which is above he first table) to show on
> > every page of that subreport, when exported to PDF.Instead its only shown on
> > the first page.
> > I have tried many things, nothing seems to work.
> > What should be the solution does NOT work: I have set a property on the
> > title text box to 'Repeat on every page with data region' , where data region
> > is set to be table 2.
> > Can anyone help me?
> >
> > Many thanks
> >
> > --
> > Natasha
>
> You should be able to add a page header to the subreport (via 'Layout'
> view in BIDS -> 'Report' drop-down menu -> 'Page Header'). This should
> repeat on every page when exported to PDF. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||A little clumsy, but you could add an additional dataset in the main
report to provide the subreport heading that you want to repeat - if
you want values from it to appear in the actual header, you need to
use the following trick to show dataset values in the header (or
footer):
Go to Report|Report Properties menu.
Put code similar to the following into the Code tab (for each field
you plan on using in the header, add a global variable and a function
to return it and/or a parameter).
Sample:
Public Shared reportTitle As String
Public Shared reportName As String
Public Shared Function StoreHeaderInfo( title As String, name As
String) As String
reportTitle = title
reportName = name
' we need the assignment statement below, because method must return
something
' otherwise, we can't use it in a table cell or textbox
StoreHeaderInfo = ""
End Function
Then, in the body of the report, add a hidden textbox that has an
expression similar to this:
=Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
ReportName.Value )
Finally, in the header, put in a text box that has the expression:
=Code.reportName or =Code.reportTitle|||Hello Parker,
I'd like to thank you for your response.
Unfortunatelly, I couldnt get it to work using this approach.I'm not sure if
I understood where Function StoreHeaderInfo supposed to go to, into the code
of the main report, or subreport?
I have tried both, but it didnt work..
I could not use the header of the main report, as I didnt want to use the
same header accross all subreports. The main header works fine if it is to be
applied throughout all report (will be applied to all subreports)...from what
I could find is that it can only be hidden on the first and/or the last page
if required...I couldnt find a way to control it accross subreports...
If I try to make use of the header in the subreport , it doesnt work
again...this header is completelly ignored once I run the whole report.
This is what I did at the end:
I have modified table 2 and made table 1 part of the table 2 (created new
group in table one and placed table 1 into it)...
I have then added Title which I wanted to repeat into the table 2 header.
Thank you again!
"Parker" wrote:
> A little clumsy, but you could add an additional dataset in the main
> report to provide the subreport heading that you want to repeat - if
> you want values from it to appear in the actual header, you need to
> use the following trick to show dataset values in the header (or
> footer):
> Go to Report|Report Properties menu.
> Put code similar to the following into the Code tab (for each field
> you plan on using in the header, add a global variable and a function
> to return it and/or a parameter).
> Sample:
> Public Shared reportTitle As String
> Public Shared reportName As String
> Public Shared Function StoreHeaderInfo( title As String, name As
> String) As String
> reportTitle = title
> reportName = name
> ' we need the assignment statement below, because method must return
> something
> ' otherwise, we can't use it in a table cell or textbox
> StoreHeaderInfo = ""
> End Function
> Then, in the body of the report, add a hidden textbox that has an
> expression similar to this:
> =Code.StoreHeaderInfo( Fields!ReportTitle.Value, Fields!
> ReportName.Value )
> Finally, in the header, put in a text box that has the expression:
> =Code.reportName or =Code.reportTitle
>
Subscribe to:
Posts (Atom)