Michael_Giagnocavo's Q&A profile

• SQL Server Search functionality in Reporting Services Report

  I am creating a simple report in reporting services. It contains basic fields such as first_name, last_name, ID#, location. Is there a way to create a search/find function that lets me input a field and it will find the results from any column I think I can figure out how to search by 1 single column but want the user to input one thing and search multiple fields. For further clarification...if they know the last_name, but want the id#, they can search for last name and get all the columns for the particular search....same would work for, if they know the ID#, but want the last_name, they could search for ID# and get all columns in the result. Is this possible ...Show All

• Software Development for Windows Vista AudioVideoPlayback problems in C#. Audio, no video.

  I am using Microsoft.DirextX.AudioVideoPlayback in a C# application. I believe I am using the Direct X 9.0c August 2005 version. When I play a movie I hear the sound but I do not see the movie. If I move the form I see a ghost image of the movie behind the form but that is it. The C# code is pretty straight forward and simple so I am not sure what it can be. I tried a ".WMV" file and a ".AVI" file, both of which do the same thing. I can play both files just fine in WIndows Media Player. The code follows. Anyone have any idea string path = GetVideoRoot(); if (video != null) {video.Dispose(); } if (File.Exists(path + videoPath)) { lastVideoName = videoPath; ...Show All

• Software Development for Windows Vista Windows Installer - "Change" action does not require admin password in "Programs and Features"

  Why does Windows Vista not prompt for admin password when selecting "Change" in "Programs and Features" Even a limited user is able to add or remove features from our installed product. The strange thing is that the installer prompts for elevation when installing and uninstalling. This appears to be a bug in Vista only (and a pretty serious one at that). On XP, only an administrator can change the set of installed features. Our installer has ALLUSERS set to 1 and ARPNOMODIFY set to 0. Mike Morrison Thanks for coming back... and posting I did some research and have a lot of information. Actually, for MSI based setups, non-admins can change (add/remove features) to their hearts conten ...Show All

• SQL Server Distinct Count in a new Measure Group

  Here is the situation: I have a cube that has transaction level data and there is a control number that goes with this data, but it isn't one for one.  If I have 60 million rows in the fact table, I have 50 million control numbers in a control number dimension. I would like to be able to slice the data by date (for instance) and then do a distinct count on the control number dimension.  I can do a distinct count w.o having to do a join of course because I can count the distinct instances of the key to the control number dimension. One more note - the control number dimension is not a degenerate dimension...it is not one to one on the fact table. I would like to use the DISTINCT COUNT measure in SSAS, but it makes me c ...Show All

• Visual Studio Tools for Office Developing Smart Tags for Office 2007?

  Hi i need litle help. I need recognize by smart tag the person name and replace it by email address on acction event. Can any body help me Early i use a VSTO.CTP and use the document level smart tag to do it. But i undertand the CTP is dead and not supported more. The recomended SDK is VSTO2005 SE. Did VSTO2005SE support application level smart tag I undestand is as negative. If i implement the appLevel Smart Tag in COM interfaces i dont undrstand how i replace the recongnized text with another. All code samples open a Internet Explorer. To create a document-level smart tag, you need to have VSTO 2005. A how-to for this task can be found at http://msdn2.microsoft.com/en-us/library/ ...Show All

• Visual C++ Running a very simple Win32 app... / VS2005pro & MFC: Same thing?

  Hi! I have installed VC++ 2005 Express and the Platform SDK according to the instructions on MSDN: http://msdn.microsoft.com/vstudio/express/visualc/usingpsdk/default.aspx Compiling and running the following program on the dev computer works like a charm: http://www.winprog.org/tutorial/simple_window.html I then changed to release-mode, turned off debugging in the project properties and copied the .exe to another computer without VC++ 2005 Express on. I pretty much expected problems, so I wasn't very surprised when I got the error message saying that there was something wrong with the program configuration, like the one here: http://forums.microsoft.com/msdn/showpost.aspx postid=23371&siteid=1 I have since then combed this forum and ...Show All

• Visual Basic Refactor - cannot get it to work

  I just loaded Refactor on my system that has VS 2005 Pro on it. After starting VS2005 I edited a few projects. I placed the cursor on a line and pressed Ctrl+~ , but nothing happened. I even created a new project, added some code, and pressed Ctrl+~ ...again nothing. I have even rebooted (when all else fails). Still cannot get it to work. Any ideas would be appreciated. Thanks, Tom Yes, it's very cool. In fact I may well buy the Pro version in the near future because 1. You get about 50 or so refactorings. 2. It supports C#. 3. It supports both VS 2003 and 2005 And as I work as a contractor I'm likely to be working in all these scenarios in the next couple of years, i.e., using VS 2003 ...Show All

