Search results for query: *

I managed to get rid of the extra pages from apearig within the report as well the blanks lines appear at the end. I used the below two. Under section expert formula for Suppress (No Drill-Down) not onlastrecord Under section expert formula for Print at Bottom of Page Pagenumber =...

I tried inserting the formula in a group footer. I checked New Page After with a formula not onlastrecord I also checked Print at bottom of Page and Keep Together. But now the detail rows are page breaking. Initially I had two row in one page but now the rows are split and I have just...

I tried the above but I still have it printing on each page. I also tried the formula below for Print at Bottom of Page Pagenumber = Totalpagecount But still no luck. Thanks for your help. Regards, Anita

Can I force the section to print at the end by checking for page number? If page number is the last page then print the section? Do you know the exact formula I can use? Thanks. Regards, junction123

Hi, How can I prevent the details section from printing on each page? I want the section to print at end of page. Is there a code I can use or just check print at bottom of page? Thanks for your help Regards, 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...

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...

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...

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...

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...

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

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...

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

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...

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...

LB, Any idea why the formula is not working? Thanks again for your help. Regards, 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?

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...

The Text Box is just blank, no text. Should I enter some text in the Text Box? Please clarify. Thanks for your help. junction123

I changed the formula to replicatestring(chr(13),tonumber({Detail.ExtraLines})) Iinserted the formula in the textbox. I checked CanGrow. I just have one formula When you say "with the text" what do you mean? Do I need to add Detail.ExtraLines in the textbox and the formula @FooterTextLines...