Runningvalue in graph

g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
The
expression for the chart 'chart1' has a scope parameter that is not valid
for RunningValue, RowNumber or Previous. The scope parameter must be set
to
a string constant that is equal to the name of a containing group within
the
matrix 'chart1'.
I get that error when trying to make a running value in a chart.
I need to have the months summed together month for month to show the
progress between different fiscal years and budget, now it shows each
months
values.
this is the expression
=RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
Chart1 is the name of the chart, I also tried with the
chart1_CategoryGroup1
in the region value but same result !
Jack
--
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 45077 spam-mails.
Betalende brugere får ikke denne besked i deres e-mails.
Hent gratis SPAMfighter her: www.spamfighter.dkIs this RS 2000? RunningValues in charts are not supported in RS 2000, only
in RS 2005.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
> The
> expression for the chart 'chart1' has a scope parameter that is not valid
> for RunningValue, RowNumber or Previous. The scope parameter must be set
> to
> a string constant that is equal to the name of a containing group within
> the
> matrix 'chart1'.
> I get that error when trying to make a running value in a chart.
> I need to have the months summed together month for month to show the
> progress between different fiscal years and budget, now it shows each
> months
> values.
> this is the expression
> =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> Chart1 is the name of the chart, I also tried with the
> chart1_CategoryGroup1
> in the region value but same result !
> Jack
>
>
> --
> Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> Den har indtil videre sparet mig for at få 45077 spam-mails.
> Betalende brugere får ikke denne besked i deres e-mails.
> Hent gratis SPAMfighter her: www.spamfighter.dk
>|||Yes it is RS 2000, how is it possible to do make a chart where the months
are added to eachother each month, a temporary table ?
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en meddelelse
news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
only
> in RS 2005.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans rapport.rdl
> > The
> > expression for the chart 'chart1' has a scope parameter that is not
valid
> > for RunningValue, RowNumber or Previous. The scope parameter must be
set
> > to
> > a string constant that is equal to the name of a containing group within
> > the
> > matrix 'chart1'.
> >
> > I get that error when trying to make a running value in a chart.
> >
> > I need to have the months summed together month for month to show the
> > progress between different fiscal years and budget, now it shows each
> > months
> > values.
> >
> > this is the expression
> >
> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> > Chart1 is the name of the chart, I also tried with the
> > chart1_CategoryGroup1
> > in the region value but same result !
> >
> > Jack
> >
> >
> >
> >
> > --
> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> > Den har indtil videre sparet mig for at få 45077 spam-mails.
> > Betalende brugere får ikke denne besked i deres e-mails.
> > Hent gratis SPAMfighter her: www.spamfighter.dk
> >
> >
>|||Yes, for RS 2000 you should perform the calculation inside the query or in a
stored procedure.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> Yes it is RS 2000, how is it possible to do make a chart where the months
> are added to eachother each month, a temporary table ?
>
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> meddelelse
> news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
>> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> only
>> in RS 2005.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
>> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
>> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
>> > rapport.rdl
>> > The
>> > expression for the chart 'chart1' has a scope parameter that is not
> valid
>> > for RunningValue, RowNumber or Previous. The scope parameter must be
> set
>> > to
>> > a string constant that is equal to the name of a containing group
>> > within
>> > the
>> > matrix 'chart1'.
>> >
>> > I get that error when trying to make a running value in a chart.
>> >
>> > I need to have the months summed together month for month to show the
>> > progress between different fiscal years and budget, now it shows each
>> > months
>> > values.
>> >
>> > this is the expression
>> >
>> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
>> > Chart1 is the name of the chart, I also tried with the
>> > chart1_CategoryGroup1
>> > in the region value but same result !
>> >
>> > Jack
>> >
>> >
>> >
>> >
>> > --
>> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
>> > Den har indtil videre sparet mig for at få 45077 spam-mails.
>> > Betalende brugere får ikke denne besked i deres e-mails.
>> > Hent gratis SPAMfighter her: www.spamfighter.dk
>> >
>> >
>>
>|||I am using RS 2005 but still can't get the running value function to work.
The expression doesn't cause any errors - the totals simply don't "run".
They are plotted as single values. Any thoughts?
"Robert Bruckner [MSFT]" wrote:
> Yes, for RS 2000 you should perform the calculation inside the query or in a
> stored procedure.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
> news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> > Yes it is RS 2000, how is it possible to do make a chart where the months
> > are added to eachother each month, a temporary table ?
> >
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> > meddelelse
> > news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> >> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> > only
> >> in RS 2005.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> >> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> >> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
> >> > rapport.rdl
> >> > The
> >> > expression for the chart 'chart1' has a scope parameter that is not
> > valid
> >> > for RunningValue, RowNumber or Previous. The scope parameter must be
> > set
> >> > to
> >> > a string constant that is equal to the name of a containing group
> >> > within
> >> > the
> >> > matrix 'chart1'.
> >> >
> >> > I get that error when trying to make a running value in a chart.
> >> >
> >> > I need to have the months summed together month for month to show the
> >> > progress between different fiscal years and budget, now it shows each
> >> > months
> >> > values.
> >> >
> >> > this is the expression
> >> >
> >> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> >> > Chart1 is the name of the chart, I also tried with the
> >> > chart1_CategoryGroup1
> >> > in the region value but same result !
> >> >
> >> > Jack
> >> >
> >> >
> >> >
> >> >
> >> > --
> >> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> >> > Den har indtil videre sparet mig for at fÃ?Â¥ 45077 spam-mails.
> >> > Betalende brugere fÃ?Â¥r ikke denne besked i deres e-mails.
> >> > Hent gratis SPAMfighter her: www.spamfighter.dk
> >> >
> >> >
> >>
> >>
> >
> >
>
>|||I found a new thread where Robert Bruckner answers this question. The thread
is titled RunningValue in a chart - scope issues. My issue was using a
category group rather than a series group. Works great now.
"john" wrote:
> I am using RS 2005 but still can't get the running value function to work.
> The expression doesn't cause any errors - the totals simply don't "run".
> They are plotted as single values. Any thoughts?
> "Robert Bruckner [MSFT]" wrote:
> > Yes, for RS 2000 you should perform the calculation inside the query or in a
> > stored procedure.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Jack Nielsen" <nospamjackd@.jackd.dk (Fjern nospam)> wrote in message
> > news:%23DFrJf2vFHA.3236@.TK2MSFTNGP14.phx.gbl...
> > > Yes it is RS 2000, how is it possible to do make a chart where the months
> > > are added to eachother each month, a temporary table ?
> > >
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> skrev i en
> > > meddelelse
> > > news:%23LFJprwvFHA.596@.TK2MSFTNGP12.phx.gbl...
> > >> Is this RS 2000? RunningValues in charts are not supported in RS 2000,
> > > only
> > >> in RS 2005.
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > >>
> > >>
> > >> "Jack Nielsen" <no_spam jack.nielsen@.get2net.dk> wrote in message
> > >> news:ehm$ZVvvFHA.252@.TK2MSFTNGP09.phx.gbl...
> > >> > g:\surround\reportingservice\c5\c5 standard rapporter\Finans
> > >> > rapport.rdl
> > >> > The
> > >> > expression for the chart 'chart1' has a scope parameter that is not
> > > valid
> > >> > for RunningValue, RowNumber or Previous. The scope parameter must be
> > > set
> > >> > to
> > >> > a string constant that is equal to the name of a containing group
> > >> > within
> > >> > the
> > >> > matrix 'chart1'.
> > >> >
> > >> > I get that error when trying to make a running value in a chart.
> > >> >
> > >> > I need to have the months summed together month for month to show the
> > >> > progress between different fiscal years and budget, now it shows each
> > >> > months
> > >> > values.
> > >> >
> > >> > this is the expression
> > >> >
> > >> > =RunningValue(Fields!belxbdkk.Value, Sum, 'chart1')
> > >> > Chart1 is the name of the chart, I also tried with the
> > >> > chart1_CategoryGroup1
> > >> > in the region value but same result !
> > >> >
> > >> > Jack
> > >> >
> > >> >
> > >> >
> > >> >
> > >> > --
> > >> > Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
> > >> > Den har indtil videre sparet mig for at fÃ?Â¥ 45077 spam-mails.
> > >> > Betalende brugere fÃ?Â¥r ikke denne besked i deres e-mails.
> > >> > Hent gratis SPAMfighter her: www.spamfighter.dk
> > >> >
> > >> >
> > >>
> > >>
> > >
> > >
> >
> >
> >