• SQL Server Question about reportBuilder (Installation)

  Hi ! I've already ask this question a couple of weeks ago but nobody answer me so i'll ask again . We have a web application using ReportServer. Some of our client want to be able to create their own reports and to add them. So we thought that ReportBuilder could be a good idea. We would create model for them and using ReportBuilder they could create easily their reports. My question is how can i install ReportBuilder What i mean is reportBuilder seems to be working fine when he is install on the Server. What i want is to install ReportBuilder on different computer and configue ReportBuilder to connect to the Server. Is it possible How Do we need to buy licence Thanks ! Rob68: Please see these MSDN a ...Show All

• .NET Development ComException when running web service

  I have created a web service using visual studios 2005 that uses a non-cls compliant .net assymbly (it's an assymbly that comes with our database application, so I can't change that). My web service runs fine until I try and access this assymbly. I get the following error: Message="System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException (0x800A0030): Retrieving the COM class factory for component with CLSID {C9197B17-5EFC-11D2-BCEB-00E0290E133D} failed due to the following error: 800a0030. Does anyone know what this error means or how to resolve it Thanks, Joe I'm also getting the following error: System.Web.Services.Protocols.SoapE ...Show All

• Visual Studio Express Editions No template information found - Unable to use New Project Starter templates.

  Searching through forum issues for this problem (because I have it with my new VB express download), I see many have had the issue, and the suggested fixes ( which I have tried) don't seem to work. Any suggestions I've posted a work-around solution for the specific problem that I encountered. Review the thread at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=817627&SiteID=1 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. how to render text to a surface that can be mapped onto a quad in world space?

  can someone give me some source code or an sample with C++ language thank you! It's call Render to Surface You create a texture with the flag RENDER_TARGET You Get the Surface of that Texture You specify the RenderTarget of the Device to use this surface You draw like you would for the normal render so you need to use Begin and End You use the Draw text function you like, any of the sample will do Once this is done you simply use the texture as any other texture Make sure you prepared those texture in advance and not in the loop of Begin and End of the main render... ...Show All

• SQL Server problem in connecting two sqlserver

  Hi,..Please help me.. We have two server on pulbilc ip A , B in other country, and there replication will working fine. But i want to replicate data from one online server(A) to my local office(in my country) server(C). means from public ip to private(A->C). then some one told me that you have to put both server on public for replication. after the i put my local server(c) on public ip. but now i am facing the problem that i am able to connect C to A(means my office server to other country server) but not able to connect A to C(means other country server to my office server). when i am connecting from A to C then error shows is "defaut sqlserver server does not allow remote connection". I have change all the sql setting ...Show All

• .NET Development Yesterday's date using Java Script

  Hi I want to validate whether the entered date in the textbox is lessar then todays date. How can i do this. Help Me Thanks Below is the code snippet function compareDates() { var now = new Date(); var today = new Date(now.getFullYear(), now.getMonth(), now.getDate()); var userDate = new Date("11/8/2006"); // Get user date in mm/dd/yyyy format if(today.getTime() > userDate.getTime()) { alert("User date is less than Today's"); } else if (today.getTime() == userDate.getTime()) { alert("Dates are equal"); } else { alert("User date is greater than Today's"); } } If you need more on Date Objects members ...Show All

• SQL Server Truncate or clear the indexes in variable table

  i have a variable table Declare @tbl1 TABLE( RowID INT IDENTITY(1, 1), SerialNoFrom nvarchar(50), SerialNoTo nvarchar(50)) After i delete From @tbl1 the indexes still remail unchange...how can i clear the indexes in variable table. Please advice Louis Davidson wrote: I can't find any way to do this, but here is a method that you might be able to use by maintaining an offset for each insert (I assume you are doing this in some sort of loop). Alternatively, consider stop using identity and use ROW_NUMBER if you are using 2005 to generate your unique values: SET NOCOUNT ON DECLARE @offset int set @offset = 0 DECLARE @tbl1 TABLE ( RowID INT IDENTITY(1, 1), Ser ...Show All

• SQL Server sql server 2005 set up failover cluster

  We have sql server 2005 installed locally on 2 servers and want to set up failover clustering. Do we need to uninstall what we have then install as failover cluster Thanks. It may be unnecessary. I assume you have already installed two standalone instances SQL Server 2005 on the cluster nodes. As standalone instance and cluster instance can be installed side by side successfully on a cluster. So it is unnecessary to uninstall standalone instances and install cluster instances. Why may it be unncessary It depends on your system resources such as physically shared disks, IP addresses, etc. If your system does not have enough resource and you want to install cluster instance, then it is required to un ...Show All