on 10-18-2012 6:57 PM
I have a solution to an issue that has been around for many years in Crystal Reports. However, if anyone has a simple solution to this problem please share it with me. If not, I have a way to do it.
Here is the issue:
When a subreport is placed in the Report Footer section we are able to utilize the Page Header section/s of the main report without any problems. However, if a subreport that may produce multiple pages needs to be placed in the Report Header of the main report, how will one create the page header of the sub-report to repeat until it's completion? As we all know once a sub-report is embedded into the main report, the page headers of the sub-report are no longer available.
Hi Tony,
I do not have any anything to offer other than what you've heard or what you already have in implemented.
Anyway, just for the record - you would need to create a formula similar to this in the Subreport:
whilereadingrecords;
""
Then use this formula to create a new group and check the 'Repeat Group Header on each page' under Group Options.
I hope this is how you're getting around this - well there isn't any other way really.
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Abhilash,
Thanks for the response.
We are also taking into consideration the sub-report does not have any groupings done. Therefore, 'REPEAT GROUP HEADER ON EACH PAGE' will not apply.
The question is, have you or to the best of your knowledge had anyone ask this question before?
Well I opened this subject up for 3 reasons:
1) To find out whether anyone out there has had a problem with this issue
2) If so, whether someone has a solution.
2) Lastly, to let everyone know that I have been successfully using a way to accomplish it and would gladly share it if necessary.
Thanks,
Tony
Hi Tony,
Your basic question was if a Subreport can have its own Page Header right?
The workaround that I suggested above involves creating a fake group that is placed above any other existing groups.
Am I interpreting your question correctly? Why not kill the suspense and reveal the workround you've already implemented; we're all here to learn !
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
Hi everyone,
Since I am unable to attach a Word doc, I have inserted a converted JPG instead.
This is a roundabout way to do it when a grouping should not be used. Remember this is for sub-reports that need to be placed in the Report Header and not the Report Footer. As you may already know, repeating page headers for reports embedded in the Report Footer can easily be achieved using the Page Header of the main report.
It has been working for me sucessfully for quite some time.
If you need to insert any image files on the header there is a way to accomplish that too.
Please let me know if you have any questions, comments or any feedback.
Thanks,
Tony
In a nutshell, I am utilizing the page number that's been used in a counter to look at the first record of every new page.
The counter starts with a Zero.
Each time a new page is turned, the Page Header looks at the counter to see whether it's a match with the new page number. If it is not, it adds the new page number to counter and moves to the next record.
Hi Tony,
The workaround works fine to be honest, however don't you think that's a long way out?
The same results can be achieved using the workaround I posted above. Did you follow my instructions correctly?
That's the workaround that many of us have used in the past (and we still do in some our reports).
Is there an advantage that your workaround offers that I might have missed?
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
Ahh, this a great interview question, don't you think !
Anyway, thanks for sharing the other method. Please do close the thread.
- Abhilash
Follow us on Twitter
Got Enhancement ideas? Try the SAP Idea Place
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.