Sylvain in Ottawa's Q&A profile

• SQL Server Multi Select

  Hi, In my report,I have multivalue parameter for this parameter the Available values are from the Dataset.Suppose the dataset contains Names like this: 'AL - Alabama Center (Tuscaloosa)', 'AL - RegionalControl Center (Birmingham)', 'AR - Arkansas Poison & Rock)', 'Arizona Department of Health' But my problem is the Multivalue parameter TextBox is of fixed size.Now i want the size of the text box to the size of the name which is of length long in the Name. Whether it is possible or not. How to achieve this. ...Show All

• Visual Studio Column Charts and other Report Viewer Controls

  I created a VB.net application whose main purpose is to produce reports to give to my students at a language school. These reports are meant to show how they stand against the class average. I initially I used excel, but there are limitations there that VB.net does not have. However, I have run into a wall when it comes to producing Charts. Therefore, can I do the following with Charts in VB.Net (VS2005) (LocalMode) with the ReportViewer control: 1) Create a combo line/column graph I want to have the class average in sectors (ie, fluency, vocabulary, expressions) and the line being their actual score. And can these be overlayed like in Excel. 2) The datafields and series confuse the heck out of me. My logic tells ...Show All

• Internet Explorer Development ActiveX load fails in IE 7

  Hi All, Signed ActiveX control fails on load in IE 7 ver 7.0.5730.11 running on Windows Server 2003 Enterprise Edition SP1 I tried adding my site to Trusted Site Zone and enabling the following settings; i) Automatic prompting of ActiveX Controls ii) Download Signed ActiveX Controls I tried both the security setting of IE 7 i) "Internet Explorer Enhanced Security Configuration is enabled" ii) "Internet Explorer Enhanced Security Configuration is not enabled" but still it fails to load the ActiveX control. Also I checked the IE 7 behaviour by using a tool called "Microsoft Internet Explorer Compatibility Test Tool", it shows the ActicveX Blocking message. How do I unblock ActiveX to work in I ...Show All

• Visual Studio Team System Can not retrieve the list of team projects

  Hi, Our TFS having been run smoothly for months until password changed for some services. Now we can not connect TFS with the following error message. TF31001: Team Foundation cannot retrieve the list of team projects from Team Foundation Server. The Team Foundation Server returned the following error: The request failed with HTTP status 503: Service Unavailable. The state of TFS AppPool is Stopped in the IIS Manager. Checked Event Viewer on TFS, got the error log as below. Event Type: Error Event Source: Tfs Event Category: None Event ID: 3059 Date: 2006-11-14 Time: 11:44:37 User: N/A Computer: CD701 Description: TF53010: An unexpected condition has occurred in a Team Foundation component. The information con ...Show All

• Smart Device Development LinkId=26320 not found (Windows CE Emulator)

  I am trying to use Microsoft's eMbedded Visual C++ 4.0 on WinXP SP2 and it is giving me a driver conflict error. The error I get says: Virtual PC/Windows CE Emulator: "A driver is installed that causes stability problems with your system. This driver will be disabled. Please contact the driver manufacturer for an update that is compatible with this version of Windows." The message also displays a Contact Information link: Web Site: http://go.microsoft.com/fwlink/ LinkId=26320 But the link is no longer available . A phone number is also listed (to Microsoft) but I can not get an answer since I am not an MSDN subscriber. Some research into this problem has infomed me that Microsoft and Sun have settled ...Show All

• Smart Device Development pda and datagrid

  Developing a simple pda app using a datagrid(MsFlexGrid would have been better but not supported by vb 2005 correct ). I need to populate the grid with a simple table the user selects a number from. 1. it appears i need to create a database to do that correct 2 will Excel work for the data base if so how please and what format do i save it in 3. how do i import it 4. how do i get the numnber the user double clicked on Thanks Mitch thanks for your best!!! Just found out that what I erally needed is datagridview as in a regular app.... PDA does not support that does it IOf it does how do I get it and use it Datagridview is simple to edit columns and rows but the only option I ...Show All

• SQL Server Leaf level calculations

  Need to calculate datediff([base measure date], [user selected Time dimension level's end date]) for each leaf-level member. e.g. datediff([base measure], [selected Year's end date]) Year End Date is an attribute of the Time dimension Cannot have this multiplication in the dsv named query since user's selection is not known then. Member expressions can only have the form measure1*measure2 or measure1/measure2 In the calculations script scope(base measure) scope(leaves()) scope(base measure) this = datediff("d", base measure, CurrentTimeMember.Properties("end date")) end scope..... does not work since CurrentTimeMember in this context becomes Date, whereas selected Year is required and its end date for t ...Show All

