SQL Server Performance

Report Builder help

Discussion in 'SQL Server 2005 Reporting Services' started by khan, Oct 22, 2008.

  1. khan New Member

    Report Builder help explains how to remove Dubplicates but there is no way to get to this option can anyone help.Depending on the subject of your report, you may want to keep or remove duplicate data items. For example, if customers have orders with products and you want to count the number of products per customer, you need to decide whether you want to count products purchased multiple times by the same customer or only count distinct products purchased per customer.
    Use the Remove Duplicates dialog box to indicate that you want to keep all of the duplicate data or to remove some or all of the duplicate data. Each set of duplicate data is grouped by heading. The number of options below each heading group depends on the number of duplicates. To open the Remove Duplicates dialog box, you need to expand the formula in the Define Formula dialog box and click Remove duplicates of. ( <---can't find this option)
    Options

    Keep all duplicates of <entity name> for each <entity name> Select to keep the existing duplicates for the specified entities. By default, this option is selected. Remove duplicates of <entity name> for each <entity name> Select to remove the duplicates between the specified entities.
  2. satya Moderator

    To open the Remove Duplicates dialog box, you need to expand the formula in the Define Formula dialog box and click Remove duplicates of.
    ... based on the BOL's explanation you need to define the forumal within that DefineForuma dialog box, or http://msdn.microsoft.com/en-us/library/aa337326(SQL.90).aspx fi
  3. khan New Member

    Satya,
    Thanks for your response but do you have the screen shot of this option ? when i expand the formula in the Define Formula dialog box "Remove duplicates of" is NOT there is this specific to Enterprise Edition only coz we have standard edition at present.
    Thanks

Share This Page