Running Value with Subtotals and Grand Total

I have a Division parameter (select one or many) and I am grouping my Sales
Goal row by Division with columns for months. I can show the running year to
date total across the columns ok, but I can't figure out how to reset the
running value when I get to a new Division grouping. It is adding the second
division to the results from the first grouping which is not what I want.
How do I this?
I also want a grand total below all the groupings
TIA
DeanI have been looking for help with doing the subtotals and the grand totals of
a report and I came acrross the Running value aggregate and I am no expert
but it seems to me you need to specify the scope for your runningvalue and
that will reset it if the scope changes.
"Dean" wrote:
> I have a Division parameter (select one or many) and I am grouping my Sales
> Goal row by Division with columns for months. I can show the running year to
> date total across the columns ok, but I can't figure out how to reset the
> running value when I get to a new Division grouping. It is adding the second
> division to the results from the first grouping which is not what I want.
> How do I this?
> I also want a grand total below all the groupings
> TIA
> Dean
>
>

Running under 64-bit OS

In configuration manager, the parameter "running under 64-bit os" is grayed out on my sql services.

How can you change this? Where does it get set? At install?

This can't be changed...it is set depending on the OS version and SQL Server bits you've installed. In order for it to be set, you'd need to be running a 64bit OS (IA64 or x64) and have the appropriate SQL server bits installed (IA64 SQL version or x64 SQL version)...

