Scottzrn's Q&A profile

• SQL Server Using Except function without aggregation (ssas 2005)

  Hello, I recently got help in getting the except function to work... Here is the solution provided by Deepak. (The requirement is to calcuate active head count of employees excluding two departments) SUM( Except([dimensionEmployee].[Employee Department].[All].Children, { [dimensionEmployee].[Employee Department].&[Services], [dimensionEmployee].[Employee Department].&[Leadership] }), [Measures].[Active Employee Head Count]) Now, how do I get the except function to work "without" the aggregation Any help is greatly appreciated.. Thanks, Ganesh Deepak, I am new to ssas 2005, my perception was, I needed a calculated members to create Charts and use it in other calculations.. The u ...Show All

• Visual Basic bin and obj folder confusion

  Converting an application from VB03/SQL MSDE to VB05/SQL Express - This may have been true under VS2003, but I have just noticed it in 2005... If you create a new windows application, and do nothing to it but save it, it creates a bin\debug and bin\release and a obj\debug and obj\release folder (in addition to other folders). In the Solution Explorer, Project, Properties, Compile, both debug and relase are defaulted to complite to the bin\debug and bin\relase respectively. The obj folder is not used at all. I would have expected the release to compile to obj\release. Anyway, the point of all of this is, is there a URL that explains the bin and obj (and their sub folders) and how they are intended to be used Thanks! Bob ...Show All

• Visual Studio CrossCompile.CSharp.targets

  I just installed Visual Studio 2003 and 2005 (we have projects in both version) and when im trying to open a solution, i get this error: ...The imported project C:/Program files/.../CrossCompile.CSharp.targets was not found... Why this file was not installed at the installation, and what can I do to get this file Thanks Sounds like this a customization to the VS 2005 project file to support building 1.1 projects. Have a look at: http://blogs.msdn.com/jomo_fisher/archive/2005/04/22/410903.aspx . This is not a part of Visual Studio or MSBuild out of the box. On another note, there is a toolset, MSBee , that is available that can be used to build 1.1 projects using VS 2005. Sayed Ibrahim Hashimi ...Show All

• SQL Server Complex Order By Logic

  I apologize if this is not the appropriate forum for this question. I've written a searchable database-driven application in classic ASP and vbscript with a SQL Server backend. What I need to do is this: order the results of a query so that if the first "order by" field is null to order that entry based on the second "order by" field. The application I am writing is a database of books, and my client wants the results to be ordered by Author, unless there is no Author, in which case he wants that entry ordered by book title. Here is an example of how he wants the books sorted: Adamson, Jan - Book X Bible, The Wilson, Jonathan - Book Y I hope I've explained the scenario correctly. What's the best way to wr ...Show All

• Windows Forms Hyperlink as a treenode?

  Is it possible to have a tree sub-node as a hyperlink, or at least to make the treenode behave like one (change the cursor to a hand etc). You can set the child nodes forecolor to Blue to represent a hyperlink, then in the child nodes OnHover event you can change the mouse cursor to the hand, and in the OnLeave event change it back to the normal pointer. Then just implement the click event to do what you want. ...Show All

• Visual Basic Could you tell me the type of your applications?

  Hello. I have a question on user settings. When I install another version of my application on a customer PC I lost old users settings. Could anyone say me how could I retrieve them when I install a new version of my application Thanks... Hello. The type of my applicacion is framework 2.0 visual 2005. I don't need to uninstall an aplicacion when I have another version. I install it on the old one. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Image File Extension .dds

  My problem surface, when I need to add image file, say texture1.dds to my game project. WindowsGame1 Add Existing Item... then from the dialog I select Files of type Image Files (*.gif,*.jpg,*.jpe,*.png,*.bmp,*.dib,*.tif,*.wmf,*.raw) So my problem is missing image file type *.dds . DX Tool creates it and is supported by XNA Texture2D.FromFile(). Is there published solution avaible or should I change with hexeditor for example *.jpe (never seen jpeg files with this extension) to *.dds If I hard code extension, then where lives dialog recource Any comments will do Peca Sorry, but drag&drop don't work. If you look "File Name" property, you see only pure file name without path. ...Show All

