Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Same Field in the same Details Post Reply Post New Topic
Author Message
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Topic: Same Field in the same Details
     Posted: 18 Mar 2009 at 2:08pm
Hi everyone!!
 
Somebody pls help-me!!!
 
In my Report i have a field, that i need to repeat him in the same Detail, in the same line. But not, with the same data, depending on my Formula Field.
it is this possible?
 
Ps: Sorry, my English is terrible Tongue
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Mar 2009 at 2:09pm
Can you post a sample of what you mean?
IP IP Logged
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Posted: 18 Mar 2009 at 3:23pm
 
Something like this, without printing when the condition does not match
IP IP Logged
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Posted: 18 Mar 2009 at 4:52pm
I found another solution, and another question...
When I check "Suppress If Duplicated", the repeated fields become invisible, butt still there, leaving a white space in the report!!!
How can i make this fields not to be printed???
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 18 Mar 2009 at 5:23pm
Sorry can't see the image you posted so I am guessing that you have extra detail rows you want to suppress.
If so go into the Section Expert, highlight the detail row and select Suppress empty rows.
IP IP Logged
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Posted: 19 Mar 2009 at 5:42am
Not exactly, there's one Detail row with two Database field, side by side, this fields bring the same Data from SQL.
I want to print it dependig on my formula.
This is how is printing now:
test1
test2
test3        test3
test4
test5
 
i want to print like this:
test1        test3
test2
test3       
test4
test5
 
when it does not print, he leaves a blank space in the report...
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Mar 2009 at 7:10am
I am guessing that the two fields are each coming from a different table or the second column is your formula field. How are these joined and what is the formula you are using?
IP IP Logged
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Posted: 19 Mar 2009 at 7:20am
Both fields are the same. Just copy and paste a field comimg from my table
 
This is the formula i wrote in the "Suppress" check, on my field 1:
 
{F_PosicaoGeralDaCarteira.tp_Produto} <> 2
 
Field 2:
 
{F_PosicaoGeralDaCarteira.tp_Produto} = 2
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Mar 2009 at 7:46am

Sorry, not really sure you can do what you want it to but I am still having trouble grasping the entire process so I could be wrong. In you sample data, if the fields are the same field side by side and they are conditionally suppressed on the same field (one <>2 the other =2) shouldn't it have look like this?

test1
test2
              test3
test4
test5
 
Perhaps if you go to the start of what you have and what you are trying to do someone may be able to give you direction on how to acomplish that. Sorry.
IP IP Logged
ehy01
Newbie
Newbie
Avatar

Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
Quote ehy01 Replybullet Posted: 19 Mar 2009 at 7:53am
That's it!!! LOL
Looks exactly like this!!!
 
That empty spaces there, I do not want they printed...
Like this!!!
test1      test3
test2
test4
test5
 
 
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