on 04-28-2015 7:41 AM
How to overcome the following problem?
1. I am using Crystal report 13.0.5.891
2. I have designed the report with Group Header as [Underlay following section]
3. I have checked the group to repeat on each page
4. Number of lines in the group header may vary
5. Number of lines in details may also vary
My objective is to print the separator line placed in group footer, after the
header lines or after the detail lines which one is taking the maximum lines.
This is not happening, and I am getting the following output, which is not meeting my requirement
Where the "LINE IN GROUP FOOTER" should appear after "Group 1 Header Line 6" in the second page
as the report ends there, but in the output, the line is coming just after the end of detail record.
like following
As a result of this, the next record of the group is overlapping with the first record and creating a mesh
------------------------------------------------------------------------------------------------------------------------------------ PAGE 1 OF 2
Column Heading 1 Column Heading 2 Column Heading 3
------------------------------------------------------------------------------------------------------------------------------------
Group 1 Header Line 1 Detail Record 1 Line 1
Group 1 Header Line 2 Detail Record 1 Line 2
Group 1 Header Line 3 ----------------------------------------------------------------------------------
Group 1 Header Line 4 Detail Record 2 Line 1
Group 1 Header Line 5 Detail Record 2 Line 2
Group 1 Header Line 6 Detail Record 2 Line 3
Detail Record 2 Line 4
Detail Record 2 Line 5
======================LINE IN GROUP FOOTER========================
PAGE BREAK
------------------------------------------------------------------------------------------------------------------------------------ PAGE 2 OF 2
Column Heading 1 Column Heading 2 Column Heading 3
------------------------------------------------------------------------------------------------------------------------------------
Group 1 Header Line 1 Detail Record 3 Line 1
Group 1 Header Line 2 Detail Record 3 Line 2
Group 1 Header Line 3 Detail Record 3 Line 3
Group 1 Header Line 4 Detail Record 3 Line 4
======================LINE IN GROUP FOOTER========================
Group 1 Header Line 5
Group 1 Header Line 6
Thanks in advance.
You're using Service Pack 5, current SP is 13. So, that would be the place to start; update to SP 13:
If you are still getting the issue, the next question would be; where is it happening? In the CR designer, or after you view the report in the app? Web, or win app?
- Ludek
Senior Support Engineer AGS Product Support, Global Support Center Canada
Follow me on Twitter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for you response.
I have updated the crystal report to 13.0.13.1597.
Still I am getting the same issue. I am generating the report in PortableDocFormat and exporting the byte array to download from the web browser. The application is developed in ASP.NET 2012 .net version 4.5.
I am also uploading 2 images of the final pdf that I am getting, for your opinion.
The report appeared in the first image is ok, where the first group has 2 child records and the second group has 1 child, but whenever I am changing the mapping in the database, where the first group has 1 child and second group has 2 child, my report is not working. as it is clear from the second image
Also after installing the new version of CR, my existing codes are not working, and giving the following exception in the line where ExportToStream is written.
Unable to cast object of type 'FileStreamDeleteOnClose' to type 'System.IO.MemoryStream'.
I have modified the existing code to overcome this exception.
Hi Ludek,
I do not know where the problem is, but I cannot achieve the prescribed report format by using crystal report.
My objective is that, even if the group header is marked as Underlay Following Sections and repeat on each page, the group footer should appear after the completion of group header or after completion of the detail section.
In my case as the height of the Group Header or the height of the Detail Section may vary record by record, so I cannot apply a fixed height assuming that the record will fit within the specified height.
The only solution, I can think of, is that if by any means I can tell the crystal report to print the group footer after the group header section or after the detail section.
For the group footer, Print at the bottom of the page option is not going to help me as, if there is only one record in the page then it will create a big empty space till the bottom which is not acceptable.
- Sumanta
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
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.