Skip to Content
0

crystal report blank spaceissue

Apr 11, 2017 at 02:35 PM

93

avatar image
I H

Hi.

I want to ask regarding blank space issue. the blank space keep appearing between last record in the details and report footer. let say i have 12 records in the details. the first 10 details appeared nicely on the first page, and the other 2 appear on the second page. since the second page only has 2 records, so, and the third page will have a quite big space between the details and the footer.

here i attach the image of the problem.

this picture show the last 2 records

and this one the last page that contains the blank space.

My question is,

1) can I remove the blank space and how to do it, since i already try to solve this issue. I tried to edit the margin or the size of each section, but once the number of records is changing, it will appear again based on how many record inside the details. I also tried to supress the details and create some formula, but it will only supress area that has details only, and does not supress the blank space.

OR

2)If i cannot remove the blank space, can i write some "notes" inside the blank space just like shown in the picture below?

with-notes.png

I really appreciate if somebody can help me regarding to this issue.

thank you,

and have a nice day. ;)

sap
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ian Waterman Apr 11, 2017 at 03:36 PM
0

Lots of causes so difficult to help

Check all groups - Go to change groups- Options

Are any set to keep together? Try turning off

In Section experts check all sections and turn off any which are checked as Keep together, New page before, or Print at bottom of page

Do this in a controlled manner so you can see which if any have an impact.

Failing that post a copy of your report with saved data causing issue and someone might be able to spot something.

Ian

Share
10 |10000 characters needed characters left characters exceeded
I H Apr 12, 2017 at 02:04 PM
0

Hi Ian.

Thank you for reply.

Actually I already done to uncheck the keep together option but it does not affect the blank space, it only affect the details section with record,

you mean, I need to upload the .rpt file here?

Thank you again Ian

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Assuming your data is not confidential, save data with report and upload a copy here.

Me or some one else can down load and then try to work out what is wrong.

Ian

0

unfortunately, the data inside is confidential. I'll try to copy the format of the crystal report into my test database and create a similar crystal report from there. once done, ill upload here.

Thank you Ian.

0
Vitaly Izmaylov
Apr 13, 2017 at 11:09 PM
0

Have you tried with "Clamp Page Footer" check box in Section Expert > Page Footer ?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Vitaly.

Thank You for your response.

I just applied your suggestion, but it change nothing.

Thank You again Vitaly.

0