• SQL Server Sequel 2005 installation Perflib problem

  Hey everyone, I'm trying to install SQL 2005 developers edition on my local PC and I get the following error during the System Configuration Check: - Performance Monitor Counter Requirement (Error) Messages Performance Monitor Counter Requirement The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online. I looked it up in MSDN and i'm having problems resolving the problem. How to: Increment the Counter Registry Key for Setup in SQL Server 2005 says I should match the values of "Last Help" and "Last Counter" f ...Show All

• SQL Server Can't register SSIS server in SMS...need permissions help.

  I have a user who can't register the SSIS server in SMS.  What permissions do I need to give him to allow this ... without making him sysadmin of course Yes, I found this online. Unfortunately, after all this I'm still getting an error. Could not get proxy data for proxy_id = 1 When I set up the credential, what kind of account should the "identity" be SQL or Windows What kind of permission should the "identity" have ...Show All

• Visual Studio Team System Use of History field for a Note Log?

  I would like to add a Note Log capability to my custom work item type.  It would work like the history field, but without showing th field changes: a user would type in a note - saving the work item appends it (along with user and datetime info) to the MyCompany.ChangeRequest.NoteLog reference field for display.  It looked to me like using the History field type for the MyCompany.ChangeRequest.NoteLog reference field would do the trick, as in the MSDN "Field Type" article the history field is described as follows: History    Use a History field for discussion threads and for keeping track of other historical information. However, in the PTE (which I am using to do most of my customization) I am ...Show All

• Visual Studio Team System Find all Bugs that were resolved in date range

  I have created a query in Team System query editor that does most of what I want.  I need to now create an MDX query that will return the id and date a defect was changed to 'Resolved" grouped by developer.  EDITED: I have 'reverse engineered" the Bug Rates query, shown below. Question 1: What is the proper syntax for the where clause to find bugs resolved by both  "persons" Question 2: How can I find the workitem ID for the items that are "counted" in this query -------------------------------------------------------------------------------------------------- WITH MEMBER [Measures].[Date Key] AS [Date].[Date]. CurrentMember . UniqueName SELECT { [Measures].[Date Key], [Measures].[Sta ...Show All

• Windows Forms Prevent highlight on nodes with TreeView?

  I'm trying to surpress the node text highlight on a TreeView control. Setting FullRowSelect = False and HideSelection = True doesn't accomplish this -- is the only way to prevent the selection highlight from happening to override the draw mode using DrawMode = OwnerDrawAll If so, could I get some sample code that will just basically prevent highlighting of a row/node Thanks, Rob. Excellent that did the trick, thank you. Key is to make sure e.Graphics.FillRectangle(New SolidBrush(myTreeView.BackColor), e.Bounds) is done before .DrawString and selecting the same current backColor. Rob. ...Show All

• SQL Server SSL help link

  Hy guys, I've a little problem when the reporting service is install with SSL. My problem is all application links are rendered as https, with the exception of Help. How can I fix this error Someone have an idea Thanks in advance Arnaud ...Show All

• Visual Studio 2008 (Pre-release) Is there something like RenderTargetXaml?

  I'm writing an application that puts the user through a long workflow setting up a large model with many complicated parameters. This application will be generating a report, most likely in xaml based format, and I would like to copy the state of the configuration controls to the report in a vectorized format. So a function like the RenderTargetBitmap but with xaml encoder would be good. I've looked at : System.Windows.Markup. XamlWriter .Save but this saves refereces to my custom controls in the file, which isn't what I want. Any suggestions Howdy.. Do you mean that you are going to spit out a heap of XAML and you want that to then show on the screen If this is the case, then I believe th ...Show All

• Windows Forms About Threading

  I have a winform application which begin with a splash form in a new thread(I used the . When the splash form closes automatically, a login form instanates in the original thread and hold using LoginForm.ShowDialog. However, although a textbox in the Login Form() get the focus, the application become inactive(user cannot type in the textbox immediatlly). User have to click on the form or use Alt-Tab to switch to the Login Form before they can type on the textbox. How can I make the application keep its focus after the splash form close Kennon2005 wrote: Sorry that my question may be a bit misleading. Let me make it clear. I have two forms, one in each thread. How can I switch focus between the two form You have refe ...Show All