How can i develope report in ssrs 2008 by avoid duplicates

• syamala.popuri

  Mr or Mrs. 500

  Points: 597

  More actions

  January 3, 2011 at 5:13 am

  #232826

  Hi,

  i have str proc calling in dataset of report 2008 results as fallows with column names.

  SERVER_NAMEEDITIONVERSIONLEVELdatabase_nametotal_size_mbunallocated_mbreserved_mbUser_NameRollname

  abcStandard (64-bit)9.00.3073.00SP2master913sql\srinireader

  abcStandard (64-bit)9.00.3073.00SP2master913sql\srinireader

  abcStandard (64-bit)9.00.3073.00SP2model913sqladmin\rohanwriter

  abcStandard (64-bit)9.00.3073.00SP2model913sqladmin\rohanreader

  abcStandard (64-bit)9.00.3073.00SP2model913sql\sriniadmin

  abcStandard (64-bit)9.00.3073.00SP2info913sql\sriniadmin

  abcStandard (64-bit)9.00.3073.00SP2info913sqladmin\rohanadmi n

  abcStandard (64-bit)9.00.3073.00SP2info913sqladmin\rohanwriter

  So when i click parameter servername i need to display servername,edition,version.level

  where as if i click dbname (dbname,reserverd,usernaem,rollname)should come

  in 1 st part showing servername,edition,version.level

  how can i avoid duplicate rows please let me know.

  [query level distincty not possible]

  Thanks in advance

  Sridevi

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  January 3, 2011 at 9:44 am

  #1268542

  Are you talking about cascading parameters? If so your second parameter dbname should be a separate query that uses the selection of the first parameter as a WHERE criteria.

  If you are talking about report data itself and you cannot use DISTINCT you should be able to group the data in the report design.