|||

I checked...the server is an Itanium 2 and the SQL Server software is definitely the IA64 version (select @.@.version output), but how can you tell if the OS is 64 bit?

According to the My Computer properties, I'm running Windows Server 2003 Enterprise Edition Version 5.2 SP1. No mention of 64 bit. Anywhere else I should look?

|||Looks like you are running the 32-bit OS version...if you had the Itanium or 64bit edition, it would specifically say so...|||I have SQL Server 2005 EE 64 bit installed on a 64 bit Server with Windows Server 2003 R2 Enterprise x64 Edition. However, the SQL Configuration Manager still shows No for the Running under 64 bit OS property. Any suggestions on what is going on? Thanks.|||I am also having this problem. We have Server 2003 Enterprise x64 Edition, and the SQL Server 2005 version is as follows:

Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

What gives?
|||

It turns out that the label is very confusing. There is a bug filed on it in the SQL bug database and it will hopefully get fixed in the future to make this clearer. It turns out that this field shows if you are running a 32-bit version of SQL under a 64-bit OS (as in WoW). I had an X64 machine here with a 64-bit instance of SQL and a 32-bit instance of SQL. The field shows "No" for the 64-bit version of SQL and "Yes" for the 32-bit version of SQL. A bit misleading, but "correct" if you look at it in this way. :)

Thanks,
Sam Lester (MSFT)

|||Thank you! I actually have only one 64-bit instance of SQL 2005 and several 32-bit instances of SQL 2000 on the server. No 32-bit instances of SQL 2005 are installed. I'll trust that it's running in 64-bit mode.

Running under 64-bit OS

In configuration manager, the parameter "running under 64-bit os" is grayed out on my sql services.

How can you change this? Where does it get set? At install?

This can't be changed...it is set depending on the OS version and SQL Server bits you've installed. In order for it to be set, you'd need to be running a 64bit OS (IA64 or x64) and have the appropriate SQL server bits installed (IA64 SQL version or x64 SQL version)...

|||

I checked...the server is an Itanium 2 and the SQL Server software is definitely the IA64 version (select @.@.version output), but how can you tell if the OS is 64 bit?

According to the My Computer properties, I'm running Windows Server 2003 Enterprise Edition Version 5.2 SP1. No mention of 64 bit. Anywhere else I should look?

|||Looks like you are running the 32-bit OS version...if you had the Itanium or 64bit edition, it would specifically say so...|||I have SQL Server 2005 EE 64 bit installed on a 64 bit Server with Windows Server 2003 R2 Enterprise x64 Edition. However, the SQL Configuration Manager still shows No for the Running under 64 bit OS property. Any suggestions on what is going on? Thanks.|||I am also having this problem. We have Server 2003 Enterprise x64 Edition, and the SQL Server 2005 version is as follows:

Microsoft SQL Server 2005 - 9.00.2047.00 (X64) Apr 14 2006 01:11:53 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

What gives?|||

It turns out that the label is very confusing. There is a bug filed on it in the SQL bug database and it will hopefully get fixed in the future to make this clearer. It turns out that this field shows if you are running a 32-bit version of SQL under a 64-bit OS (as in WoW). I had an X64 machine here with a 64-bit instance of SQL and a 32-bit instance of SQL. The field shows "No" for the 64-bit version of SQL and "Yes" for the 32-bit version of SQL. A bit misleading, but "correct" if you look at it in this way. :)

Thanks,
Sam Lester (MSFT)

|||Thank you! I actually have only one 64-bit instance of SQL 2005 and several 32-bit instances of SQL 2000 on the server. No 32-bit instances of SQL 2005 are installed. I'll trust that it's running in 64-bit mode.

running the same report different parameters

