Answer Questions

• Cockeyed Bob The SUM issue

  Hello, I have a question about the Sum function in SQL Server Reporting Services and I appreciate your response. I have a project due shortly for which I have to do a lot of calculations and every time I drag a numer or a money field into a detail row in my table, I get a Sum(Fields!Count.Value) where I just want the individual amount for that row as Fields!Count.Value. I know that Reporting Services automatically gives the Sum for t ...Show All

• rvn query its urgent

  DATEDIFF([day], dbo.Nonconformances.OpenDate, GETDATE()) AS [Days Still Active], what is its function its the interval between dbo.Nonconformances.OpenDate (Date1) and the Current server date - GETDate() (date2) ...Show All

• Hatawa warning while installing ms sql server 2005CTP

  Hi all,   I am trying to install the latest version of SQL SERVER 2005, 9.00.1314...but whenever i m trying to install it...it installs everything fine but as soon as its installing WINDOWS COMPONENTS then a warning comes SQL MANAGEMENT STUDIO 2005: the file C:\WINDOWS\MICROSOFT .NET\Framework\ \mscorlib.tlb could not be loaded.The operation failed since the file is not found. Please reinstall again.... Now what to do Thanks in advance.... ...Show All

• Mickael Provost 44 Subscriptions and Windows NT Auth?

  Is there a way to work with subscripts for differnt users with windows NT authentication (Analysis Services - with Dimension Security) I need to have different users in the connection - but with the subscription you cannot specify the user for the datasource. You need to specify a single user on the datasource to use for reporting services. Why - and why its possible to specify an NT user for the fileshare - why not for the datasource Is there ...Show All

• jeremymarx SQL Management Studio (RTM) Connect Problem

  I'm trying to use SSMS to connect to previously configured remote MSDE servers. I can connect just fine using Enterprise Manager to these remote machines. Using Management Studio, I can only connect to some of the machines. And no matter what combination of authorization/protocol I select, I still cannot connect to certain machines. Some machines, configured with MSDE exactly as others, I can connect to. What is SSMS doing differently than Enter ...Show All

• Jarda Kroupa June CTP - Passing NULL value to a Sub-Report Parameter

  Passing NULL value to a Sub-Report Parameter fails with this message - "A parameter or data source credential is missing a value.  Prompting for this value has been disabled.  Supply a value or enable prompting." Anyone else seen this Thanks I did set 'Allow Nulls' for the parameter. However, this sub-report accepts multiple parms and one of those parm is required and hence I had not set 'Allow ...Show All

• prabashmi SQL Sever 2005 only has client side?

  Why I couldn't find any datebase engine setup SQL Server 2005 Developer Windows xp I installed SQL server 2005 Developer Ed it has components like .NET framework 2.0, Visual Studio. (GUI) after install completes. Visual studio and all of them are added to the menu. Enterprise Manger is there. It looks perferctly installed But like I said. Nothing showed up in the server configure mana ...Show All

• VahidJ How to quickly evaluate SSIS, programmer perspective

  SSIS looks interesting .  I haven't loaded any Yukon or read the 2005 BOL, so I'm coming in with a clean slate. In the past I have found the graphical programming interface for DTS, limiting, annoying and unnatural.  I much prefer coding in an OO language the conventional way. I'm interested in evaluating SSIS as quickly as I can.  The ideal is programming with a standard .NET language.  I am happy if a de ...Show All

• dankster Where to put template packages?

  I have a package that I want to use as a template for all of my packages (kind of like a .dot file for MS Word). Someone once told me you can put this template package somewhere in your file system so that it is available as an option when you right-click on your project and hit Add-->New Item... Anyone know where that somewhere in your file system actually is I've tried it where I thought it should go but it hasn't worked. or perhaps there's ...Show All

• Hugo Kornelis Want Hyperlink to Open in a New Window

  Greetings.  I have added a hyperlink to a report, and it works like a charm.  Now I would like to change it so that when the link is clicked on, it opens the URL in a new browser.  I cannot seem to find any information out there on this issue.  Has anyone figured out how to do this   Here is the RDL from the report I'm working with: <Action> <Hyperlink Target="_blank"> =Trim(Fields!sfa_WebServer.Value ...Show All

• Topple help with a scalare function

  i wrote a scalare function- select name,id from tableName where function1(id) / function2(id)>100 but sometimes function2 returns zero so im getting a divide by zero exception. how can i solve this problem thanks in advanced. You can modify your WHERE clause to: where function1(id) / nullif(function2(id), 0)>100 It depends on what do you want for outp ...Show All

• Geo V Executing password protected packages

  Hi - I have a master package that executes a series of other packages. Each of these 'sub' packages has the security property Encryption Level set to 'EncryptSensitiveWithPassword'. The master package has a series of file connections in the Connection Manager, one for each sub package, in which the password of the corresponding sub package is provided. When I run the master package in BIDS (in interactive mode) it opens each of the sub pac ...Show All

• Mr_Mojoman Don't email report if no results from query

  With an automated report (scheduling setup in report manager) is there a way to prevent the sending of an email if the report query has no results Sure. Rather than just creating a schedule, you'll need to do a data driven subscription which gets fired ON a schedule. The data driven subscription will query another SQL Table which you will need to create and populate with data like who to send the report ...Show All

• vkuttyp Question about multiple subscriptions

  Hello,     Ok we are finally get close to testing SQL 2005 with SQL Express 2005:). So I have a publication named hh3_100_pub. We currently ghost each unit so the instance name and database names are the same. My question is we have 20 possible subcribers. Does each subsriber need to: 1. Have a different instance name 2. Have a different database name What would I do to add another subscriber with the same instance name and datab ...Show All

• BISWAJIT DAS UNION with the second set ordered

  Hi, I was trying to use the UNION construct to combine two tables. The second table was to be sorted before effecting the UNION. The first attempt was the following: SELECT emp_id , assigned_branch_id FROM employee WHERE title = 'Teller' UNION SELECT open_emp_id , open_branch_id FROM account ORDER BY open_emp_id The above was generating an error. I then tried SELECT emp_id , assigned_branch_id FROM e ...Show All