Answer Questions

• nattylife An error has occurred during report processing. (rsProcessingAborted)

  Hullo, I am trying to change a parameter's default valu, when i click on Bikes Sales and Profitability report link with the Report Manager I get the following error. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'rs2005sbsDW'. (rsErrorOpeningConnection) Login failed for user 'ReportExecution' Could someone please help me out. Ronald Hi, in addition to John make sure that the user name exists on the SQL Server system. THe most common problem is that people try the reports on their test machines but forget to create the users and grant the appropiate right to them, because they used to work with an administrative user in their test enviro ...Show All

• KimberlyL need help from MSFT guys

  Hi, I am creating a pie chart report from a cube . This report may contain unknown number of segments. Here is the thing; if more than 1 data slice is generated with a value less than 5% of the total, then a segment labelled 'other' will be generated, and data from all slices with value < 5% will be added to this 'Other' segment. Is it possible to implement this functionality in the report layout level with out writing a complex MDX query If this is not possible, can you give me a sample MDX query which implements similar issue(i.e. 'Other-ing' rule.) For your information, this feature can be easily implemented using a third pary software such as 'Dundas chart for Reporting Service'. However, my client don't want to buy this ...Show All

• cdmsarathy how can i update CERTIFICATE expiry date ?

  Hi, I created a master key and CREATE CERTIFICATE mycer WITH SUBJECT = 'data encrypt',START_DATE = '12/1/2005',EXPIRY_DATE='7/9/2006' GO CREATE SYMMETRIC KEY mySymetric WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE mycer,password='mypass'; GO and i created a table with varbinary field and i added 2 encrypted records and i got it properly i need to update the expiry data for my certificate , so i dropped the symetric key and their certificate and run the following CREATE CERTIFICATE mycer WITH SUBJECT = 'data encrypt',START_DATE = '12/1/2005',EXPIRY_DATE='12/12/2006' GO CREATE SYMMETRIC KEY mySymetric WITH ALGORITHM = TRIPLE_DES ENCRYPTION BY CERTIFICATE mycer,password='mypass'; GO i tried to get the adde ...Show All

• Leon Mayne Express Problems

  Hi All We recently moved from FW 1.1 to FW 2.0, and 2003 to 2005, also now using SQL Express. The problem im having is that in code ie from this function: visual basic code: Hi Danny, There are differences between running a T-SQL command in a query window and trunning it using a SqlCommand object. (I'm guessing you're using a SqlCommand.) I find that it's easier to run single statements in a SqlCommand at a time. Here is a sample that does what you want: Sub Main() Dim cnn As SqlConnection Dim cmd As SqlCommand cnn = New SqlConnection("Data Source=.\sqlexpress;Database=AdventureWorks;Integrated Security=True") cnn.Open() cmd = New SqlCommand("SELECT DATABASEPROPERTYEX('AdventureWorks', 'UserAcc ...Show All

• GethWho How to let general user use xp_cmdshell?

  Hi, Is any way can let user (not admin role) use xp_cmdshell I write a SP and include xp_cmdshell to execute .exe file. So I hope user can execute xp_cmdshell, too! Any idea Thanks! First, why would you want a user running xp_cmdshell Talk about an open entry to your servers. Does your system admin know about this Second, not 100% but I think SP2 eliminated the ability for processes to run xp_cmdshell. ...Show All

• Divermarv unable to connect to Oracle in DTS

  Hi, I am trying to move some data from Oracle 8 to SQL server 2000. I am using a DTS package to do that. Now the problem is I am not able to create connection to Oracle DB. I tried creating with "MS ODBC connection for oracle", but it didn’t work. I then tried other connections, then it connected, but when i tried to create a task it only show list of table in "Query build", but doesn’t give me any drag drop facility or show me any field. I then tried with paste query and then "transformation" doesn’t work. I am new to DTS, Can anyone help me with these questions. 1. How to move data from Oracle DB to SQL server2000. 2. Is it possible to have result of one query/table to be exported to multiple ...Show All

• deklund Force columns to appear in matrix.

  I have created the report below in SSRS to show the total by month for the calendar year. As of my January running it runs great as there is data for all 12 months of the year and the matrix is created with the required 12 columns. 01 02 03 03 4 05 06 07 08 09 10 11 12 Total AA 17.5 22 17.5 75 30 162 BB 15 15 15 15 15 15 15 15 15 15 15 15 15 195 CC 15 15 15 15 15 337 15 233.3 15 325.5 117 15 15 1147.8 DD 315 290 1231 1231 1231 269 953 384.8 706.8 1798.8 ...Show All

