cancel
Showing results for 
Search instead for 
Did you mean: 

Details section extends to a whole page when multipage field is printed

Former Member
0 Kudos
1,227

Crystal Reports designer in VS 2005 Prof. C#

I have a field which sometimes is large, so it is printed on several pages.

When a field is small, ie. starts and finishes on the same page, then all is OK. I mean, that Details vertical lines and field borders are closed as soon as the last field is fully printed. Report Footer is propely printed after the last Details row.

But when a field occupies several pages then, on the last page, the Details section is not closed after the last row but extends to a whole page.

So, as a result of this behavior, the Report Footer is printed over the Detail's vertical lines. This is my problem.

I tried the following:

1. Change setting Keep Object Together - does not help.

2. Inserting an extra Group Section - Group Footer was printed over on Details body - overlapped.

To show this problem here are 2 pictures. Please pay attention to the column "Odcinki".

[The view with a small field|http://www.zgadzaj.pl/temp/KIM_Dobry.jpg]

[The view with Details expanded to a whole page|http://www.zgadzaj.pl/temp/KIM_Usterka.jpg]

Marek

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Assuming that; "Crystal Reports designer in VS 2005 Prof. C#" means that you are using CR 10.2 ( CR assemblies version 10.2.3600), I'd start by applying the latest Service Pack for that version. The SP for CR 10.2 is here:

https://smpdl.sap-ag.de/~sapidp/012002523100006007872008E/crvs05sp1.exe

Also, try to do the following:

Right click on any empty space on the CR design pane. From the pop up menu select "Design", then "Printer setup". Enable the option "No Printer".

Ludek

Former Member
0 Kudos

Ludek,

CR version is exactly the same as you wrote. The DLL vesrion is 10.2.0.1222.

The "No printer" setting was checked before but I tested both checked and unchecked. Unfortunately nothing changes.

Now I try to install SP1 using you advices.

Thank you for the support

Marek

former_member183750
Active Contributor
0 Kudos

OK, good. I'll keep my fingers crossed. If the SP does not help, let me know if this is a web or a win app. Also, look at the vertical lines and see if they touch the section separator. If they do, shorten the lines just a bit.

Ludek

Former Member
0 Kudos

Ludek,

Application

This is WinForm (desktop) application.

Vertical lines

I moved the section bottom down ~1cm, so all vertical lines are shorter then section height.

Unfortunately - no sucess.

Last row

I changed rows order to get the last row small - not mutlipage and I set a row before to be printed on several pages. The row 9148 is properly closed and the last row 9149 is also properly printed. The preview is [here|http://www.zgadzaj.pl/temp/LastRow.jpg]. The extra space before the Details section bottom can be seen also.

Added later:

The row 9148 is OK, but the previous row 9147 is wrong. It is multipage row and was not closed. To be more precise its Details section has been expanded to the next row 9148, so it looks like not closed.

It means that problem with multipage rows is related not only to the last one but to each multipage row.

Thanks for the support,

Marek

former_member200290
Contributor
0 Kudos

Do the verticle lines have have the property "extend to bottom of section" turned on or the details section have the property "Underlay following sections" turned on? If so turn them off and see what happens.

Trevor

Former Member
0 Kudos

Trevor,

The "Extend to bottom of section" property was set (enabled) to all vertical lines and for box (frame) which surrounds the whole details row. The "Underlay following sections" setting was not checked for details sections.

As you suggested I unchecked all "Extends", and "Underlay.." remains unchecked. I printed 2 examples into PDF:

[The example with CHECKED "Extends" settings.|http://www.zgadzaj.pl/temp/KIM_WithExtend.pdf]

[The example with UNCHECKED "Extends" settings.|http://www.zgadzaj.pl/temp/KIM_NoExtend.pdf]

Thanks for suggestions

Marek

Former Member
0 Kudos

Ludek,

I installed CRVS05SP1 successfully but problem with extended fields still persist.

I have one more - I thing very important information, which probably help us to solve this issue:

I found, in my trash can, an old piece of paper which was printed on 14-01-2009. This paper contains the last page of the report where I tested something else. And this report is absolutely CORRECT.

I mean, that extended field was printed as it should be. If you want I can make a photo of this page and send here.

It means there was something else which leads to see this issue now. Today is very late here, but tomorrow I am going to build the report from the beginning and see if it works.

Of course I let you know as soon as possible.

Regards,

Marek

Former Member
0 Kudos

Hello Guys,

I've extracted and isolated the report into separate project. The project contains application, dataset, data and the report. This project shows the issue related to extended fields.

Please download the project from this [link|http://www.zgadzaj.pl/temp/KimTest.zip] - ~120KB

I hope it will help to find the solution.

Regards,

Marek

former_member183750
Active Contributor
0 Kudos

Marek, as unlikely as this may sound, updating the printer driver may help. Alternatively, set the report to "No Printer". You will find that option under Design | Page setup.

Ludek

former_member200290
Contributor
0 Kudos

Hi Marek,

I would also suggest that if you require this level of help, debugging code/reports, from a dedicated engineer to purchase a support case.

Trevor

Former Member
0 Kudos

Hi Ludek,

"No printer" - we tested this option earlier but I tried to change this option again.

I tested:

1. No printer

2. HP Laser Jet 4L

3. HP Deskjet 1120C

4. PDF Factory

Unfortunately - no success.

I did'nt test to build the report from the beginning, yet but I do it.

By the way, can you test the project I prepared, is it work properly on your PC ?

Thanks for trying to help me.

Marek

former_member200290
Contributor
0 Kudos

We cannot download the sample project and test it. If you require this level of assistance I suggest you purchase a support case so you can get help by a dedicated engineer.

Trevor

Former Member
0 Kudos

Hi Trevor and Ludek,

1. The report on this piece of paper I found in my trash can was correct because the extended field was not the last row. I appologize for my mistake.

2. I tested the extended field on a new report and I found that this issue does not affect horizontal lines.

("Move to bottom of the section" should be set). Horizontal lines precisely shows where the Details section ends. If you put vertical lines or box'es (which have 2 vertical lines left and right) and horizontal line than you will see that all objects which contain vertical lines are extended to the bottom of the page instead of the bottom of the Details sections. The horizontal line is printed on bottom of the section.

There are only several settings which are involved with this behavior. We were tested near all combinations. I suppose that this is a bug.

I give up and resign of using vertical lines. I will spend more time looking for another report generator.

Thanks again for your time, patience, support, help and comments.

Regards,

Marek

Former Member
0 Kudos

Hi Trevor and Ludek,

At last success - I found the workaround!

Before my give up, during the downloading time of the PerpetuumSoftware report generator, I tested the last idea which comes from [Joe's help posted in this thread|http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/77b28835-12aa-4592-bcc8-c2b8dbf49317].

I removed all vertical lines from the Detail section and the box surrounding the Detail's section row.

I inserted a new group section which works exactly as the Detail section, so it changes along with Detail section.

I put the vertical lines starting from the GroupHeader section and expanded it across the Detail section to the middle height somewhere inside the GroupFooter. And now I set the line's bottom = 0. It means that it ends exactly at the top of GroupFooter section.

Next, I set the height's of GroupHeader and GroupFooter sections = 0.

The import things are:

- vertical lines (box'es) cannot start in the PageHeader, they must start at top of GroupHeader

- vertical lines (box'es) cannot end in the Detail section, they must end at top of GroupFooter

And now, it works as I expected. Here is the [PDF example|http://www.zgadzaj.pl/temp/KIM_OK.pdf].

Thanks to your advices and support I was able to investigate this problem,

so thank you again for the help.

Regards,

Marek

Answers (0)