Is there a way to run the same report with different parameter values?
I have 159 different parameter values (In other words - 159 reports to
save). I have already written a VB.NET application (with reporting
services web service) to automate the saving of these reports (by way
of pdf files).
I was wondering if there is a *better way* to do this. I thought
subscriptions would be good idea; however, I have 159 different
subscriptions to set up not a good idea! Is there a way to configure
subscriptions under SQL Server (via, jobs), so I would not have to
create a custom application using a webservice.
Thanks in advance!
TravisTry a linked report, and there is an app to help you if you go that way.
http://www.sqldbatips.com/showarticle.asp?ID=73
Reeves
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I can't help you with your issue, but maybe you can help me with mine. Im
trying to get my reports to PDF via a VB.NET application, and I'm having no
luck. If you can help maybe contact me at specialk_ca@.hotmail.com
Michael C
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||You can kick off subscriptions via sql server agent. (MS would probably not
recommend or support you if you did it). I have done this in the past to
overcome some of Reporting Service's shortcomings regarding executing
reports based on a fiscal calendar. If you're good at SQL scripting you
shouldn't have much trouble. The downside of doing it this way is that RS
creates new GUIDS for subscriptions anytime that they are updated. The sql
job's stored proc call is going to reference one of the subscription guids
and of course if you have alot of people tinkering with your subscriptions
you could have issues with reports not firing off because the guid
referenced in your job changes. In hindsight I think I could have written
the sql job to dynamically obtain the guid's it was about to execute but
I've been away from RS for almost a year and I don't remember the specifics
of it. Look on your report serverdb for the available stored procs. I
don't think the name of the execute one was too obfuscated. Good luck!
-Michael Abair
"Travis" <tswill54@.bellsouth.net> wrote in message
news:1187734326.317571.264180@.19g2000hsx.googlegroups.com...
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I read that a little too fast and my previous answer was way off.
I would think setting up a subscription would be the best, as stated in the
previous reply. Setting up 159 reports will be fun. If you want to run it
through your vb.net app you can path out to it, but then I'm not sure if you
can force the save at that point, but you might want to look at calling the
service directly from your app and then save the stream. Not sure on the
total details.
Sorry about the first post.
Reeves
"Travis" wrote:
>
> Is there a way to run the same report with different parameter values?
> I have 159 different parameter values (In other words - 159 reports to
> save). I have already written a VB.NET application (with reporting
> services web service) to automate the saving of these reports (by way
> of pdf files).
> I was wondering if there is a *better way* to do this. I thought
> subscriptions would be good idea; however, I have 159 different
> subscriptions to set up not a good idea! Is there a way to configure
> subscriptions under SQL Server (via, jobs), so I would not have to
> create a custom application using a webservice.
> Thanks in advance!
> Travis
>|||I think you can use Data Driven Subscriptions to fullfill your task.
Refer to steps involved in it from
http://msdn2.microsoft.com/en-us/library/aa225509(SQL.80).aspx
Thanks
Subhash

running stored proc with parameter

hi,

im getting an error when i run the stored proc with a string parameter in execute sql task object.

this is the only code i have:

exec sp_udt_keymaint 'table1'

I also set the 'Isstoredprocedure' in the properties as 'True' though, when you edit the execute sql task object, i can see that this parameter is disabled.

How do i do this right?

cherrie

Cherrie,

Not sure I am understanding the details of your problem (may be if you post the error you are geeting...); but here is my shot:

Assuming the parameter inside of your procedure is table1; then the SQLStatement of the SQL task should be something like:

EXEC sp_udt_keymaint @.table1=?

The in the parameter mapping page of the SQL task you have to map the SSIS variable to the SP parameter.

Rafael Salas

|||The syntax of the SQLStatement depends upon the connection type used. You may want to refer to BOL for the syntax of the each connection type.|||

Your best bet is to use a .NET provider. Judging by your procedure name, you're running a stored procedure on SQL Server. Then, set your SQLStatement to the name of your stored proc (dbo.sp_udt_keymaint). Add the parameter (@.TableName, the @. symbol is required) in the Parameter Mappings tab and map the parameter to a user-defined variable.

HTH

running stored proc with parameter

hi,

im getting an error when i run the stored proc with a string parameter in execute sql task object.

this is the only code i have:

exec sp_udt_keymaint 'table1'

I also set the 'Isstoredprocedure' in the properties as 'True' though, when you edit the execute sql task object, i can see that this parameter is disabled.

How do i do this right?

cherrie

Cherrie,

Not sure I am understanding the details of your problem (may be if you post the error you are geeting...); but here is my shot:

Assuming the parameter inside of your procedure is table1; then the SQLStatement of the SQL task should be something like:

EXEC sp_udt_keymaint @.table1=?

The in the parameter mapping page of the SQL task you have to map the SSIS variable to the SP parameter.

Rafael Salas

|||The syntax of the SQLStatement depends upon the connection type used. You may want to refer to BOL for the syntax of the each connection type.|||

Your best bet is to use a .NET provider. Judging by your procedure name, you're running a stored procedure on SQL Server. Then, set your SQLStatement to the name of your stored proc (dbo.sp_udt_keymaint). Add the parameter (@.TableName, the @. symbol is required) in the Parameter Mappings tab and map the parameter to a user-defined variable.

HTH

sql