| Author |
Message |
ehy01
Newbie
Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
|

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 
|
IP Logged |
|
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|

Posted: 18 Mar 2009 at 2:09pm |
|
Can you post a sample of what you mean?
|
IP Logged |
|
ehy01
Newbie
Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
|

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

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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|

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 Logged |
|
ehy01
Newbie
Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
|

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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|

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 Logged |
|
ehy01
Newbie
Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
|

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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|

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 Logged |
|
ehy01
Newbie
Joined: 29 Jan 2009
Location: Brazil
Online Status: Offline
Posts: 20
|

Posted: 19 Mar 2009 at 7:53am |
That's it!!!
Looks exactly like this!!!
That empty spaces there, I do not want they printed...
Like this!!!
test1 test3
test2
test4
test5
|
IP Logged |
|
|
|