Print Page | Close Window

Field Wont Display

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20096
Printed Date: 28 Apr 2024 at 7:11pm


Topic: Field Wont Display
Posted By: Wearing
Subject: Field Wont Display
Date Posted: 08 Oct 2013 at 5:44am
I have a memo field that wont display in the footer of my report, yet if I move the field to the details section it does display. I have other items such as formulas and text boxes that do display in the footer.  Any idea how to get the memo field to display?


Replies:
Posted By: DBlank
Date Posted: 08 Oct 2013 at 1:04pm
assuming this is a page footer...
if the memo field is expanding to make the footer too large to fit on one page (Including header sizes) it cannot logically be displayed. Set it to cannot grow and see if it displays ok (just in a truncated format).

Posted By: Wearing
Date Posted: 09 Oct 2013 at 3:05am
yes its in the page footer.  I changed it to cannot grow and it still wont display.

Posted By: DBlank
Date Posted: 09 Oct 2013 at 4:12am
what do you want it to do if it cannot fit on a page? Do you only want to display the first X number of charatcters or words?
If so create a formula field to truncate it and use that for the display.

Posted By: Wearing
Date Posted: 09 Oct 2013 at 4:33am
no that didn't work.  The funny thing is that if I put the field in the header or details section it works but not in the footer??

Posted By: DBlank
Date Posted: 09 Oct 2013 at 4:36am
is this a formula field or just a DB field?

Posted By: Wearing
Date Posted: 09 Oct 2013 at 4:39am
I've tried it both ways...with the same result.  Would prefer it to be the DB field

Posted By: DBlank
Date Posted: 09 Oct 2013 at 4:54am

place it in the detail section-

what displays in the very last detail row on that page?

Posted By: Wearing
Date Posted: 09 Oct 2013 at 4:59am
If I place it in the detail section than it keeps bumping itself in front of the comment field..no matter where I put it, which I don't want it to do

Posted By: DBlank
Date Posted: 09 Oct 2013 at 5:15am

my guess is that the last row on a the page has a blank value fo that field.

when you drop a field into a footer it displays the data from the last row that was printed before that footer was printed. So for a group footer is is the last row in the group, for a page footer it is the last row on that page.
WHen you moved it into the a header for testing you also altered the result because if you place a DB field in a header it prints the value from the first row printed after the header is printed. For a page header it prints the value from the first row on the page, in a group header the first row of that group. If you change the sort order inside the group you also can change what value is being printed in the header or footer.
You may be able to use a minimum(field) or maximum(field) to accomplish what you want. Hard to say as I dont know your grouping or data set.

Posted By: Traceyc
Date Posted: 15 Oct 2013 at 3:08pm
The page footer is not dynamic in crystal reports (not up to CR2011), so even if you set the field to 'can grow', if the text/formula or field box is too small to display the data, if will not 'expand' so you can see it in the page footer. Try making the page footer bigger and see if your data appears when given enough space. If it does, then that is the issue and no way to correct this, other than making the page footer big enough to fit the actual data.

Posted By: Wearing
Date Posted: 16 Oct 2013 at 2:52am
The page footer is quite large.  The data that I'm trying to make appear is only one little sentence "Min Order Qty is 25".  If I drag and drop the field in almost any other area it appears, Just not in the footer and not in the proper order if I put it in the details.


Print Page | Close Window