none
Collapsing multiple lines from SQL database into a single line in SSRS

    Question

  • I have table in a database that look like this:
    Security Qty PNL Broker
    A 100 10 X
    A 120 20 Y
    I am creating a report in SSRS with only the security, qty and pnl fields. I want
    the report to look like this:
    Security Qty PNL
    A 220 30
    However, since the security is in 2 different lines in the database, my report
    looks like this:
    Security Qty PNL
    A 100 10
    A 120 20
    Is there a solution to this problem?
    Wednesday, October 02, 2013 8:44 PM

Answers

All replies