Answer Questions

• ariefcrawfordconnect calculated field crashes Vs 2005 sp1 ?

  Hi! when I'm trying something litle bit more complex thing than string manipulation in calculated field ex: =RunningValue(Fields!SALES.Value, Sum) It just crashes visual studio when trying to run the report ! I think this could state as a bug in RS Aggregate functions are not allowed in calculated fields RunningValue requires 3 parameters (Expression, function and scope) Edit Expression dialog may offer a choice with 2 parameters, that is a bug. Seems that I found a solution. Beacause this cannot be done wiht RS I had load data into data table, do inner calculations and then pass this data to RS. I don't understand design decisions of this Why it's not possible to RS that Heade ...Show All

• nobs411 Adding SSMSE 2005 as a Prerequisite to a Visual Studio Setup Project

  Hi, I'm am deploying an application that uses SQL Express and wish to also deploy SSMSE along with it. I have the .msi but I don't know how to get the setup project to deploy this as it does SQLExpress and .Net Framework 2.0. (and I am using VS 2005 SE) There is an MS article on creating "Custom Prerequisites" ( http://msdn2.microsoft.com/en-us/library/ms165429(VS.80).aspx ) which speaks to creating product and project manifests. Has anyone does this for SSMSE Or am I going about this in the wrong way Thanks in advance, Keith Thanks Mike! I am deploying it with SQL Express as well. Take care, Keith Hi Keith, You're going about t ...Show All

• barkingdog Source Script Component using a flat file connection - System.ArgumentException: Empty pathname is not legal.

  I am using a Foreach loop container to go thru all the files downloaded from the ftp site and I am assigning the file name of each file to a variable at the foreach loop level called filename.  In the dataflow task inside the foreach loop container, I have a source script component that uses a flat file connection.  The connection string of the flat file connection is set to the filename variable declared at the foreach loop level.  However the script component has a error System.ArgumentException: Empty pathname is not legal. Please let me know how to correct this   The connectionString property of the flat file connection is set to the complete filename including the path.  Does a script component need to have ...Show All

• Vladimir Sapronov SQL 2000 RS Licensing Question

  We have a SQL Server 2000 Enterprise Edition box that contains roughly 100 Databases which does NOT have RS installed. Can we legally install RS on another (non-SQL) server without buying a SQL license, if it connects only to this SQL Server box If not, can we use a Standard Edition license for the RS box, and use it to connect to the EE box Installing RS on a separate server requires a separate license. (See How to License Reporting Services ). It is possible to install RS Standard Edition on a separate server and connect to you EE box. See SQL Server 2000 Reporting Services Deployment Guide for the differences between RS SE and EE. -Albert ...Show All

• Tamim Sadikali Group by problem

  Hi, I tried to execute the following statement SELECT Po_No , Po_Com_code FROM POAPInvRelate WHERE Inv_Com_Code = '002' AND Inv_No = '5' GROUP BY 1 , 2 However, did not work. Because, I need to put columns names instead: GROUP BY Po_No , Po_Com_code In this case works well. Does it mean I need to use columns names can I not use columns reference numbers cheers, Thanks joey hello alex, you can't do that in group by that syntax belongs to "order by " such as order by 1, 2 regards, joey   ...Show All

• Rush hour Conflicting docs on how to render

  I am trying to use the render method to render to a byte array in an ASP.Net application and I am having a problem in that there is a lot of conflicting information in the books and the docs on how to do this. The latest docs I read led to the following code... ReportingService2005 _rs = new ReportingService2005(); //have to use custom credentials because ASPNET does not have sufficient authority... NetworkCredential myCred = new NetworkCredential("myuserid", "mypassword", "mydomain"); CredentialCache myCash = new CredentialCache(); myCash.Add(new Uri(" http://localhost/myWebSiteName "), "NTLM", myCred); _rs.Credentials = myCash; _rs.Url = ...Show All

• Cerw1n Sql Script

  hello I need to script my Db, tables and storedprocedures. so i can create another same DB Dim con As New SqlConnection(DBClass.Config.DBString) Dim cmdName As String = File.OpenText("pro.sql").ReadToEnd() Dim cmd As New SqlCommand(cmdName, con) cmd.CommandType = CommandType.Text con.Open() Try cmd.ExecuteNonQuery() MessageBox.Show("DB Created") Catch ex As Exception MessageBox.Show(ex.Message) End Try con.Close() Any suggestions No NameSpace called System.Data.Sql Second I told u im using vb.net 2003, and sqlserver 2000 any help My problem was solved Imports System.IO Imports SQLDMO --C:\P ...Show All

• SomeDeveloperPerson what are the differences between float and decimal?

  can anyone explain to me what are the differences between the float and decimal datatypes Also - and this is important - you will get flaky results with float. This is from SQL 2000 BOL: Using float and real Data The float and real data types are known as approximate data types. The behavior of float and real follows the IEEE 754 specification on approximate numeric data types. Approximate numeric data types do not store the exact values specified for many numbers; they store an extremely close approximation of the value. For many applications, the tiny difference between the specified value and the stored approximation is not noticeable. At times, though, the difference becomes noticeable. Because of the approxima ...Show All

• fredplain Converting a date in the form of a string to a datetime format

  Hi, I'm writing some SQL and want to convert the following expression into a date format in the SELECT list: '01/'&Month(OrderDate)&'/'&Year(OrderDate) Basically, I want to look at each order date, convert that date to the first of that month and GROUP BY this expression. There is a CONVERT function, but I'm new to all this and can't seem to get it to work. Any help would be gratefully received! Cheers! Keith you can group by without having to transform the date and that is done like the example below use northwind select year(orderdate) as year, month(orderdate) as month , count(*)as ordercount from orders group by year(orderdate),month(orderdate) order by 1,2 ...Show All

• Arrakis777 Conversations & Machine Restart

  Say I have a conversation established and the initiator server needs to reboot. Will the conversation automatically restart when the server comes back up If not, can I get it to with some setting If not, what is the best way to handle this Thanks - Amos Yes. Conversations are persisted and hence they should recover and continue working from the point the point the process was killed during restart. ...Show All

• Trini_Pierre Cannot create data-driven subscription

  Hi, I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS). When I try and click on on the DDS button for a report I get the following message: "Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid." 1. I have set the data source to use stored credentials. 2. I'm using one simple string parameter 3. Its not a linked report Any ideas regards, avner Hi, I'm having the same problem. I'm using the browser interface for SSRS and when I click on a report and g ...Show All

