Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Field Wont Display Post Reply Post New Topic
Page  of 2 Next >>
Author Message
Wearing
Newbie
Newbie


Joined: 16 Aug 2012
Online Status: Offline
Posts: 11
Quote Wearing Replybullet Topic: Field Wont Display
    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?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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).


Edited by DBlank - 08 Oct 2013 at 1:04pm
IP IP Logged
Wearing
Newbie
Newbie


Joined: 16 Aug 2012
Online Status: Offline
Posts: 11
Quote Wearing Replybullet Posted: 09 Oct 2013 at 3:05am
yes its in the page footer.  I changed it to cannot grow and it still wont display.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Wearing
Newbie
Newbie


Joined: 16 Aug 2012
Online Status: Offline
Posts: 11
Quote Wearing Replybullet 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??
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Oct 2013 at 4:36am
is this a formula field or just a DB field?
IP IP Logged
Wearing
Newbie
Newbie


Joined: 16 Aug 2012
Online Status: Offline
Posts: 11
Quote Wearing Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Oct 2013 at 4:54am

place it in the detail section-

what displays in the very last detail row on that page?
IP IP Logged
Wearing
Newbie
Newbie


Joined: 16 Aug 2012
Online Status: Offline
Posts: 11
Quote Wearing Replybullet 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
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.


Edited by DBlank - 09 Oct 2013 at 5:17am
IP IP Logged
Page  of 2 Next >>
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.