Evgeny Popov's Q&A profile

• SQL Server Drillthrough Query

  I have the following Drillthroug query. i require it to return only those documents that fall within a given date range for a particular customer and worktype. But all the records for a customer and worktype are returned irrespective of the date DRILLTHROUGH maxrows 10000 SELECT [Measures].[TAT] ON 0 , ([Hierarchy].[CustomerName].[ABC], [Hierarchy].[Work Type Name].[EEG] ) on 1 FROM ( SELECT ([Date].[Short Date].[2004-03-15] : [Date].[Short Date].[2006-04-10]) ON COLUMNS FROM [DW]) Return [$Customer].[CustomerName] As [CustomerName],[$Measures].[TAT] AS [TAT],[$Document].[Document ID] AS [Document ID] Hello Reena, First of all bad news: AS 2005 doesn't allow DrillThrough to be performed ...Show All

• Visual Studio Team System UNC Assembly References

  We have a centralized build server that shares out stable builds of internal and vendor assemblies. The idea is that developers can simply reference a target version of the assembly from the build server via UNC reference in Visual Studio 2005. The intention is a) centralize nightly/stable internal and multi-vendor builds in one location and b) elmintate the need to store dependant assemblies in source control (yuk) and c) allow developers to simply reference (as needed) required assemblies via UNC. The guidance is to always set Copy Local = True. The idea was that by settign Copy Local = True, the assembly would be grabbed if it wasn't already in the bin on the local disk. Well, it appears that this is not the case- Visual Studio ...Show All

• Visual Studio Copy/Paste

  Is it normal that when I selected a shape, the copy/paste operations are disabled I suppose copy and pasting of shape is not supported Is there an easy way to make it work Thanks! Mike Hello Mike, This is praveen from india. i am not able to find VisualStudio namespace under Microsoft. Can you help me in this. Thanks, Praveen ...Show All

• Software Development for Windows Vista Regarding WF Clinic 5136: Introduction to Developing with WindowsR Workflow Foundation and Visual StudioR 2005

  Dear all While I was trying to download course " Clinic 5136: Introduction to Developing with WindowsR Workflow Foundation and Visual StudioR 2005" I was not able to sucessfully do so even after many tries!. Some times thier is timeout message , other times its connection reset. Any ways I gather that many of people here may happen to download the course on thier machines , if any one have it downloaded please email me at razi_rais@yahoo.com . Please let me know if more information is required. Hi Alif The course is infact available for download , you can download the course from here https://www.microsoftelearning.com/eLearning/courseContent.aspx courseId=67819 , you need to sign in with your ...Show All

• Audio and Video Development WME9-SCRIPTING

  If someone has an answer I'd really like to know 'Am Windows Media Encoder for Streaming and how do I write script for all the sources so they change with the source instead of having to write one each the source changes.....help because I can't always sit there a write script thanks in advance Try posting your question here: http://www.microsoft.com/windows/windowsmedia/community/newsgroups/WindowsMedia/default.mspx dg=microsoft.public.windowsmedia.encoder&lang=en&cr=US ...Show All

• .NET Development reflection related query

  I am facing one problem in my project. I want to find the referenced assemblies of my current assembly. I am using reflection.assembly.getreferencedassemblies() function for that. But I can't get COM converted .net dll and c++ dlls in that. why what should I do to get that dll also............... I want that dll name anyway..........please show me some way if it's not possible in .net then is it possible in c++................... Thanks in advance..................   bhavu wrote: Dear Peter,        what should i do if i want to know programatically "all the references including COM and c++ dlls of an assembly"      &nbs ...Show All

• SQL Server New table on server not replicating to device

  Hi, I have a SQL 2005 Mobile db merge synching to SQL Server 2005. I've been using this for a few months now and generally it works well (except when adding not null columns with default values, but that's another story...). I just added a new table to the server, went into the publication articles and checked the new table. It told me I would need to generate a new snapshot for the table, so I then generated a new snapshot. Then I synched the mobile db and it worked with no errors, but the new table I added on the server is not on the mobile db (I checked using the Query Analyzer). I have also tried reinitializing subscriptions, but this didn't work either. Any ideas why this table would not be synched to my mobile db (and no error mes ...Show All

