adorer's Q&A profile

• SQL Server prevent matrix rowgroup subtotals in excel export

  I have a matrix report that allows for the expanding/collapsing of the various row group levels. It is setup with 3 rowgroups and 1 column group. Date Customer EmployeeTitle Employee Sum(Hours) The Employee group's visibility is toggled by the EmployeeTitle group. Everything works as expected until I export to Excel. In Excel, a subtotal row is inserted for every group. I did not manually create the subtotal row and it is not displayed when viewing the report in the browser. Any suggestions on how to prevent the subtotal row from magically appearing in the Excel export Not yet... I'm hoping to convince my business that the subtotal row is a useful "feature&q ...Show All

• Visual Studio 2008 (Pre-release) ComboBox custom ControlTemplate

  Hi, Just a simple question (I hope). I've created a custom control (below) - basically it's just a TextBox with some extra features, which is displayed in the right hand cell of a grid, with a label in the left hand cell. It all works very nicely, and I thought it would be just as simple to do the same thing with a ComboBox. So I gave it a try, replacing the references to "local:CustomTextBoxBase" in the example below with "ComboBox"... but I'm blowed if I can get it to work - I see the Label, but there is no sign of the ComboBox.... Am I missing something obvious (I expect so.) Any pointers would be much appreciated! <Style x:Key="{x:Type local:CustomTextBox}" TargetType="{x:Type local:Cus ...Show All

• Visual Studio Team System Setting for URL in Reporting services

  Hello, When viewing the project portal and drilling down into the Work Items report, the ID links href is not showing the fully qualified URL. It links to: http:<servername>:8080/WorkItemTracking/Workitem.aspx artifactMoniker=xxx instead of http:<servername>.ucr.edu:8080/WorkItemTracking/Workitem.aspx artifactMoniker=xxx I have looked all over the server in XML and config files, Sharepoint and Report Server configuration, the database tables, and in the registry, but can't find where this value is being set. I have run TFSAdminUtil activateat, and that hasn't fixed it. Does anyone know where else I can look Thanks, James Hi Federico, I just responded to ...Show All

• Visual Studio Express Editions Weird linked libraries

  Hi, I have a VC8 project. I intended to link the debug version of a library, say WhatEver_d.lib, and this is the library supplied by Configuration Properties -> Linker -> Input -> Additional Dependencies. However, when I compile the debug version, VC8 complained that WhatEver.lib (the release version library) was not found. Of course it's not found, I didn't include the release lib directory (only the debug lib directory was included). I double checked and was 100% sure that WhatEver.lib is not specified in Additional Dependencies or Command line. What could be wrong This has puzzled me for the last two days. Sorry my fault. Since I also need to set libcmt.lib as No Default Lib, I forgot to separ ...Show All

• Visual Studio How should I go about initialising a library or DLL from an external source in VB?

  I'm having a problem initializing a library in VB. I'm currently using Visual Studio 2005 and I don't know how to initialize a library from an external source. I've installed the library, but I don't know the command to call it out. And how do I initialize DLL Thanks. Hi - Typically there are two steps to initializing a library: 1) Project -> Add Reference to the library DLL 2) Create an instance of the class or control, e.g. Dim x as New MyLibrary.MyClass The first step is to try #1 and Add Reference to your component. Hopefully you can find it either in the .NET tab or by browsing to the DLL file. Once you've added it, you'll need to find the namespace where your class or component live ...Show All

• SQL Server How to execute ssis package from stored procedure

  how to excute ssis package from stored procedure and get the parameters back from ssis into the stored procedure. Darren, I need to allow multiple users to run an SSIS package that imports a preformatted user specified spreadsheet to holding tables for further validation and return a few stats about the data. The spreadsheet name, server and db name are parameterised. Below are my notes on what I’ve found to be the available choices and would be interested in any feedback. xp_cmdshell requires CONTROL SERVER permission & sp_OACreate requires membership of the sysadmin fixed server role. However granting sp_OACreate (+ sp_OADestroy etc) execute permission to users (via a user defined role) w ...Show All

• SQL Server How to Add Subtotal in a matrix which shows all colunms nut seletd vales of total

  Hi I have a Matrix Like This Sales Type AZ CA ID NV WA OR Total No Surplus 1 2 1 3 4 1 12 Reverted 1 4 2 4 7 2 20 Surplus 2 4 1 2 2 1 12 This "Total" is of All States(AZ, CA, ID, NV, WA, OR). But I Just want the total of just four states i.e(ID, NV, WA, OR). And I also Want that States which are not included in the total i.e(AZ, CA) Should also appears in the matrix , but their values should not include in the total. I have already applied the filter on the subtotal, but (AZ, CA) did'nt appears in the matixr after filter. thanks Regard Mohammad Yaseen Hi thanks for ...Show All

