Modify report to suppress column headers when data extend in next page

[junction123]

Hi,

I am using Crystal 9.0. I have to make modifications to the report as below.

There will be extra blank lines at the end of the report for users to have the ability to enter text. In this case, when the report flows to the next page owing to the extra blank lines, then the page header should be suppressed and only the column headers should be displayed.

Is this possible to do via section expert or a formula.

Thanks in advance for your help.

Regards,
junction123

 

[lbass]

I thought you had a text box with something like:

"Write in your name"

You would then add the formula at the end of the text. But you can just add the formula by itself without a text box, too, and it will create space to write. Just format it to "can grow".

-LB

 

[junction123]

The Text Box is just blank, no text.

Should I enter some text in the Text Box? Please clarify.

Thanks for your help.

junction123

 

[lbass]

If you need a text box, just add the formula to it.

-LB

 

[junction123]

I tried both.

A blank Text Box and inserted the formula in the text box.

No text box and just inserted the formula.

It does not work.

I entered number 5 in the front end. I should see 5 blank lines.

Maybe there is no space? and why cannot it go to next page?

Thanks again for your help. This seems to be very tricky though it appears simple.

I maybe doing something wrong.

Regards,
junction123

 

[junction123]

I have

Section5 (PageFooter a) Displays Page N of M

PageFooterSection1 (PageFooter b) Displays another footer via a formula


PageFooterSection2(PageFooter c) has the formula for teh blank lines

My suspicion is that there is no space?

Any ideas?

 

[junction123]

LB,

Any idea why the formula is not working?

Thanks again for your help.

Regards,
junction123

 

[junction123]

As a test, I put the formula in the Report Footer instead of Page Footer. I also checked Print at Bottom under Section Expert.

In Crystal Viewer, I see that the text box and formula move to a new page and I can see the text box.

However I cannot edit the box.

I export to pdf and I see a blank page at the end but no editable box.

Do I need to specify a length or size?

Could it be that we need another version of Adobe that allows editing when exporting?
Not sure how crystal adn Adobe talk to each other or whether the version I have allows editing?

Also should I try exporting to word? I do not see an option for word though as I am using a meta data application and PDF is teh only option available.

Any more help is appreciated. Thanks.

Regards,
junction123

 

[junction123]

I did ome research and found out that I have Adobe 8.o which is adobe reader. Acrobat (9.0 or higher) allows some editing which is what our users have.

So there is no way I can test whether the formula works and I keep thinking that it does not work.

I talk to our IT systems and confirmed that I would need Acrobat which has editing features adn I will be able to see the Blank line text box.

Please let me know if this makes sense.

Thanks for your help.

Best Regards,
junction123

 

[junction123]

Sorry typographical error in my previous post. I meant to say that "I did Some research

 

[junction123]

LB,

I was told to export as a word doc for testing purpose as PDF cannot confirm that the formula works.

Your formula works fine but I have a question. The text box although has Can Grow checked, allows only two lines of text.

If I enter more then the footer text is not displayed as it is outside the text box.

How can I fix this for footer >2 until 50 lines of text?

Thanks a lot for all your help. Great help.

Best Regards,
junction123

 

[junction123]

Should I put the formula in a Report Footer and check Print at Bottom of Page?

Is there a limit on the number of lines within a page footer or is there a limit on the number of page footer within a report?

Thanks for your help.

Regards,
junction123

 

[junction123]

One more question.

I want teh Can Grow to restrict teh number of blank lines via a formula.

So if Detail.ExtraLines has a Value of 3, then Can Grow should not keep extending the text box. I want the number of blank lines available for entry to be 3.

Currently just checkign Can Grow lets me keep on typing. There is also a limit available for the maximum number of line and I can have 50, while 0 is unlimited.

Please advise on how to proceed.

Thanks for your help.

Best Regards,
junction123

 

[junction123]

I found an approach but I believe it is a very sloppy and ugly approach.

I set the limit as 1 for the number of lines in Can Grow.

I insert two text boxes with the formula. This allows me to enter two footer text lines in each of the text box.

This means that I will have to have 50 text boxes in the section and each have the limit as 1 for the number of lines.

So when I enter 1, it just displays one text box and I can enter one footer text line. If I enter 2, it displays two text box and I can enter two footer lines of text and so on.

Do you know of a more efficient formula that I can use in Can Grow.

Thanks for your help.

Regards,
junction123

 

[junction123]

I tried something like this for the formula @FooterTextLInes which is in a text box.

But when I pass 1, the text box does not restrict to one line of footer text entry.

For a value of 1 entered in the front end, I get two lines of text entry.

For a value of 2 entered in the front end, I get 4 lines of text entry.

For a value of 3 entered in the front end, I get 9 lines of text entry.

Why is this happening?



IF {Detail.ExtraLines} = '1' THEN
replicatestring(chr(13),tonumber({Detail.ExtraLines}))
ELSE
IF {Detail.ExtraLines} = '2' THEN
replicatestring(chr(13),tonumber({Detail.ExtraLines})) + replicatestring(chr(13),tonumber({Detail.ExtraLines}))
ELSE
IF {Detail.ExtraLines} = '3' THEN
replicatestring(chr(13),tonumber({Detail.ExtraLines})) + replicatestring(chr(13),tonumber({Detail.ExtraLines})) +
replicatestring(chr(13),tonumber({Detail.ExtraLines}))


Thanks again for your help.

junction123

 

[lbass]

I don't know what you are doing. This is fairly simple. All you need to do is place one formula on the report and format it to "can grow". Please remove everything you have done and just add this formula:

replicatestring(chr(13),tonumber({Detail.ExtraLines}))

-LB

 

[junction123]

LB,

The only issue I found was that for a value of 1 passed, I can enter one line of text but I am also able to enter another line of text which is partially visible.

For a value of 2, I am able to enter a third line of text which is partially visible.

And the same is teh case for a value of 3 for 3 lines of footer text.

Should I decrease the height of teh text box?

Regards,
junction123

 

[lbass]

You can change the formula to:

replicatestring(chr(13),tonumber({Detail.ExtraLines})-1)

...but I cannot think of a way to limit the can grow to that number of lines. There isn't a conditional option for the number of lines--it either grows or doesn't.

-LB

 

[junction123]

I tried putting the same in the detail section because when I have 10 + lines it does not fit and overlaps teh detail section.

However , when I put it in details section , the footer text appears in each page. How can I stress that it should print at end of the report only?

Thanks for your help.

Regards,
junction123

 

[lbass]

I don't know what you are saying. Sections do not overlap each other unless you format them to do that.

What footer text?! Any text you want only at the end of a report should be in the report footer.

-LB