You can prevent duplicate rows by right clicking on details section and
select section expert. In section expert check suppress and click on formula
button ( x+2) of suppress and use this formula to check the duplicate values
{field_Name} = Next( {field_Name} )
its going to suppress the next row if the values of the field are same , now
if you to check for multiple columns use same formula with AND operator to
check for each column values.
like this :
{field_Name} = Next( {field_Name} ) and {field_Name2} = Next( {field_Name2} )
If you have a running total at the end of the table ,Right click on the
running total variable and Check Evaluate on Change of a field and select
field ID or name according to your table.
Hope this will help you.
select section expert. In section expert check suppress and click on formula
button ( x+2) of suppress and use this formula to check the duplicate values
{field_Name} = Next( {field_Name} )
its going to suppress the next row if the values of the field are same , now
if you to check for multiple columns use same formula with AND operator to
check for each column values.
like this :
{field_Name} = Next( {field_Name} ) and {field_Name2} = Next( {field_Name2} )
If you have a running total at the end of the table ,Right click on the
running total variable and Check Evaluate on Change of a field and select
field ID or name according to your table.
Hope this will help you.
No comments:
Post a Comment