Answer Questions

• Bt1982 Row Number Assigned Via RunningValue But Without Grouping

  I have a report where certain columns have values that get repeated, but the client has a rigid requirement for not wanting these columns as groups in the reports (other programs and exports doing specific tasks with those values). In these reports, the "hide duplicates" value is checked, so as to give an aesthetic sense of grouping. The data for the report, in raw form is: Value 1 A Value 1 B Value 1 C Value 2 D Value 2 E Value 2 F Value 3 G Value 3 H etc... In its aesthetic form, it is: Value 1 A B C Value 2 D E F Value 3 G ...Show All

• williamtcurtis Display date in reports

  How to display only the date part on reports from DateTime fields use the vb.net formatdate function... I'm sure you can lookit up quite easliy. = format(fields!mydatefield.value,"mm/dd/yyyy") or something like that. Thanks I got it. For Short form : =FormatDateTime(Fields!InputDate.Value, DateFormat.ShortDate) For Long form : =FormatDateTime(Fields!InputDate.Value, DateFormat.LongDate) For complete Date and Time : =FormatDateTime(Now, DateFormat.LongDate) & " " & FormatDateTime(Now,DateFormat.LongTime) Also how do I display the long form of DateTime ...Show All

• aka_Tyr0 question on using xp_cmdshell

  I am trying to run an exe file like: EXEC master.dbo.xp_cmdshell '\\Share\sharepoint\folder1\folder2\test.exe "input parameter"' And executing the above with the input should give me an output.But the input parameter is not recognised. Any help. Thanks Hello It seems like you are having a security issue here. When you are using xp_cmdshell then you will "loose" your security context, and SQL Server will try to create a connection to the share with HIS security context. If you use a "Local Systemaccount" for SQL Server it wont be possible to access any network shares in your domain, since this account is "unknown" to the domain. So either move ...Show All

• redwood739 Login failed for user '(null)'

  Hi, I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000. Description: 18452: Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection. When I user SA, I do not get the above error. Any clarifications on the possibilites for getting the error is appreciated. Also let me know if we can overcome the error without using SA. I tried the article in http://support.microsoft.com/kb/840219 . But it didn't make a difference. Are the application and the SQL Server running on the same machine If not, are the machines in the same domai ...Show All

• Jesper Ekenberg layout problem

  hi all, i got a table which shows me the number of transfers of a store on everyday day together with the summed amount the store gained. my table looks like this: store day transfers amount 1 1 1 2.50 1 2 5 3.50 2 1 2 1 and i want to put it in a report like this store monday tuesday 1 1 / 2.50 5 / 3.50 2 2 / 1 i tried with a matrix but the the result wasnt satisifiying. the best one looked like this: store monday tuesday 1 1 / 2.50 1 5 / 3.50 2 2 ...Show All

• djshades2004 How do I Install SQL Server Compact Edition from a storage card on a device

  Hi all experts, in case of a cold boot on a device, I insert the the flash SD disk in a device and install the NETCF 2.0 by clicking on the NETCFv2.wm.armv4i.cab which iI previously copied, that's fine it works OK, but is there a cab file for Sql server CE that i can install from the flash disk as well, I'm trying the Sqlce30setupen.msi, SQLServerCE31-EN.msi, an I get a device message "There is no application associated....." TIA Jack tnx Erik, That was helpfull, I appriciate it Jack You need the cab files located at: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i For Mobile 5, P ...Show All

• lovlysath How to collapsible a column when the report was designed in table mode?

  Hi folks, I'm trying to collapse a column on a report that's designed in table mode. I was trying to mimick what happens in a matrix where you have a column that has a '+' in it that makes toggles the visibility of a column to its immediate right (The reason I'm not using Matrix mode is I continually get "out of memory" errors on the report I'm generating.). When I select the column and mark visible to 'false' in the properties, it of course asks me for a TextBox. My problem is that I am unable to find a scenario where the textbox is "in the proper group". Is this something that's supported, and if so, I'd appreciate some pointers to lead me in the right direction. Thanks. bump.. an ...Show All

• Antropoid how to skip applying the current remaining logs?

  Hi, My replication application need to be able to skip the from-last-stop remaining logs (that means to skip the logs generated from the last stop time of my replication application), how can i realize it thanks. Sorry, can you be more clear What is "my replication application", and what logs are you trying to skip yes, there is a batch process, generate a lot of transaction logs, what's about using sp_repldone Can replicating the execution of a stored procedure help If your batch processing affects millions of rows, rather than replicate each change, you send over the stored proc call. This can be faster, and saves a lot of space in the distribution database. ...Show All

