Answer Questions

• mohd sufian Two datasets fields in the same table

  Hi I'm basically new using reporting services, I hope someone can help me I'm using two datasets in the same table this is because I that was the only way to obtain the data that I need, my problem is that when I try to use the folowing statment =Fields!Total.Value/Fields!Total2.Value,"seconddataset" I got an error because the scope, the expression edtior give me the Sum(Fields!Total2.Value,"seconddataset") wich it works but that is not what I want, I need to divide by the single value not the total Sum the table is using the firsdataset but I need to use some fields from the seconddataset I hope someone can help me thanks in advance Hi , I believe your issue could be. Reporting services expect ...Show All

• english_d Management Studio - Index properties grayed out

  If I right click on an index, the properties context menu is grayed out as well as the "New Index...", "Disable", and "Delete". If I right click on a table and click modify, I can add and edit indexes from there just fine. Strangely enough "Included Columns" is grayed out though. Was the database designer or table designer opened at the time We prevent the index dialogs from being launched when the table is being designed. The database and table designers work by making the state of the tables (including indexes) match the internal model in the designers. This includes index and constraint definitions. Reconciling the state on the server to the state in the mode ...Show All

• Dark Shenada Error in sending mails !

  I am trying to send email thro DTS using Activex Script. Here is the code : ' ********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() const SMTP_SERVER = "MPBAKOREX01.corp.mphasis.com" set iMsg = CreateObject("CDO.Message") set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields With Flds .Item(" http://schemas.microsoft.com/cdo/configuration/sendusing ") = cdoSendUsingPickup .Item(" http://schemas.microsoft.com/cdo/configuration/smtpserver ") = SMTP_SERVER .Item(" http://schemas.microsoft.com/cdo/configura ...Show All

• johnny_no1_boy Scheduled Reports Not Being Sent Out

  I have several scheduled reports that have been running every morning and being emailed out to many recipients. One day it all stopped. There are no error messages. It just doesn't work any more. I have tried re-deploying them to the report server and rescheduling the jobs but they still don't run. There has to be some information in the error log of SQL Server Reporting services (stack trace or an informal message). Please post that here. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- There are no error messages in the Reporting services log Is this RS 2005 I had a problem recently with the SMTP server name specified in the RS Config Tool, I had to use the IP address of t ...Show All

• MoP73 INSERT INTO as SELECT with ORDER BY

  Hi, This may sound like a dumb question, but I need to be certain of the answer. If I have a query like this: INSERT INTO table1 (col1, col2, col3, ... ) SELECT col4, col5, col6, ... FROM table2 ORDER BY col7, col8, col9, ... and table1 has an identity column that increments by 1 each time, am I gauranteed that the records inserted into table1 will always be inserted in the order as specified in the ORDER BY clause and hence the increasing identity column in table1 will reflect the same order as that of the ORDER BY clause Seems like it should be the case but I need to be sure. Thanks, Peter The only guarantee is that the identity values will be generated based on the ORDER BY claus ...Show All

• MueMeister Need help sql server 2005 client Installation

  Hi , Iam a new bee to sql server.I have Installed sql server 2005 ( trail software ) in my Server.I like to install sql server 2005 clinet in another system. Where can i download sql server 2005 client My requirement is , i should access sql server database from my client... Regs, Priya Hi , I have downloaded sqleval.exe ,and installed the sql server.Can u tell me where can i find SQL-Server Mangagement Studio or can i use express edition of SQL-Server Management Studio But the trail software says its standard edition.Is it fine to use express edition for client software Regs, Priya Hi, If you are looking for a software to manage ...Show All

• Shelto NT AUTHORITY\ANONYMOUS LOGON'

  I read a lot of artical but didn;t find a solutio to this problem. I have Windows 2003 SP1 install Reporting services 2005 I have other Windows 2003 SP1 server with SQL 2005 database. I set kerberos delegetion control on the server in the AD I also run the command cscript adsutil.vbs set w3svc/1/root/NTAuthenticationProviders "Negotiate,NTLM" on reporting services server but still getting this error message. Any help w3wp!processing!7!8/30/2006-00:00:01:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'MyDB'., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection t ...Show All

