Chris An's Q&A profile
SQL Server Currency Format Issue
Please Help! I am stuggeling with a amount measure in my cube. The format of the measure is set to currency but i always shows the dollar($) sign no matter the regional settings or the language setting of the report. How can i fix this problem as i do not know where to start looking. Everyone keeps saying the currency will change according to the language setting of the report or language setting under properties of sql 2005 analysis services. Thanks in advance, Jacques kruger I have found this link to more information in Mosha's Blog: http://www.sqljunkies.com/WebLog/mosha/archive/2005/10/13/mdx_format_currency.aspx Regards Thomas Ivarsson ...Show All
.NET Development How to save data from database as xml file?
Hi I have database with one table and 70 columns. Also I have xml schema . I have managed to save the dataset as XML file. But the output xml file contains all 70 columns under one NODE. My question is as follows: 1. Am I able to use xml schema to get well formed xml 2.Please tell if any other best way to implement this Advance thanks. try doing some kind of tsql query , at this end of the t-sql statement add this: FOR XML AUTO, ELEMENTS then save it to a file. ...Show All
SQL Server I am trying to schedule a job not to run on holidays in SQL server 2005.
Hi, I want to schedule a job that runs daily but not on holidays and I am using SQL server 2005. Looking for some advice... thanks, Do you mean even in Saturdays and Sundays You can schedule a job to run between Monday to Friday on weekly basis, and for any additional holiday requirement you need to follow what is suggested above. ...Show All
Visual Studio Team System Visual Studio hangs when doing tree compare
When trying to perform a tree compare within Source Control Explorer, Visual Studio hangs indefinitely. The folder I am trying to compare can even hold only one small text file and I can reproduce this. When alt+tabbing through windows to make Visual Studio active, the window description is described as "Compare", instead of something like "Start Page - Microsoft Visual Studio". Jason, Can you check to see if the Compare dialog is offscreen What happen if you select a file (instead of a folder) and right-click Compare Do you still see the Compare dialog -Tan ...Show All
Visual Studio Team System Team Foundation caches virtual image workspace location
Hello! We have a new development team (.net2.0 technology) that created a virtual image with a bunch of softwares on it along with Team Explorer. This image was created by one developer (domain account: dev1). In Source Control Explorer, he created a workspace called dev1WS and mapped the team projects to local folders on to D:\Development (D:\Development\TeamProject1 and D:\Development\TeamProject2). After everything was tested, the VM Ware image was distributed to all his team members. All team members got Team Explorer and VS2005, but Source Control with No workspace mappings. But, the local folders D:\Development\TeamProject1 and D:\Development\TeamProject2 were created with all the source code. Problem: The new user goes ...Show All
Visual Studio 2008 (Pre-release) Mapping both base and inherited objectqueries in objectcontext
Hi! I'm experimenting some scenarios with Orcas october ctp. I would like to build an objectcontext with both base and inherited objectqueries. Example: I have two entities, Person, and Customer, which "is a" Person. Each entity has a table. Person has an Id, Customer a primary foreign key PersonId. These are the mapping files. These work without Customers EntitySet in csdl and corrisponding EntitySetMapping in MSL. MSL: <Mapping xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS" xmlns:edm="urn:schemas-microsoft-com:windows:storage:mapping:CS" edm:Space="C-S"> <Alias edm:Key="C" edm:Value="ShopLib" /> <Alias edm:Key="S" edm:Value="ShopLib.Target" /> <EntityCo ...Show All
Visual Studio Express Editions type bool
Hi, Could someone please tell me why the compiler won't accept the type bool I'm not using the SDK. Is there a header file I need to include (Visual Studio C++ Express). Thanks. WENZU5 wrote: Could someone please tell me why the compiler won't accept the type bool I'm not using the SDK. Is there a header file I need to include (Visual Studio C++ Express). To add a couple of thoughts to what nobugz and Martin have already provided: 1. bool is not a standard type in C , only in C++, and that might be your problem, as nobugz mentions. 2. If you ever build native Win32 WinApps , using the Platform SDK, then you may need to be using BOOL (capital ...Show All
Visual Studio Tools for Office Word Interop Hangs When Deployed To Server - Help!
Dear all, I have developed a method in C# which creates an instance of Word, adds a document, then populates the Word doc with some text. It then saves it, closes the doc and quits Word. Now this is the problem: The method works perfectly on the command line and through IE on my development machine (Win XP Pro, Office 2003) but it fails to work on the server (Windows 2000 Advanced Server, Office 2000) when called through IE (it works fine through the command line even on the server!) I can see (using ProcessExplorer) that the instance of Word is being created and is sub-process of svchost.exe and that the actual Word doc is also being created on the hard disk. However, the ...Show All
Visual Studio Team System Sudden Expiration of TFS Release Candidate and no upgrade path
Problem Context: I am a Certified Partner with an ISV Competency. My shop has been on the TFS Release Candidate since it became available in February 2006. Developers connect to TFS using Visual Studio Team Developer installed from our monthly MSDN DVD distribution. The Problem: Last night, our TFS RC instance began throwing the following exception to all clients: " HTTP Code 403: TF30072: The Team Foundation Server trial period has expired or its license is otherwise invalid. Install a licensed editition of Team Foundation Server to continue ." As you might guess, development ops are severely blocked, since nobody can access TFS. I called Partnership Support to ask for guidance. They said that ISV pa ...Show All
Internet Explorer Development IE 7 Frameset Resize Bug
All, IE7 exhibits the same frameset resize failure as IE6 since the security update. Please see IE6 Frameset Resize Bug posting for detail. PostID=728293 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=728293&SiteID=1&mode=1 Some additional information: Basically if you mouse down to start your frameset resize drag and move the cursor down into the IE status region or into the toolbar area the resize works. Only when the cursor is over the frame that contains the page from the other domain does the drag hang. Moving the cursor away from the page and back into one of the two areas mentioned allows things to "unhang" and start working again. Is there a way to put something like a ...Show All
Visual Basic How to scroll down to last line in a multiline textbox
When i append some text in a multiline textbox with the code textbox.text &= "Some text " & vbcrlf Then the textbox automatically "scrolls" up to the first line if there is more text in the textbox than it can display in the window (there is then scrollbars in the windows). But since its a log that im displaying, i would like it to display the last line everytime (as if it was scrolled down) when i append some text. How can i do that Hi, try appending text with AppendText method: TextBox1.AppendText( "Some text " & vbCrLf) Andrej ...Show All
Visual Studio Team System More Warehouse problems
After a TFS rebuild I am no longer able to process the OLAP cube. Initially TFS (and SQL) was built on a server with Australian regional settings. However the rebuild was done on a server that had default US regional settings. I have since changed the default collation for the database server back to the Australian collation (to fix errors in comparing and merging files). The warehouse is still not working though. It seems like its something to do with date formats, although I am not 100% sure. Aus date format is the same as British (ie DD/MM/YYYY), eg today is 06/04/2006. The value of TfsWarehouse.Today.Date was "4/6/2006", we tried changing it to "6/4/2006" but it still returned the sam ...Show All
Visual Basic How can I clone a control?
Hi folks, could anyone please help me with the following problem: TextBox1.Text = "Test" Dim control As Control = New Control control.Name = "TextBox1" Dim s As String = control.Text When I debug this relatively simple code the string s contains nothing or just "". Why I thought that since I set the control.Name = "TextBox1" it would also clone other properties from TextBox1. Ny .NET version is 1.1. That's not how it works. The "New Control" code creates a generic control which is *not* the same as a TextBox control, TextBox is derived from TextBoxBase which is derived from Control. Neither the Control class nor the Tex ...Show All
SQL Server Joins
Hi, What types of Joins MS SQL has and pls provide definition of each Joins. and with realtime example pls!! which you used in development Thanks Seshu This is a pretty good resource, with examples: Using Joins http://msdn2.microsoft.com/en-us/library/ms191472.aspx It is broken down into several articles covering how to join using inner, outer, cross joins, etc. ...Show All
Visual Basic Excel Functions within VB
Hey, I'm using the PMT function in excel and in VB 2005. Basically what I'm doing is trying to make my loan calculator an actual program, instead of always having to write everything out within an excel spreadsheet. I have all the needed information and I thought that my VB code was correct, and according to all the help files I can find they are. However the number I get from the function in my VB program is wrong. I'm not sure why the answer is different if all the inputs are the same in both the program and the spreadsheet. Thanks for the insight. Here's my code for the PMT Function in my program, incase you need to see it: MonthlyLoanPayment = -Pmt((InterestRate / 12), Math.Round(MonthsWithoutMedicaid), LoanedAmount) Azrael ...Show All