Post reply

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

  • March 1, 2011 at 4:24 pm

    #246320

    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 5:58 pm

    #1293298

    Hello varunkum,

    I think, you can use 'ReportItems' collection to solve this issue.

    First of all you need to note the textbox names of the totals or rename the SUM(CSNSTARTS) text box as "txtTotalCS" and SUM(DMNSTARTS) text box as "txtTotalDM"

    Then you can write an expression as below:

    = Reportitems!txtTotalCS.Value + Reportitems!txtTotalDM.Value

    Hope this works for you.

    Regards,

    Ranj

  • March 2, 2011 at 7:57 am

    #1293520

    = Reportitems!txtTotalCS.Value + Reportitems!txtTotalDM.Value

    TotalCs.value and TotalDm.value are from different datasets and they won't let me sum up. I need syntax for including datasets also.

  • March 2, 2011 at 8:22 am

    #1293547

    Take your 2 datasets and make them a single dataset with a UNION or another way of your choosing. Group by CS & DM then do totals at the bottom.

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

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