• Luis Esteban Valencia MCP. problem with url in microsoft server 2005

  Hi, I have a problem: When i enter in the iis i have two virtual directory: Reportsr$sqlexpress ReportServer$sqlexpress I try to run the report by browsing home.aspx and going to my report.The url that i got is: http://localhost/Reports$SQLExpress/Pages/Report.aspx ItemPath=%2fReportInventory%2fReportTotalCounting Now, i enter the parameter wanted and click on export to pdf file it works fine :it opens the report in a pdf file ,i got a url like this: http://localhost/Reports$SQLExpress/Reserved.ReportViewerWebControl.axd ReportSession=a52f1o55wy00wq454pq0jp45&ControlID=f8672382-3d09-430f-a308-9bf42b850184&Culture=1037&UICulture=9&ReportStack=1&OpType=Export&FileName=ReportTotalCounting&ContentDis ...Show All

• asmith48 yesterday statement

  Hi, I am trying to substract one day from my current date and are having difficulties any suggestions =IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =3,Fields!XTNDPRCE.Value, IIF(Fields!DOCDATE.Value = today-1 and Fields!SOPTYPE.Value =4,-(Fields!XTNDPRCE.Value), "0" )) Thx a stack The following expression calculates 'Yesterday': =Today.AddDays(-1) -- Robert ...Show All

• Uggywuggy Cannot find ODBC drivers

  I'm using dreamweaver to create a site, and I am trying to get a database to work with it. I'm using asp and to connect to the dsn i need odbc drivers. When i open the box to set up the connection, none are listed. however, when i tried to install mdac 2.8, it said it could not install because it is already running on my system. Where are my drivers help please! Which ODBC driver are you using wow, it worked! thank you so much, you are a genius! now i can see all the drivers, so i created a dsn using administrative tools. i used the microsoft access driver. when i try to connect to this dsn in dreamweaver, i get "Unknown error 0x800A0E7A. Provider cannot be ...Show All

• sathupadikesavan DecryptByPassPhrase not decrypting varchar columns after copying a database

  I have an encrypted column of data that is encrypted by a passphrase. The passphrase was encrypted by a symetric key in a key pair. The passphrase also is stored in a table. I can get the passphrase as needed to encrypt/decrypt the columns. I copied the production database to a new database for development. Subsequently I had to create a new symmetric/asymmetic key pair and recreated my passphrase with the new key pair. Now the passphrase will decrypt a text column but it will not decrypt two other columns which are of type varchar in the database. Here is an example: DECLARE @pss varchar ( 30 ) EXEC [dbo] . [uspPassPhraseGet] @pss OUTPUT SELECT DISTINCT contactid , uissueid , createdby , created_dt , CONVERT ( varchar ( max ...Show All

• Pikker1981 Ignore failure does not ignore!

  I have configured an OLE DB Destination to Ignore Failure on each row, but when it tries to insert a duplicate primary key, it fails (which is what I want) and does not ignore it. Am I missing something here Jeff Tolman E&M Electric ...Show All

• adisciullo putting dbo explicitly in select staetement

  I have witten a lot of stored procedures in my project where I did not put dbo before the user tables.My colleague told me that I have to put dbo for all statements other there could be a problem. Any thought , Please assist. I've heard it said that not including the schema owner (usually DBO) on your object prefix can result in a "Compile lock" against your stored procedure while the client determines whether there is an object in existence for its own schema. In this situation, multiple users executing the same stored procedure would suffer from a queuing effect as each would place a compile lock on the procedure (or statement). That being said, I've never been able to repro this ...Show All

• Brian Stringham "Upgrade" from 2000 to 2005, version still says 8.0.2039

  I just installed 2005 and accepted all the defaults to upgrade the default instance of 2000 as prompted. However, when I open the SQL Server Mgnt Studio, my server shows 8.0.2039 as the version which is 2000, and I can't restore a backup from another 2005 server, because it gives an error message like it still thinks its 2000. The whole installation process went fine including sp1. I looked in Services to see if there was more than one instance of SQL Server, and there isn't. Also, all my database files are still in the old 2000 (mssql\data) directory. Any ideas, solutions Thanks. Michael Sorry for not having a more direct answer, but can you read through this forum thread regarding SQL 2000 and 2005 ...Show All

• chris bax XML Datasource Credential Issue

  I have a report using an XML data source. The data source is calling a web service method which returns the XML file. The security setting is "Use Windows Authentication (Integrated Security)" in the report. The web service and report are both deployed to ServerA. The web service is pulling data from a file share. Only certain users have access to this share and they are identified in the <authorization> element of the web.config file in the web service. If I open Internet Explorer on ServerA and go to //localhost/Reports, I can navigate to the report, run the report and everything works fine. If I open Internet Explorer on ClientZ and go to //ServerA/Reports, I can navigate to the report. However, when I run the report I g ...Show All