James CACN's Q&A profile

• SQL Server expressions in layout view of Reporting Services

  ok Using MS Visual Studio / Reporting Services Table = calllog Field 1 = RecvdDate Field 2=RecvdTime in my layout view I have combined these two - Txt header CallRecvd (Value=Fields!RecvdDate.Value & " " & Fields!RecvdTime.Value) I have a txt box called [Today] Value =Today() (I am showing this in a box but it actually doesn't have to show at all last txt box - I need to do the following =DateDiff([ CallRecvd] ,[Today]) (error CallRecvd is not declared) not sure where I do this thanks please advise Jewel You can reference the value of other textboxes within the current or parent scope by using the ReportItems collection of the ReportObjectModel ...Show All

• Visual C++ Why doesn't strncpy(strDest,strSource,-1) generate an unhandled exception instead of instantly ending the application?

  We've encountered a problem with calls to strncpy in our business application. When a invalid negative value is passed in as a count paramater the application abruptly ends, poof! gone like a puff of smoke, without throwing the usual unhandled exception. This means that our exception handler that is set using SetUnhandledExceptionFilter() gets bypassed and we cannot retrieve dump information to aid our debugging efforts. We have recently moved to Visual Studio 2005 so perhaps the internal implementation of some of the string functions have changed I know we should be using strncpy_s however given the size of our source and the number of places where the size of a string buffer is not passed around this would be a larger task than we have r ...Show All

• SQL Server Upgrade issues

  Hi, I am trying to upgrade SQL Server 2000 Enterprise edition to SQL2K5 Developer edition. But it errors out without any detailed message. Is it because, even though the version is being upgraded the edition is downgraded, or could there be a different issue Anyone else facing a similar problem If I have to uninstall 2000 and install 2005 from scratch, what all things do I need to ensure so as no data is lost Thanks, Tanvi. Thanks Milos for your response. Would SQL2k5 setup automatically upgrade the system databases to its new format Would it also recognise the jobs, dts packages from msdb database Thanks, Tanvi. ...Show All

• Visual Studio Team System determining number of lines of code in a method - custom fxcop rule

  How do I determine the number of lines of code in a method Thanks in advance. Also keep in mind that you will need to ignore instructions with the following OpCodes as these instructions will not have source context information: _Locals, _Try, _EndTry, _Filter, _EndFilter, _Catch, _Finally, _Fault, _EndHandler. -Todd King ...Show All

• SQL Server Dynamic connection manager file name

  Hi There This should be an easy one i hope. I need to dynamically change the file name of my destination flat file connection everytime the package runs, obviously i do not want to edit the config file everytime. I think the best way to do this is by a script taks that sets the connection manager filename property with a variable that i dynamically populate. Is this the right way I just want to be sure that there is not an easier or better way to do this Thanx Sorry to be daft, but how to do you get to the setting, when I click on the flat file source, I pull up the connection manager, which doesn't have an expressions section like the others. Could someone give me a general walk thro ...Show All

• Windows Forms Inheriting HScrollBar

  Hi, I would like to create an inherited control in VS.2005/C#, to be able to paint the scrollbar in a different way. I tried the followng code snippet, which was generated by Visual Studio: namespace MyControls { public partial class UserControl1 : System.Windows.Forms.HScrollBar { public UserControl1 () { InitializeComponent (); } } } It compiles nicely, but the designer tab ( UserControl1.cs[Design] ) complains that: "The service System.Windows.Forms.Design.ISelectionUIService already exists in the service container. Parameter name: serviceType". Is it at all possible to inherit from HScrollBar I can insert that control on a form, so should I just ignore the error ...Show All

• Windows Forms tooltip intermittent in VS 2005 from VS 2003 conversion

  I have a large VS 2003 .NET Windows Form (approximatedly 10,000 interface controls and still growing). These controls are created from a database (XML). After converting to VS 2005 the tooltip feature is intermittent, mostly not working. I noticed a new initialization process in private void InitializeComponent() where ((System.ComponentModel. ISupportInitialize )( this .pbxLeft)).BeginInit(); is used. pbxLeft properties set. Then ((System.ComponentModel. ISupportInitialize )( this .pbxLeft)).EndInit(); this .ResumeLayout( false ); this .PerformLayout(); The use of BeginInit() and EndInit() seems to only apply to PictureBox controls The 10,000 controls are created and their properties set outside of ...Show All

• Visual C++ VS 8 issue

  Hi, I am having a dll which uses a static library. I am dealing with opening and closing of files. My static lib is basically third party code which I could not understand much. However, I found that it is trying to close a file which has already been closed in previous function call. Everything works fine on VS7 but on VS8 it gives assertion in close.c line 48. ["\Program Files\Microsoft Visual Studio 8\VC\crt\src\close.c"] Third party code [Its basic C code] is using open() to open the files and close() to close the files. Any idea, what can be the problem and how it can be resolved Can I put a check before calling function close() to check whether is open or not Thanks, Rama Generally, if p ...Show All

• SQL Server LEN function in a table control

  I am using the LEN( expression ) function in a table control on my report. The field "Pieces" is a calculated expression in the dataset I use : Pieces = SUM(field1)*MIN(field2) and has the "group by" set to Expression in the dataset. In my control i use the expression: Len(Fields!Pieces.Value) When I use the LEN expression on a field that is not calculated it works fine, but when I do it on this calculated field it is NULL. Can anyone shed some light on why this may be happening I'm new to SSRS and somewhat confused at the result. Michael I believe the issue is how the report dataset is rendered. I have come across various "challenges" with calculated fields within dataset ...Show All

• Gadgets "Access is Deined" error on IE7, but works fine on IE6

  My gadget needs to contact two URLs to retrieve XML content (not SOAP, just URLs that return XML). The first one is internal URL (not accessible from public) and I used {proxy:"none"} when creating network request; the second URL is public and I used {proxy:"generic"}. The gadgets is uploaded onlto galleryd.live-int.com, During test, everything seems fine when I use IE6 on an internal PC (of course with the trusted site and cross-domain settings changed). However, when I switch to an IE7 (on Vista) internal machine, even after changing the settings, it kept giving "Access is denied" error. I also tried adding the regedit trick found on the old forum, but it didn't help: [HKEY_CURRENT_USER\Software\M ...Show All

• Visual Studio Express Editions Using the \n for a line break....

  Basically, I read a part of a file, which is the description, which goes into a label, the 'description ' can be changed in the file, accordingy to what you want it to be. So, pretty much I need a way to insert line breaks between every few characters. And for some reason, \n in a file, thats read and put directly into a label, is different than adding "\n" in the compiler, onto the label...... Click on the Show All Files icon in the Solution Explorer. Open the node next to the form and double-click the Designer.cs file. Locate the InitializeComponent() function, expand the collapsed outline node if necessary. You should see the statement that generates the label Text property value. It will look ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Collision of Rotated Sprites

  Ok. I realise collision detection has been discussed quite alot, but after doing a fair bit of searching through the forums and the web, I still can't find a solution to my problem. I am working on a arial view car game (remember GTA 1 and 2 ) and I am at the point where I need to handle collisions. Most people seem to be using BoundingBoxes, which would work fine in a few situations, but in my case, drawing an axis aligned box around my rotating car would be far too inacurate. I realise that the boundingbox class does not allow rotation as mentioned in this forum, so I am wondering if anyone is aware of an alternative solution. I could solve the problem by creating a series of rotated square alpha images for my car to use when rotating, ...Show All

• Visual Studio Team System Why not property in C# and VB.NET is different?

  Dear All: I use C# create FXCOP rule add in vs2005,The rules is test property,but test In VB.NET is different from C#,who can tell me why In C# string gstrOrigEmpID = ""; public string OrigEmpID { get { return gstrOrigEmpID; } set { gstrOrigEmpID = value; } } In VB.NET Dim gstrOrigEmpID As String = "" Public Property OrigEmpID() As String Get Return gstrOrigEmpID End Get Set(ByVal Value As String) Me.gstrOrigEmpID = Value End Set End Property In C# Property ,OrigEmpID is property,but in VB.NET,OrigEmpID is Field.I don’t known why ,can you help me thanks! --Tiny ...Show All

• Visual Studio How to get icon of ProjectItem?

  Hi there, is ist possible to retrieve the icon of a ProjectItem using the DTE - Jens AFAIK no, that belongs to each VS package for each .NET language / project and it is not exposed through automation. You need to capture them with an icon editor and add them you your add-in (at least I did so for my add-in). ...Show All

• Visual Studio Team System How do you create a Global List?

  I understand that there is a way to create custom Global Lists in TFS so that you can use the Global List as a "look-up-table" when creating a Work Item Field. For example, how would you create a global list which contained a list of requirements so that when creating a Work Item, you could have a field called "Corresponding requirement" which would give you a drop down of all of the requirements from the "Global List" to choose from You should be able to find the information you need here: http://msdn2.microsoft.com/en-us/library/ms194977.aspx Hope this helps. ...Show All