Row totals?
in [Reports]
|
Prev: Access denied with ReportViewer in IIS 7.5
Next: Add Function code to SSRS to PARSE the URL and use result in report qry
From: Linn Kubler on 27 Apr 2010 11:21 Hi, This seems like it's probably real easy but I am struggling. I have a report with a dozen or more columns, the first few are text and date data but the last 5 are numeric and I'd like to put a total at the end of each row. What's the best way to do this in RS? Can I create a formula in a calculated cell or should I do it in the initial dataset query? SQL 2005 Thanks in advance, Linn
From: Linn Kubler on 27 Apr 2010 12:53 Update... I created a new column and just simply added the fields of interest and that seems to be working. If there is a more elegant solution I'm all ears. Next issue though is that I also want column totals in the footer, not much of a problem, however, I am not sure how to total the new column I entered. Suggestions? Thanks, Linn "Linn Kubler" <lkubler(a)chartwellwisc2.com> wrote in message news:erX9T1h5KHA.3292(a)TK2MSFTNGP06.phx.gbl... > Hi, > > This seems like it's probably real easy but I am struggling. I have a > report with a dozen or more columns, the first few are text and date data > but the last 5 are numeric and I'd like to put a total at the end of each > row. What's the best way to do this in RS? Can I create a formula in a > calculated cell or should I do it in the initial dataset query? > > SQL 2005 > > Thanks in advance, > Linn > >
From: Uri Dimant on 28 Apr 2010 01:29
Linn Pehaps it is possible to have a calculated column in T-SQL "Linn Kubler" <lkubler(a)chartwellwisc2.com> wrote in message news:%23oMKooi5KHA.1888(a)TK2MSFTNGP05.phx.gbl... > Update... I created a new column and just simply added the fields of > interest and that seems to be working. If there is a more elegant > solution I'm all ears. > > Next issue though is that I also want column totals in the footer, not > much of a problem, however, I am not sure how to total the new column I > entered. Suggestions? > > Thanks, > Linn > > "Linn Kubler" <lkubler(a)chartwellwisc2.com> wrote in message > news:erX9T1h5KHA.3292(a)TK2MSFTNGP06.phx.gbl... >> Hi, >> >> This seems like it's probably real easy but I am struggling. I have a >> report with a dozen or more columns, the first few are text and date data >> but the last 5 are numeric and I'd like to put a total at the end of each >> row. What's the best way to do this in RS? Can I create a formula in a >> calculated cell or should I do it in the initial dataset query? >> >> SQL 2005 >> >> Thanks in advance, >> Linn >> >> > > |