• SharePoint Products and Technologies Custom view in site defination

  I'm working in custom site definition. In the site definition, I defined a Contact list and want the contact appear in the Right webpart zone. But i want to custom the view that it display in the webpart zone. That is: remove the Email field from the view. How can I do that. Thanks. Jason Yes I know how to do that in user interface. But I want to define it in the site defination (onet.xml ) So that everytime I create a site, the view and webpart in already configurated. Is it possible Thanks. ...Show All

• Visual Studio Team System Automated deployment - SDM

  Hi, I've been testing SDM features, creating logical datacenter, system, application and deployment diagrams. And I was able to generate deployment report, but here's my question: How can I do an automated deployment (install web applications, configure IIS, windows) from that Do I have to do it manually or visual studio does it for me How's that Thanks! Hello Andre, Thank you for your question. The deployment report is generated as HTML and XML. You can use the XML version to create scripts for deployment. Here are some links to technical articles and documentation about how to find the information you need in the deployment report: Deploying Applications with Dis ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Will XNA work with .......?

  hey everyone im new to this forums and i just had a quick question but if this question has been already asked then you may lock it. ok my question is i recently downloaded Microsoft Visual C# Express 2005 will this work with XNA / is that the only program i had to download for XNA.. or in other words are there any other software i need to download to use XNA on August 30th or will XNA come with the other programs Thank You very much.. Ok I have another question related to this. I have VS2005 Pro installed. I need to install c# Express to use GSE ok. On msdn for downloading c# express it states: . Uninstall beta versions Before installing, you must uninstall any pre ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vertex Animation help

  Hi, I'd like to do some simple vertex animation on a model using a vertex shader, but I'm having an extremely difficult and frustrating time figuring this out. I've been looking at the content pipeline documentation, I've found the tutorial about the BBox processor and done that a couple times, I've written a C# converter for a custom mesh format I have to X and still I can't work out how to accomplish this. I guess conceptually I understand how the content pipeline works. I ran the X processor DLL that ships with XNA through reflector and just about had a nervous breakdown looking at all the classes in there. I write geometry exporters, importers, and deformers for Maya at my day job, so I like to think I should be able to do this, ...Show All

• Smart Device Development Unable to read message body in CE 2005

  Greetings all I am unable to read the message body of Email Messages on a Mobile 2005 device. On 2003, everything is fine; however, on Mobile 2005, it does not When I do the following, I get an error IStream* istream; HRESULT hr = m_pMessage->OpenProperty(PR_BODY,&IID_IStream, STGM_READ, 0, (IUnknown**)&istream); if (FAILED(hr)) { TRACE(_T("CMAPIMessage::GetBody - OpenProperty: %X\n"), hr); return _T(""); } However, works fine in 2003. Any suggestions check here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=593988&SiteID=1 ;) ...Show All

• .NET Development ignore/remove Namespace URI

  I have a xml file with NameSpace on the root node let say xmlns="http://www.mysite.com/" i.e. < xml version="1.0" > <customers xmlns="http://www.mysite.com/"> <customer job > .... I am loading this into xmldocument whaty I want's is to ignore or remove NameSpaceURI from the Xmldocument It is making some problem in the parsing of the docuement What Can I do I am working on .netframework 1.1 static void test3() { XmlDocument d = new XmlDocument (); d.Load( "XmlFile2.xml" ); XmlNamespaceManager xnsm = new XmlNamespaceManager (d.NameTable); xnsm.AddNamespace( "c" , "http://www.mysite.com/" ); string description = d.Selec ...Show All

• Visual FoxPro Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help Go here: http://www.tvse.com/index1.asp and download the latest printer drivers for you model of printer and for your O/S. I assume that you are using one of their Indian language ...Show All

• Visual Basic debugger breaks inside try block

  This problem is really getting on my nerves. I'm a c# programmer, had this vb.net project to fix. The sources have loads of bugs and I'm suffering because of the different language. VS throws an exception with code that's INSIDE the try catch block Try Using mp3File As New FileStream(FileName, FileMode.Open) /// End Using Catch Return False End Try It will stop at the using line with file access denied exception, and there are other places where it will break although it's inside a try block. as an aside, i know that these generic non-reporting catch statements are bad but the codes are not mine and the project is full of such blocks and changing all of them is a no-starter. Any thoughts ...Show All