Post reply

Duplicates

  • June 2, 2009 at 5:56 pm

    #201010

    i am working on a report where the data is displayed based on person

    say for example

    name of the person amount

    person A $100

    $100

    sum of person A $100

    if the amount is same i want to eliminate the amount in the sum.

    how do i achieve it Please let me know?

  • June 3, 2009 at 2:16 am

    #1003818

    Hi.. 🙂

    Regards,

    Please go to visibility property of the textbox where you are trying to calculate the sum.

    Example:

    Textbox name where you are calculating the sum is : SumTextBox

    Textbox name which holds the actual value : ActualTextBox

    Keeping Visible Property Expression as:

    =IIf(ReportItems!SumTextBox.Value = ReportItems!ActualTextBox.Value,true,false)

    This should help to resolve this issue.

    Thanks alot,

    Niraj 🙂

  • June 4, 2009 at 5:46 am

    #1004541

    Every Textbox has property Hide Duplicates.

    This amount is sum for person A, then you must have Group for person.

    Set the Hide Duplicate property to Person's group Name for example "grpPerson". In fact when you will click on drop down which will come after Hide duplicate option of Textbox then that group name will appear in that drop down.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply