Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Topic: Can we suppress or Delete a single Row in a report Posted: 22 Sep 2009 at 8:22am
Hello Folks,
I have this urgent requirement where i need to get rid of couple of rows from the report which are probably showing negative amounts for a particular case. I was wondering if there is anyway i can get rid of these rows by suppressing or something like that. can anyone please throw some light on this.
Joined: 30 Jan 2008
Location: United States
Online Status: Offline
Posts: 6
Posted: 22 Sep 2009 at 8:47am
If the amounts are showing negative, you could suppress that line of detail if the amount is < 0. Go to the section expert and set that as a formula to suppress. {your.field} < 0. If your detail is not broken down into multiple detail sections, just go to the select expert within the report and set that field to not include anything < 0.
Joined: 25 Aug 2009
Location: United States
Online Status: Offline
Posts: 166
Posted: 22 Sep 2009 at 8:56am
wow thanks for the quick reply. I went to each column and suppressed each column based on the condition u said and was able to suppress all the rows which are negative. Another help i need is I have Total column in the Footer section which includes the sum of all the rows which obviously is taking the negatives one also,Hw do i get rid of the negatives one in the total sum.
Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Posted: 22 Sep 2009 at 11:17am
Here is another possibility. You could try a creating a new RunningTotal and set it (Use the formula function in the dialog)to increment (add) when the number is greater than 0. ( {tbl1.field1}>0) You would use it in place of the Summary or a formula.
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
IP Logged
