RunningValue help!!

the running value works on the preview of reporting services but when
i run the report on the server it displays zero all the time. plz tell
me how to solve it
thanx in advancei figured out the problem !!!

RunningValue / RowNumber errors

Hi,
I hope someone can help me with this problem. I'm trying to create a running
total using the RunningValue function in SQL reporting services 2005. the
code is below:
=RunningValue(Fields!company_id.Value, count, "CompanyID")
Regardless of whether i include it in my report or if it is just created but
not user i get an error. The error is one of the Send Don't Send microsoft
ones which then proceeds to shut down Visual studio 2005. This happens
whenever the report is previewed without fail.
Has anyone encountered this before and if so could they shed some light on
the problem.
Many thanks in advance,
GrantOn further investigation, it appears that the problem only occurs if i
include the RunningValue code in a calculated filed. If entered directly into
the table it works fine. Could this be a bug in Reporting services?
Grant
"GSwan" wrote:
> Hi,
> I hope someone can help me with this problem. I'm trying to create a running
> total using the RunningValue function in SQL reporting services 2005. the
> code is below:
> =RunningValue(Fields!company_id.Value, count, "CompanyID")
> Regardless of whether i include it in my report or if it is just created but
> not user i get an error. The error is one of the Send Don't Send microsoft
> ones which then proceeds to shut down Visual studio 2005. This happens
> whenever the report is previewed without fail.
> Has anyone encountered this before and if so could they shed some light on
> the problem.
> Many thanks in advance,
> Grant

Running Totals

Hi,
Any ideas for getting the running total in reporting services.
Group Amt Detail(lines)
---
A 1000
1
2
B 2000
3
4
--
Total 3000
I need to do totals on report. Any ideas how to get the Totals = 3000 ?
like in crystal report we have the running totals formula which we can get
3000.
I know how to do in the SP or creating the subreport with distinct sql
statement. But I need help in creating running totals on the reporting
services side.
ThanksHi,
Use Sum(Fields!Amt.value) in the group footer.
Jasvinder
"sarath" wrote:
> Hi,
> Any ideas for getting the running total in reporting services.
> Group Amt Detail(lines)
> ---
> A 1000
> 1
> 2
> B 2000
> 3
> 4
> --
> Total 3000
> I need to do totals on report. Any ideas how to get the Totals = 3000 ?
> like in crystal report we have the running totals formula which we can get
> 3000.
> I know how to do in the SP or creating the subreport with distinct sql
> statement. But I need help in creating running totals on the reporting
> services side.
> Thanks
>
>
>
>|||HI,
If I do -- Sum(Fields!Amt.value) I will be getting 6000. Let me put the
question in this way.
Group Amt Detail(lines)
---
A
1000 1
1000 2
B
2000 3
2000 4
--
Total 6000 -- I need to get 3000 ? Can I know how we can get this ?
Thanks
"Jasvinder" wrote:
> Hi,
> Use Sum(Fields!Amt.value) in the group footer.
> Jasvinder
> "sarath" wrote:
> > Hi,
> >
> > Any ideas for getting the running total in reporting services.
> >
> > Group Amt Detail(lines)
> > ---
> > A 1000
> > 1
> > 2
> >
> > B 2000
> > 3
> > 4
> > --
> > Total 3000
> >
> > I need to do totals on report. Any ideas how to get the Totals = 3000 ?
> > like in crystal report we have the running totals formula which we can get
> > 3000.
> >
> > I know how to do in the SP or creating the subreport with distinct sql
> > statement. But I need help in creating running totals on the reporting
> > services side.
> >
> > Thanks
> >
> >
> >
> >
> >
> >
> >
> >

Running total

