Post reply

SSRS help...Its not help in SQL....

  • March 1, 2011 at 3:56 pm

    #232774

    I need sum of (Total of Newstarts CS) and (Total of Newstarts DM) in a separate row versus the E,3,W,W5,SS,......

    Newstarts CS AND Newstarts DM come different datasets in the same report

    I did something like "=Sum(Fields!CSNSTARTS.Value, "DataSet1") + Sum(Fields!DMNSTARTS.Value, "NewstartsDM")" but this gave me the sum of all the fields.

    I basically i want a new row with E = 3125 + 18, 3 =140+0, W5 = 9+0,......so on.

    I guess it is something to do in SSRS and not Writing a SQL query ???

  • March 1, 2011 at 4:20 pm

    #1293280

    Not that you won't receive help here...but there are dedicated SSRS forums on SSC:

    http://www.sqlservercentral.com/Forums/Group416.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 1, 2011 at 5:18 pm

    #1293287

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1071665-1633-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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