cancel
Showing results for 
Search instead for 
Did you mean: 

Report layout get spoiled with multiline data.

Former Member
0 Kudos

Hello Friends,

My report's layout get spoiled after setting "Can Grow" property (Fileds) and "Extend To Bottom Of Section" property (line) to true.

Here is the description of my report and the issue.

I have a report with a sub report at report footer section. I am using Crystal Report 13 for Visual Studio 2010. Some fields and lines for main report are dynamic and added using code (RAS .NET SDK).

In my reports some fields have multi line data. To manage that I decided to set "EnableCanGrow" property for each field objects and "Enable Extend To Bottom Of Section" property for each line object to True.

But after using this the layout get completely spoiled. When fields have single line data the layout looks fine, and if it have 2 or 3 lines the half part of some records displays on first page and half on next page.

When field have data which is more then 3 lines it adds extra rows at the bottom of the detail section.

I also tried to set Visible record numbers but it is also work when data is not too long. All the process which I have described above is creating a mess and because I am getting following problems:

1. The structure for detail section get spoiled and shows one record in tow pages in two parts (for both main and sub reports).

2. I also get line breaks between random records.

3. When my sub report have single line data ... the layout look fine but it does not display last or closing line of the report at the end of the page, but I can see it when I open sub report individual.

Below screen shots can show 1st and 2nd issue:

And this will show 2rd issue:

I am not getting the reason, why the layout get spoiled. Why it works fine with single line data and become a mess with multiline data.

Please help me and guide me what should I do.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Friends,

Setting top margin to '0' for fields that have multi-line values, solved my 1st problem. But I can't understand the reason.

Suppose I have a field 'Test' and it has multi-line data. I am giving it top margin 150 twips and the height of detail section is 500 twips. So it the the fields will grow and become 700twips in height then the height for detail section should increase to 150 + 700 (Top + FieldHeight) = 850 twips. but still it is getting only 700 twips height for detail section and showing some part of record in first page and some part on next page.

Why?

The solution I have applied is not the perfect answer to the problem. Why it is not counting FieldObject Top margin in height of section.

And the 3rd number issue, it occurs when I check "Move to Bottom of Section when Printing" for the horizontal line placed at the bottom of detail section of Sub report. As I have mentioned in my post that some of my fields have data with multiple lines and I that can increase height of the detail section. I cannot set "Move to Bottom of Section when Printing" to false.

I tried an alternative to overcome the 3rd problem that I provided bottom border to my sub report. But it is not looking good and showing gap

Friends, please check it and guide me. I really need your help

Thanks.

Former Member
0 Kudos

Hello Friends,

For the 3rd problem I tried an alternative solution (Jugad ), I added one more section in detail section , after the previous one and placed the line object to it. But I still don't know why the line object in detail section was not visible in main report.

But the 1st and 2nd issues still there, I cannot remove top margin from my fields. Please please please reply me.

Thanks.

former_member183750
Active Contributor
0 Kudos

There is so much "stuff" here, I get lost.

Rules of Engagement state that only one issue should be posted per thread. Please create new thread(s), one issue per.

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

Former Member
0 Kudos

I am facing three issues related to report layout and all because of multiline data. What is wrong with that if I post related issues in one thread?

Former Member
0 Kudos

Ok I will post them in separate threads. I hope after doing that I will get reply form you all.

Answers (0)