Post reply

How can i develope report in ssrs 2008 by avoid duplicates

  • 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

  • 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.

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

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