Tuesday, October 18, 2011

Fix :Duplicate data and RunningTotal in crystal report

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.

No comments:

Post a Comment