• Smart Device Development class not registered

  when i build a new project smart device -> win32 smart device project, i get the error message CLASS NOT REGISTERED. does this mean my version of MVS does not support pocket pc, or maybe the sdk is not install correctly. i got the same results........... i did not uninstall the files, before installing mvs. should of, could of, would of. should i uninstall all files, then install mvs or does just an install do the trick Im open to any ideas, i have been trouble shooting for six weeks now and im back to day one. i played with beta version for eight weeks and got the same results. so i bought a version of mvs 2005 thinking that the problems were in the beta software and not in the for sale version. i re ...Show All

• SQL Server MSResultSetGenerator does not work any more

  I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool": Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9 I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database. I use Visual Studio 2005 + ...Show All

• SQL Server Totals (or Sum) in a Function or View

  I have the following data in a table: Item Qty 1 1 1 -1 2 3 2 -1 2 -1 Using a function, how can I code it so that I get the following: Item Qty 1 0 2 1 Also, if a Qty does equal 0 (as in item 1), can I use a >0 in the Criteria field of the resultant expression to remove it from the Function results Hi, You can put a filter to your results after grouping by using the "HAVING" clause. This will help you remove the 0 summed results. select item, sum(qty) from item_table group by item having sum(qty) > 0 Eralper http://www.kodyaz.com ...Show All

• Windows Forms Changing the column type at runtime

  Hi ! I have the requirement where I need to change the column type of a cell from a textbox to column depending upon a certain situation. The datagridview is unbound and I have set the cell types of the grid to text initially. Can I change one column to a different type , like one row will have column 2 as text box and the second row will have the same column2 as combo. Please let me know. Thanks in advance ! You cannot do this without creating a custom column type. See http://msdn2.microsoft.com/en-us/library/7fb61s43.aspx for examples of how to do this. ...Show All

• Visual Basic Problem With MDI Child Form

    I am having some problems with MDI child form details are as under: How can i load a MDI child form from another MDI Child Form. I have a MDI form with one Child form, now if i want to add another form in the project and that form will be shown by pressing the button in the child form -- what i want is this new form is shown as a mdi child form not as a SDI form. How can we do that. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim F As New Form2 F.MdiParent = Me.MdiParent F.Show() End Sub ...Show All

• Visual Basic Converting code to run in .NET 2003 -

  I am having a problem with a memory leak when generating Crystal Reports documents. I found a fix here and that worked fine in one of my new projects which I wrote using 2005 but I want to use this fix in a big older project that was written in VB.NET (2003) When I try to use this code I get two problems. One is it doesn't like If ev.Target IsNot Nothing - I can probably just remove that bit and put the if statement in its own try block. My main problem is that when I run the code I get the error "Object reference not set to an instance of an object." from the line Dim domainUnloadDelegate As [Delegate] =... Any clues The code (thanks to Jiri on hugobatista's blog ) is included below... Imports CrystalDecisions.CrystalReports.En ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Shader to Mimic BasicEffect Textures

  Just in case I am overlooking the obvious, is there an easy way of getting the textures that are linked to a mesh   BasicEffect somehow knows which textures are for which part of the mesh, is this behaviour easy to mimic in a user definded shader   I have per pixel lighting with specular/diffuse working great, I just need this last peice of the jigsaw. Any help is much appreciated. I must be thick or something .... I have one mesh with 8 textures on it.  I can get the textures into an array from the mesh effects.  But I have to replace the Mesh effect like this for it to render with my effect (idea from this forum) - foreach ( ModelMesh mesh in cItem.Me ...Show All

• Visual Studio Team System How To Temporarily Disable Field Validation When Publishing Work Items From Excel?

  I am attempting to migrate work items from our old ticket tracking system into VSTS using the Excel integration feature (from Team Explorer, right-click on Work Items folder and select "Add Work Items with Microsoft Excel"). I have exported the work item data from the old ticket tracking system and converted values to match those expected by VSTS and can paste the data into Excel, matching the data to the proper columns (all cols added from Team menu). The problem is that when I attempt to publish the work items to VSTS, I encounter many field validation problems stemming from the fact that these are not "new" work items. For example, the State of most of the work items I would like to migrate is actually "Close ...Show All