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 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 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 the package through C# UI

one more guidance needed with regard to the Quotation marks

path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

jobCommand = new SqlCommand(@."xp_cmdshell 'dtexec /f "'path '" /Set \package.Variables[User::ArchiveFileType].Properties[Value];""Excel""'", cconn);

How Do i set the path's value in c# the quotation marks are wrong again. cos i want to set value of path according to selection in the UI.

Select("deviceUniqueId = '" + deviceUniqueId + "'"); is an e.g of Doing in C# but when i implement it through text it does not recognize

Thanks

Jas

You would normally use \ to escape a ". Remove the as that means you I cannot use the escape char, which I think you need to deal with teh quotes. Just escape the slashes as well.

string var = "This has a quite in, \", see and \\ is really a single slash?";

|||

Hi!

I know that \ is an escape character but what actually happens here is

string path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

i need to change this value accordingly.when i try to execute this statement

jobCommand = new SqlCommand(@."xp_cmdshell 'dtexec /f '" + path + "''", cconn);

i am getting this result - @."xp_cmdshell 'dtexec /f 'D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx''"

which is correctly getting the value of path but when i say

jobCommand.ExecuteNonQuery(); It fails because there is a single qoute which is set before the path value 'D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx' i think is the problem

Message @."Incorrect syntax near '\'."

What should i do i really need to get the value some thing like this

@."xp_cmdshell 'dtexec /f \"D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx\"'"

Thanks,

Jasmine

|||

If you know about escape characters that is good, but you are specifying @. which means escape sequences are not processed. Your previous version had doubel quotes which had not beeen escaped, so double them or use traditional escape syntax without the @.. You are trying to mix the two methods, you cannot us \ when you have @. in front as I tried to explain above.

Try -

string path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\"'", cconn);

The evaluated command below looks good for SQL and also the DTEXEC path itself.

xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"'

|||

Hi!

Thanks For your reply!

but this is very urgent please help!!!!!!!

I need one more help in this issue. what if i do not need any \ "

for e.g: i am trying to set conn string and varaible value

jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + Packconn + "\" \"" + connect + "\" '",cconn);

i am getting some value like this :

CommandText "xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \"SE413695\\AASQL2005.TestDB;\" \"Provider=SQLNCLI.1;Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;\" '" string

I do not need the highlighted escape characters in it. what should i do?

i need some thing like this :

xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveMainMultiTables.dtsx" /Conn SE413695\AASQL2005.TestDB;"Provider=SQLNCLI.1;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"'

Thanks,

Jas

Running the package through C# UI

one more guidance needed with regard to the Quotation marks

path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

jobCommand = new SqlCommand(@."xp_cmdshell 'dtexec /f "'path '" /Set \package.Variables[User::ArchiveFileType].Properties[Value];""Excel""'", cconn);

How Do i set the path's value in c# the quotation marks are wrong again. cos i want to set value of path according to selection in the UI.

Select("deviceUniqueId = '" + deviceUniqueId + "'"); is an e.g of Doing in C# but when i implement it through text it does not recognize

Thanks

Jas

You would normally use \ to escape a ". Remove the as that means you I cannot use the escape char, which I think you need to deal with teh quotes. Just escape the slashes as well.

string var = "This has a quite in, \", see and \\ is really a single slash?";

|||

Hi!

I know that \ is an escape character but what actually happens here is

string path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

i need to change this value accordingly.when i try to execute this statement

jobCommand = new SqlCommand(@."xp_cmdshell 'dtexec /f '" + path + "''", cconn);

i am getting this result - @."xp_cmdshell 'dtexec /f 'D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx''"

which is correctly getting the value of path but when i say

jobCommand.ExecuteNonQuery(); It fails because there is a single qoute which is set before the path value 'D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx' i think is the problem

Message @."Incorrect syntax near '\'."

What should i do i really need to get the value some thing like this

@."xp_cmdshell 'dtexec /f \"D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx\"'"

Thanks,

Jasmine

|||

If you know about escape characters that is good, but you are specifying @. which means escape sequences are not processed. Your previous version had doubel quotes which had not beeen escaped, so double them or use traditional escape syntax without the @.. You are trying to mix the two methods, you cannot us \ when you have @. in front as I tried to explain above.

Try -

string path = @."D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx";

jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\"'", cconn);

The evaluated command below looks good for SQL and also the DTEXEC path itself.

xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveTicket.dtsx"'

|||

Hi!

Thanks For your reply!

but this is very urgent please help!!!!!!!

I need one more help in this issue. what if i do not need any \ "

for e.g: i am trying to set conn string and varaible value

jobCommand = new SqlCommand("xp_cmdshell 'dtexec /f \"" + path + "\" /Conn \"" + Packconn + "\" \"" + connect + "\" '",cconn);

i am getting some value like this :

CommandText "xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \"SE413695\\AASQL2005.TestDB;\" \"Provider=SQLNCLI.1;Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;\" '" string

I do not need the highlighted escape characters in it. what should i do?

i need some thing like this :

xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveMainMultiTables.dtsx" /Conn SE413695\AASQL2005.TestDB;"Provider=SQLNCLI.1;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"'

Thanks,

Jas