Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Field getting invisible when in Report Footer Post Reply Post New Topic
Author Message
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet Topic: Field getting invisible when in Report Footer
     Posted: 09 Apr 2010 at 7:46am
Hello!
 
I have a problem. I'm creating a report with a Representation Field (returns US$, R$, etc). But when i placed the field in the Report Footer it gets invisible.
 
I really don't know what to do!
Luiz Fernandes
lfernandesfotos@hotmail.com
IP IP Logged
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet Posted: 09 Apr 2010 at 8:04am
I think that it happens because some register has null values. There is a way to get the first value that is not null???
 
I'm working in a one page report and need to have a fix number of details. So the filler has all values as null.
Luiz Fernandes
lfernandesfotos@hotmail.com
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Apr 2010 at 8:04am
placing a data field in the report footer will display only the last record in your data set. If that record happens to be NULL or "" it will appear as that (blank).
IS this some sort of calculated or summarized field?
IP IP Logged
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet Posted: 09 Apr 2010 at 8:11am
No, but it is a field that attends the Report Header and  Report Footer.
 
It is an invoice which must bear the date of issue and value, and that value must be accompanied by currency symbol. This field is the Currency Simbol, but the date of issue is with the same problem.
 
I think that is better change the report than the stored procedure.
Luiz Fernandes
lfernandesfotos@hotmail.com
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 09 Apr 2010 at 8:19am
can you use a MAXIMUM or MINIMUM value from your record set?
IP IP Logged
lfernandesfotos
Newbie
Newbie
Avatar

Joined: 02 Jul 2009
Location: Brazil
Online Status: Offline
Posts: 25
Quote lfernandesfotos Replybullet Posted: 09 Apr 2010 at 9:18am
It works!
 
Thanks!
Luiz Fernandes
lfernandesfotos@hotmail.com
IP IP Logged
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