• Visual Basic auto hide toolstrip

  Hi, I am trying to create a beautifull program interface using VS2005. I plan to create autohide toolstrip, but i can't fing how. Anyone know to do this, please kindly help me thank you Private Sub Form1_MouseMove ( ByVal sender As Object , ByVal e As System . Windows . Forms . MouseEventArgs ) Handles Me . MouseMove If Me . ToolStrip1 . Bounds . Contains ( e . Location ) Then Me . ToolStrip1 . Visible = True Else Me . ToolStrip1 . Visible = False End If End Sub ...Show All

• Visual Studio Team System Project/TFS Integration issue - please help

  Ok, this is my last effort before opening a ticket with Microsoft and spending the rest of my life on the phone with them. I have Project Server setup, and I have it receiving its data from TFS. The data is replicating between the 2, etc. Here is the problem. When I click "Refresh" on the Team plugin for project a couple times, the data will change. Here is an example: I have a work item with Actual (Completed) Work set to 8 hours. This shows in TFS. Refreshing it in project shows the 8 hours fine. However, if I refresh again it changes it bakc to 0. Clicking refresh 2 more times sets it back to 8, hitting it again makes it go back. This happens with most of the work items, and I cant for the life of me figure out what it is. ...Show All

• SQL Server SSRS: Generate Report Without RDL file

  Hi all the good people here, Can I generate a report without having RDL file physically at the server According to any "Generic Report Builder" logic, the report builder must stores the properties of Report in one form (RDL/XML) or the other (in database) and at the time of generating the "Report Output", builder must be reading those properties, assigning those to any class object's (say objRPT) properties/members and calling the method to generate the report in perticular file format. I need a way where I can assign these values stored in the database (i.e. meta data of report is stored in database) to the objRPT directly. Can I do that. I need this because I want to see whether I can switch from "Act ...Show All

• .NET Development ERROR : ISessionIDManager.InitializeRequest has not been called for this request yet.

  Hi, Can you Please help me on this error. When i refresh the page, its loading fine. Any guess please. Server Error in '/public' Application. ISessionIDManager.InitializeRequest has not been called for this request yet. In each request, please first call ISessionIDManager.InitializeRequest before calling other methods. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: ISessionIDManager.InitializeRequest has not been called for this request yet. In each request, please first call ISessionIDManager.InitializeRequest ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. "The project type not supported by this installation"

  Any clues as to the cause of this error whenever I open templates Beta 1 project files are not compatible with beta 2 project files. You will need to recreate the project and use Add->Existing Item to add your source code files (plus the necessary code changes due to the API changes) ...Show All

• Gadgets What is the best way to handle mouse in and out my gadget

  Hi, Currently, I get stuck with this problem. What is the best way to detect mouse in and mouse out on live space gadget Inside the gadget, there are many children elements but I only need to know when mouse is out of my gadget and when mouse gets in. Thanks, Bao Nguyen Try attaching onmouseover and onmouseout to your root div (p_elSource), with their respective handlers to do whatever you need done on enter and exit. ...Show All

• SQL Server Excel "Saved as Web Page" import

  I am trying to import spreadsheets from web pages on a regular basis. I do not have any control over their format but they have all been saved as web pages from Excel. There are two parts to this: a) Downloading the files b) Importing the downloads Right now I am focusing on b) Importing the downloads. I have tried 1) Using an Excel connection in DTS 2) Using OPENROWSET to access the spreadsheets more directly from TSQL 3) Using a linked server to the file. All of these seem to use the OLEDB 4.0 provider and they all work if I convert the *.htm file to a *.xls file using Excel first. With one curious exception none of them work from the *.htm files. DTS is the exception, if I first open the *.htm files in Excel the transformation task succ ...Show All

• Visual Studio 2008 (Pre-release) Not able to get "A Visual" from VisualCollection object, although it exists

  I am drawing lots of custom visuals; some using custom geometry objects using streamgeometry and some are drawn using plain vanila draweclipse using drawingContext. Once all of the above objects are created and displayed on the form,On hit testing I am not able to reference back any of the objects created by the streamgeometry. None of this working ... _currentVisualCollection.IndexOf((Visual)_hitResultsList ) _currentVisualCollection.Contains(((Visual)_hitResultsList ) Using VisualTreeHelper .GetDrawing(visual), i do get the visual back but I cannot do anything if I cannot locate the same visual in the visualCollection and remove it as I need to update the layout. Any leads.. Hopefully this post will catch any M ...Show All