Good day,
I have a table in SQL that I am reporting on. It contains a few different
fields. One of them is the running total for the month. What I need is a
report that shows both this running total field as well as each days value.
Each days values can be calculated by taking day 1's running total and minus
it from day 2's value to give day 1's day value. Therefore the last running
total value will not have a actual day value. Can anyone help me please, I am
battling and have been for quite some time.
Any help would be greatly apreciated.
ThanksIf you group by the day, you should be able to just bring in the sum for
that day & keep the running total separate.
If that doesn't work, you could use an IF statement in your sum to display
that days total.
EX:
= SUM(IIF(( CONDITION) , Fields!SalesAmount.Value , Nothing))
Where condition is a formula that looks for the current day.
Hope this helps,
MB
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:1695C145-4EAD-42F1-9C6C-AECC8C500C91@.microsoft.com...
> Good day,
> I have a table in SQL that I am reporting on. It contains a few different
> fields. One of them is the running total for the month. What I need is a
> report that shows both this running total field as well as each days
> value.
> Each days values can be calculated by taking day 1's running total and
> minus
> it from day 2's value to give day 1's day value. Therefore the last
> running
> total value will not have a actual day value. Can anyone help me please, I
> am
> battling and have been for quite some time.
> Any help would be greatly apreciated.
> Thanks|||Hi Mark,
Thanks for the help but I am still stumped. the report will show records for
a whole month for instance and each day has to calculate the cost for that
day from the running total. Can I still use your suggestion, can you possibly
elaborate?
Thanks
"Mark" wrote:
> If you group by the day, you should be able to just bring in the sum for
> that day & keep the running total separate.
> If that doesn't work, you could use an IF statement in your sum to display
> that days total.
> EX:
> = SUM(IIF(( CONDITION) , Fields!SalesAmount.Value , Nothing))
> Where condition is a formula that looks for the current day.
> Hope this helps,
> MB
> "PLSH" <PLSH@.discussions.microsoft.com> wrote in message
> news:1695C145-4EAD-42F1-9C6C-AECC8C500C91@.microsoft.com...
> > Good day,
> >
> > I have a table in SQL that I am reporting on. It contains a few different
> > fields. One of them is the running total for the month. What I need is a
> > report that shows both this running total field as well as each days
> > value.
> > Each days values can be calculated by taking day 1's running total and
> > minus
> > it from day 2's value to give day 1's day value. Therefore the last
> > running
> > total value will not have a actual day value. Can anyone help me please, I
> > am
> > battling and have been for quite some time.
> >
> > Any help would be greatly apreciated.
> >
> > Thanks
>
>|||Hi Mark again,
Not to worry managed to sort it out. Found the previous function and works
like a charm, never thought it would be such an easy command, was expecting
something much more complex.
Thanks
"PLSH" wrote:
> Hi Mark,
> Thanks for the help but I am still stumped. the report will show records for
> a whole month for instance and each day has to calculate the cost for that
> day from the running total. Can I still use your suggestion, can you possibly
> elaborate?
> Thanks
> "Mark" wrote:
> > If you group by the day, you should be able to just bring in the sum for
> > that day & keep the running total separate.
> > If that doesn't work, you could use an IF statement in your sum to display
> > that days total.
> > EX:
> > = SUM(IIF(( CONDITION) , Fields!SalesAmount.Value , Nothing))
> > Where condition is a formula that looks for the current day.
> > Hope this helps,
> > MB
> >
> > "PLSH" <PLSH@.discussions.microsoft.com> wrote in message
> > news:1695C145-4EAD-42F1-9C6C-AECC8C500C91@.microsoft.com...
> > > Good day,
> > >
> > > I have a table in SQL that I am reporting on. It contains a few different
> > > fields. One of them is the running total for the month. What I need is a
> > > report that shows both this running total field as well as each days
> > > value.
> > > Each days values can be calculated by taking day 1's running total and
> > > minus
> > > it from day 2's value to give day 1's day value. Therefore the last
> > > running
> > > total value will not have a actual day value. Can anyone help me please, I
> > > am
> > > battling and have been for quite some time.
> > >
> > > Any help would be greatly apreciated.
> > >
> > > Thanks
> >
> >
> >sql