• TruePsion Getting Children of Parent Within a Table

  I have a table Named 'Roles' which contains 'ID' and 'ParentID' fields. Some Sample Data is ID ,Name ,ParentID 1 ,Admin ,0 2 ,Manager ,1 3 ,Front Office User ,1 4 ,Supervisor ,2 5 ,Inventory User ,0 6 ,Human Resource User ,4 I would like to extract data of Parent and all children. SELECT b.[ID] as 'Parent', a.[ID] as 'Role' FROM Roles a INNER JOIN Roles b ON a.ParentID = b.[ID] and a.ParentID=1 which can return only. ID ,ParentID 1 ,2 1 ,3 My wanted form is ParentID ,ID 1 ,2 1 ,3 2 ,4 4 ,6 Like an organization tree, the top parent level can access all child level nodes. Sql 2005 support that feature. How can I access them in Sql2000 recursive function or store procedure Thanks Thu Thu Hi, I' ...Show All

• Manik Gupta C

  Hi, I have a bit of code written in class ASP that connects to a database with Command.Execute. It works fine with SQL 2000 but after an upgrade to SQL 2005 causes the asp page to hang while w3wp runs at at 100% I'm running SQL 2005 SP1 on the same machine as IIS. I can't see anything in the event log or the SQL logs that would explain this (no errors in either). SQL profiler shows the stored procedure is called. The code is below. Does anyone know of anything that might be causing this. I've spent two days so far trying to find a cause. The ODBC connection SDB1 is using SQL Native Client. MyConn.Open "DSN=SDB1;Initial Catalog=database","username","password" Set MyCommand.ActiveConnection= ...Show All

• Pockey Finding all views with a specific name, in all databases

  Hi, We are migrating to SQL Server 2005 from 2000 and we have a view created in many of our databases. That view must be changed after the migration because it uses system tables and does not return the correct information in SQL Server 2005. To do that, I want to create an SSIS-package that loops through all the databases on a particular server. If that view exists in the database, I want to run a script that change the view. What I try to do: Set up a For Each Loop container with Foreach SMO Enumerator Set the connection to my server Set the Enumerate property to "SMOEnumObj[@Name='Databases']/SMOEnumType[@Name='Names']" On the Variable Mapping page, place Index 0 in Variable User::dbName In the For E ...Show All

• rwbogosian Morning checks for DBA's

  Hello I was wondering what the first tasks and checks are you do when you come in the office in the morning Example: check jobs check blocked processes check replication ... Worf Thanks Arnie! Anyone else Worf Pretty much that's it. Unless you have a kind of special config. First, check backups successful. (Yes, I know backups are jobs -but they are very special and critical jobs.) Then error logs and security logs. ...Show All

• Jnox Easy way for users to add new members or measures?

  Hi I am wondering if there is an easy way for users to add new members or measures if the office dimension had a new office or if the user wanted to create a new calc I write enabled a dimension, but it had no effect in the BIDS or in Excel. I see the menu options change when browsing the write-enabled dimension in the BIDS, but "create sibling" and "create child" are disabled. I have full permissions and the criteria for those options to be enabled when writeback is enabled is met. But even if write enabling was working, does it update the source data From the books online, it seems like it would update dimension source data, but not measures or data points. which brings me to another question. Where do you en ...Show All

• Darrell Norton Find Counties in area

  We have the need to determine surrounding counties of a particular county. For example how can I determine, if I entered a zip code for Contra Costa and the property is also right on the line of alameda that Alameda is a neighboring county of Contra Costa Could it be determined by the longitude and latitude of the zip code in comparison with the counties Hello, Although I'm sure a geospacial co-ordinate system could be used to determine this, most people think it overkill and just use a proximity table :) tCounty (CountyID int, CountyName varchar) tCountyAdjoined(CountyID int FK to tCounty.CountyID, AdjoiningCountyID int FK to tCounty.CountyID) So if Contra Costa was near Al ...Show All

• raviparthan Possible pass parameters on "Jump to URL" properties?

  Hi, I use the " JUMP to URL" properties and the code as follow: =SWITCH(Fields!KpiCode.Value=Fields!KpiCode.Value,void(window.open('"+First(Fields!ServerString.Value, "HostInfo")+"/L3/"+Fields!KpiCode.Value+".aspx','"+First(Fields!PropertyString.Value, "HostInfo")+"'))") I want to know is any way or any possible way could pass the report parameter on this kind of porperties or this code For some requirement, I just can use Jump to URL, but hope can pass the parameters on "jump to url" properties. Thanks for any advice! Angi Similar to Fields, you can pass parameters. Parameters!ParameterName.Value Thanks for Jens. Can anybody ...Show All