MShetty's Q&A profile

• SQL Server Help with Reporting Action

  I'm trying to set up a reporting action that when a cell is selected the corresponding dimension members are sent as paramenters to Reporting services. Once there the report will use those parameters in a select statment to show related data in the underlying SQL database. I know this sounds like Drill through to an alternate Fact table but that appears to come with some restrictions and performance impacts. If someone knows how to overcome these issues with drill through I'd rather use a drill through action. The goal is to report on the underlying detail data transaction data based on a combination of dimensions. Issues with drill through to an alternate: 1. All dimensions selected must be defined in the drill through. Instead of t ...Show All

• Microsoft ISV Community Center Forums Comparing and filtering data in Excel?

  I’ve been given the task of comparing two sets of employee data, both of which are in the same layout/format, and am required to filter out those which are duplicates i.e. should leave only new starts. I have been told that a Vlookup function can be used to achieve this but don’t know how it can Would this be easier to accomplish using VBA If yes, could I have a brief structure of the code required To elaborate, the spreadsheet contains a unique employee ID and other details such as department, manger, email, etc. One set of data is from the previous months upload and the other is the latest data pull. I need to compare this months data with last months and see who is present that wasn’t before. Any help is much appr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Doesn't Direct3DDevice9Ex support ID3DXFont ?

  I built Direct3D9Ex sample included in Windows SDK. When I run the application, I can't see any character on the window. But I found ID3DXFont::DrawText code in the source (D3D9ExSample.cpp), which wrapped CTextHelper. I tried change the code to use Direct3D9, not Ex, and I found many characters on the application. Does not D3DDev9Ex support ID3DXFont ( or ID3DXSprite ) Or other environment issue I used: Windows Vista RC1 + Windows SDK(B6000) on ATI Radeon X1600, nVIDIA GeForce 6800 According to PIX tool tracing, ID3DXFont use "D3DPOOL_MANAGED" textures internaly to draw strings. So I suspect ID3DXFont fail to create managed texture. On my environment the devic ...Show All

• Visual Basic INSTALLATION INSTRUCTIONS FOR HOT FIX 82BC09 ON WINDOWS

  i have a problem when i like to print from the report viewer tool . when the vieuwer has loaded the report and i like to print ,.. then i have to klik the print button twice. before i get a print out from the report. is there some one who nows a solution for the problem. 1.  You must have Release 8.2 (TS2M0) installed on your system before     applying this hot fix. how  i now what release i have running not yet clear to me where to download the hotfix file.     ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. GSE RTM on Vista RTM (unsupported)

  i know it's not supported ... but has anybody got it to work bought the club account on the 360 and downloaded the app on the 360. installed Express on Vista with no problems and registered. tried an update, but didn't see any service packs. then i installed GSE, which complained about the VS projects, but it still seemed to install. fired up Express and the XBox 360 Starter kit project was there and built fine. went to tools options, and setup the connection to the 360. then i set the 360 to listening mode. but when i try to deploy, it just comes back and says make sure the the 360 is listening. also, turned off the vista firewall but got the same results. any ideas Thanks, casey By the ...Show All

• Visual Studio Reporting Project Differences with report

  Hi Frenz, I wanted to know if we can through command line find difference between two projects such that we can check whether contents of a file in the project (for eg a.txt) in $/pro1 has differences with file in the project (for eg a.txt) in $/pro2 in such a way that it generates reports betwwen the same files. For Eg 1)a.txt in $/por1 has the following contents abc abc1 2) a.txt in $/pro2 has the following contents abc bfe hjk now the command line code should be such that it should check whether contents of a.txt of $/pro1 is present in a.txt of $/pro2 but not vice versa. so it should mention in the report that abc1 is not present in a.txt of $/pro2. Please shed some light on how to do it. Thank you. Regards, Rajiv. ...Show All

• Visual Studio Tools for Office How can I find out if Word is loaded in Outlook?

  I'm creating Word Addin with VSTO 2005 SE. I need to disable some functionality in case Word loaded in Outlook (when I compose email for example). How can I find out if Word is loaded in Outlook   Thanks, Victor Mike Morton - MSFT wrote: Hello vitich, did you get your question resolved Mike I think I found an answer for this question. But I still can completly figure out how CommandBars in Word works. John R. Durant - MSFT wrote: Victor, I use the IsWordMail prop on the Inspector object. This will return a boolean telling you if Word is the email editor. Here's a link to more resources to help you: http://blogs.msdn.com/johnrdurant/archive/2005/12/07/vsto-outlook- ...Show All