• Paul Mason Top 5% of Sales for each salesman

  Above says it. I'm trying to select a random 5% of sales for each salesman for the last day serviced. I've got it all down, but I can't get it down to salesman. I'm using a basic select: name, address, order, order_id, etc where order_id in (select top 5 percent order_id from MYSERVER group by salesman, order_ID order by newid()) The actual statement's much longer and has more where statements, but the pertinent info is above. All I can manage to do is create very long-winded ways to pick a random 5% of all sales. I spoke too soon. As I go back and check it out, it's not doing what I need it to. It seems to be selecting the right number of orders, but the salesman are random. I'm trying to get it to sel ...Show All

• champa Report Services installation problem

  I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks. 1. Open up Internet Information Services applet in the Administrators group. 2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's ...Show All

• Eric Anderson ConnectionManagerOleDb usage in a Script Component

  Hi, I have a need to use a shared connection manager of type OLEDB inside a Script Component. I guess that the right way to get the OLEDB connection is to override the AcquireConnections method, case the shared connection manager to the ConnectionManagerOleDb interface and call the AcquireConnection method. The problem is in the return value of the AcquireConnection method (it’s Object). My assumption is that in case of OLEDB connection usage, the AcquireConnection method returns some OLE DB COM interface. Does some of you tried to cast it to some interface/class exposed by DTS (or some standard COM interface from MDAC) PS I’m aware about the possibility to use ADO.NET connection managers, however it’s n ...Show All

• Dietz How to create a report using multiple databases

  Hi, I am a beginner of Reporting Service. I am trying to create a report using multiple databses. For example, I want to create a report called RevenueByCustomer, so I need to get data from the Customer Table of CRM database, which contains customer information, and I also need to get data from Transaction table of Sales database, which contains all the revenue information. In order to get data from both database, I have created two dataset. One is Customer dataset, which get all required customer data from CRM database, and the other is Revenue dataset, which gets data from Sales database, they used seperate datasource (because each datasource only contains one database connection). Now my problem is how can I make them be displayed in on ...Show All

• Arvind Martin Access cube from Excel 2004 Macintosh

  Hello, is possible to access a cube on analysis services 2005 from Excel 2004 for Macintosh how can access thank's thank you I am not sure about the support for OLAP in Excel for Mac. You should be able to access a cube, on a Mac, by a web browser that supports HTML 4.0 if you use Reporting Services 2005 as the report middleware. For authentication you will have to set up a windows account on the Windows 2003 server running Analysis services 2005, for each Mac-user. Regards Thomas Ivarsson ...Show All

• vTyphoon Error in SQL Server 2005 CLR Assembly

  In the past we've days we've had an assembly that had worked previously which now fails with the error: Failed to open malformed assembly 'System.Data' with HRESULT 0x80070008. There have been no changes to the .NET framework at the server level, all other assemblies on the server continue to function and the assemly does work when deployed to another server. The assembly has been recreeated from scratch yet the error persisted. In another attempt to narrow down the cause we moved the system.data.dll to another server in an attempt to see if the particular DLL was the issue, however the other server had no issues. I'm assuming that the error we're getting has some cause other than with System.Data.dll.Does anyone have any ideas ...Show All

• Jimmy V Matrix grouping/visibility

  I have tried several combinations, but I can't quite figure out the solution to this one. I have a matrix set up that is giving me the results I want, but I need to do a conditional visibility and still have what I need. I have a column that is filled with operation numbers and a row that is filled with item numbers. The detail is for work centers and it shows where each of them fall in the grid. I need to say to show all work centers that apply where the workcenter parameter matches. I was able to filter and say only show me this workcenter, but I want to show just those, but then if this workcenter would show up, show me the rest. BJ bj By right click on the detail column and selecting proper ...Show All

• Geeee import OpenSSL certificate with private key into sql server 2005 express edtion

  hey, i have a problem, to import a self signed openssl certificate into the sql server 2005. my final idea is to get encrypted columns from the database over an jdbc connection in a java client. when i use a certificate generated by the sql server 2005, i can encryt columns of a table. then i catch the the result in my java client. but in java, i need a keystore with the private key of the certificate. ok. i have export the the certificate and the private key of the sql server 2005. problem: in a keystore i can only import the certificate (signed public key) but not the private key. my new idea is to import an openssl certificate or an certificate generated by the keytool (java) into the sql server 2005 and encypt t ...Show All