• Maxx Delusional Replication of triggers

  Hello ! I have set up some transactional replication on one of my database but I can't see where I can specify that we should replicate the triggers. What I have seen is that the triggers are automatically replicated when the table is replicated except id they are marked "Not for replication" But it does not seem to work for me. Do you have any idea Thanks, Hello Raymond my triggers do not fall in these categories. I see correctly my "CREATE TRIGGERS" instructions in the view sys.syscomments My server (distributor) is a SQL SERVER 2005 (no sps installed) and my subscrition clients are SQL SERVER EXPRESS (sp1) I have checked the properties of my replication and the "Copy User Trigger ...Show All

• shine46055 Filtering a Cube programatically.

  Hi, My requirement is that I have a cube in the analysis services. Based on conditions I want to filter the cube and attach it to the excel pivot table. For example the list of divisions to be seen in the pivot table will be different for different users. I have been able to attach the whole cube to the excel pivot table programatically using .NET. But I cannot get a filtered cube from the original cube programatically. It will be great if some one can help me out in this. Thanks. Hi: You definitely need dimension security in place. In other words you have assign different dimension members to different user roles. The roles are then assigned to different users or user groups (based on NT accounts). This can ...Show All

• uma kadagi Problem with configuration files and deploying

  I am hoping someone with more experiencing deploying packages from dev to other environments can help me out here. When developing in BIDS everything works fine. When I deploy I want to use a configuration file. This does seem to work fine by specifying the configuration file on the DTEXEC command. However, if it is specified incorrectly the package STILL executes using the information it was created with. I am attempting to control things like connection strings and passwords via configuration files so that I can take the same package and deploy to different locations and have it run against different sources and destinations. What I am afraid of is that things could easily get screwed up if the configuration file gets moved or renamed, o ...Show All

• Nilesh Ingale FullText Ranking

  Is there an article that explains how the fulltext results are ranked I cannot find any good explanation. I only have found that 1000 is perfect match and 0 is worst possible match but what does that mean I mean how does something get a 1000 and how does something get a 0 Thanks Again Thanks... I was looking for something like that... Try this: h ttp://msdn2.microsoft.com/en-us/library/ms142524.aspx ...Show All