• Visual Studio Team System VSDB Output file path

  I am trying to figure out the Output path of a built VSDB project. I can get the IVsOutputGroup for the “Built” configuration. and call the get_KeyOutput method. This always returns an empty string. If I have a C# project it returns the correct assembly path. Is this a BUG in VSDB Or should I get a different inferface for VSDB Thanks. ...Show All

• .NET Development DATA SET

  Hai, I have doubt in dataset(data layer) creation in asp.net2005. i need example for data set like, 1.How to create the dataset. 2.how to write the methods in the dataset. 3.how to call these in aspx froms. Do you mean ado.net dataset Or what kind of dataset If you want to know ado.net dataset, You can see this aritcles in msdn... http://msdn2.microsoft.com/en-us/library/zb0sdh0b.aspx ...Show All

• Windows Forms How to improve the drawing process of my panels?

  Hi, I have some panels with a lot of labels and buttons. Each time I bring a panel to the front, it takes several seconds to be drawn. This is very annoying, since while it is being drawn lower layers, sometimes even the desktop, shine through the panel background in the label and button locations. Are there ways to either: - speed up the drawing of a panel and all its controls; - prevent lower layers from shining through the panel background while the controls are drawn; - draw the entire panel while it is invisible and then show it all at once Will things improve if I don't use controls at all but write/draw directly on the panels (and then identify the 'sender' of an event by checking the location o ...Show All

• SQL Server Web Sync: strange behaviour with the snapshot size

  Hi There's *strange* behaviour with snapshot size during subscription initialization. So... The initial snapshot has size about 9Mb at the publisher. After subscription creation, I notice that the subscriber downloads about 21 MB. It seems to me, that the snapshot is unpacked on the IIS, next, part of the files are packed again and just after it the changed snaphot is sent to the subscriber. Why How it can be solved It brings some extent nuisance... Thanks Paul unlikely. It happens for all cases - for the subscription which was created on empty db, for case when I created subscription right away after snapshot creation, for case reinitialization, etc... Always I have ...Show All

• SQL Server How to enforce SQL Server 2005 to use Worktable?

  I have a problem in SQL Server 2005. In some cases SQL Server produces an execution plan of complex query (8 joins of views, some of views contains couple of joins) which does not contain a woktable creation in tempdb. As a result time of query execution increasion for about 5 seconds to about 4 minutes. All necessary indexes are created. It sims all data located in cache. Is there any way to enforce SQL Server to create worktable Query SELECT [a0].[id],[a0].[Priority],[a0].[Heading],[a0].[DocumentDate],[a0].[LastName],[a0].[FirstName],[a2].[Name],[a1].[Position],[a4].[ContactTime],[a4].[Subject],[a0].[WorkPhone],[a0].[MobilePhone],[a0].[FaxNumber],[a0].[PrimaryEmail],[a5].[ContactTime],[a6].[Value],[a7].[id],[a7].[id_class],[a8].[id ...Show All

• SQL Server Replicate column to subscriber - even it if is unchanged in UPDATE statement

  Set publisher database table column to 1. Replicate table to subscriber (column is also 1 on subscriber once it is replicated). Set subscriber database column to 2. Update publisher database column to 1 (even though it is already 1). Change is NOT replicated to subscriber (it stays at 2). This means that replication is comparing the insert statement to its current value in the database. Is there any way to change this behavior We want the the column to replicate to the subscriber. Peng, What a great stored procedure! It turns out that the command that is sent to the distributor for replication only contains the fields that change. For instance: Table has the fo ...Show All

• Windows Forms UserControl - Hiding certain properties (design mode)

  Hi I have an UserControl , A . This control consists of a TextBox and a Button . A has several user-declared properties, p1 , p2 ... pn . When I add instances of A to a Form, I see all the properties including p1 - pn . If I make another UserControl , B , and add several instances of A to it, how do I get only certain properties of the instances of A visible in the properties window of B For instance, B contains: A a1, A a2, A a3 ; public A A1 { get { return a1; } set { a1 = value ; } } (and so the same for a2 and a3 ) In B 's properties window I only want p1 - pn to be the displayed properties for A1 - A3 . I hope my explanation is understandable :) Kind Regards Thanks, that hel ...Show All

• Visual C# how to return null from a constructor

  say, i a m trying to do something like: class something something(streamreader){ if (wrong format or end of file) caller receives null as result else build object from what has been read in file } i tried 'return null', but it says it can not do that since a constructor is 'void', so i can not place a return sentence. i'm not sure something like this.dispose would retunr a null, since the 'dispose' may be asynchronous (or something) i have the next alternative class something blah blah somehting(string) (build object from string, check if string==null or wrong format before calling) static bool checkformat(string) check to see if string is adecuate to build somet ...Show All