cmsmith81's Q&A profile

• SQL Server Running value

  Hi In my report I have the total column,under the total i have two sub fields:no , Row%and i have another column Cumulative total sub fields are no,***% For the Row % under total i write like this: =Round((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100,2) For the *** % under cumulative total the expression is: =RunningValue((Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)/Sum(Fields!Male.Value+Fields!Female.Value+Fields!Unknown.Value+Fields!Invalid.Value)*100, sum , "AgeByGender" ) But i am getting this error: The Value expression for the textbox '* ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Managed Direct3D 10

  Since XNA only supports DirectX 9.0 Where is Managed Direct3D 10 I hope there will be Managed wrapper for Direct3D 10 thanks There are signs that after the unmanaged version of the Direct3D 10 API seems stable now Microsoft has start working on the managed one. I am sure we will see a beta in a future DirectX SDK. Anyway as I wanted a managed wrapper before I have written my own. There is an older version over at MDXInfo . But as it is not compatible with RC1 and the August SDK it will hopefully updated in the next few days with a more complete version. ...Show All

• Windows Forms how to get Office Accounting combo boxes?

  How can I get a combo boxes similar to the one used in Office Accounting with Multi Columns and typing feature For look and feel check out Ascend.Net on codeplex for their shareware winform controls. Otherwise you may have to pony up and buy a third party component provider. ...Show All

• Windows Forms Generate barCode

  Hi, I want to generate a barcode image (with vb.net) and print it with crystal report or with report in visual studio 2005 windows application project Can any one help me in this issue previously thanks. Hi, Thanks for the answer but, I have a problem with the barcode generated by the Barcoding font , the problem is the barcode reader can not read this barcode. Is there any way or may be another fonts to generate a barcode and a barcode reader can read it normally If it is possible please tell me with some details Previously thanks ...Show All

• SQL Server DB Maintenance Plan

  I have a SQL 2000 server that has a small but very important database (about 5GB). The current maintenance plan does trans logs every hour and full every day. Currently they are to file on the same drive array. I would like to send them to a share on another server just to be really safe. Would it be better to 1. Redirect the maintenance plan so that trans logs and backups go directly to the share or 2. Keep the maintenance plan back ups to the current location and write a script that runs every hour and copies the .bak files to the share. Also, since the database is so small should I just do full backups every hour instead of transaction Thanks for the tip regarding backup types. What about getting the backups off ...Show All

• Visual C++ Need help compiling 64-bit C++ Code in VS2005...

  Hello generous helper! I am trying to figure out how to port my code from 32-bit VC++ 6.0 to unmanaged C++ 64-bit VS2005. I have found the preprocessor definition changes and the linker changes, but I get errors compiling, like: error C2371: 'size_t' : redefinition; different basic types I get the feeling that I am doing something horribly wrong, even when I try to make a "Hello World" program, its not working out for me in 64-bit... Does anyone have an unmanaged C++ VS2005 Project in 64-bit that does "Hello World" just so I can see how it is done Thanks! - John This won't work because you are still going to be using the 32-bit tools to build the project. To build a 64-bit application you need to use ...Show All

• SQL Server New install shows nothing when I go to http://localhost/reportserver

  I get a page that looks like a directory browsing page and it says Microsoft SQL Server Reporting Services Version 9.00.1399.00 at the bottom. Any ideas report manager URL should be http://localhost/reports you can also select "Reporting Services Configuration Manager" from the start menu -> "Microsoft SQL Server 2005" -> "Configuration Tools" to view your virtual directory settings. ...Show All

• Visual Studio Were is _2_RTL_x86_enu_Visual_Database_Tools_Core.cab? VS2005

  My installation of the MSDN academic version of the Visual studio2005 standard always crashes, because the file cannot be found. It is not on the iso image of the CD. Anyone an idea where I can find the file and how to finish the installation ...Show All

• Visual Studio Team System TF54000: Cannot update data because the server clock may have been set incorrectly. Contact your Team Foundation Server Administ

  How do I fix the following error TF54000: Cannot update data because the server clock may have been set incorrectly. Contact your Team Foundation Server Administrator. The help I got from Microsoft, I would like to share with is as given below Basically, for WIT and for SCC, if the clock time was advanced on the server (say, to 2008), and the user wrote changes (checkins, workitem saves, etc), then the user can be blocked on further updates until the issue is fixed on the server. e.g.: - Revision 3 of workitem was at 1/2/2006. - Clocktime advances to 1/2/2008 - Revision 4 is at 1/2/2008 - Clocktime is corrected to be 2/2/2006 - User tries to save revision 5 of the item : we block it because it could result in revision ...Show All

• Visual Studio Team System Viewing stored procedures via wizard when adding Crystal Report in VB .NET 2003

  Hi there, I hope this is the appropriate forum... I have a problem... I always used to be able to design my Crystal Reports within VB .NET 2003 linking them up to stored procedures I create beforehand. (Database = SQL2000) Ever since I reformatted and reinstalled my PC I can ONLY access the tables within my database, and NOT the stored procedures I need to see when using Crystal Reports! Before reinstallation I was able to see the stored procedures without problems... It is the same detached and attached database and the same code with which I am connecting The user I am connecting with via the wizard definitely has all required privileges to the stored procedures, but they are not viewable and accessible any more and I ...Show All

• SQL Server Stuck between "Failed to generate user instance" and "An attempt to attach...failed"

  I wrote an application using Visual Studio 2005 beta 2 which uses a SQL Express .mdf file, included in the project, for the database.  After installing Visual Studio 2005 RC and the SQL Express that comes with it (I followed all of the uninstall instructions first) I can no longer add a SQL Express database to any of my projects, nor can I open the SQL Express database in my original project.  When I try either of these tasks, I get the "Failed to generate user instance of SQL Server due to a failure in starting the process for the user instance.  The connection will be closed."  I read the thread which dealt with this error, and changed the connection string for the database file that had worked before to User Instance ...Show All

• Windows Forms Bug in VS.NET 2003?

  Ok I had some time to make a sample project to demonstrate what I feel is a bug. Either that or I am doing something wrong here. http://www.myshack.net/fotty/VSBugSLN.zip Here is a link to a simple windows form app project and class library project (both part of same solution) Zip contains only the uncompiled project files. the class library contains 1 class which extends to textbox class (just makes the font red, this is just to illustrate the fact that its a class inheriting from a control) the windows forms app contains just 1 form, and references the class library project. Open the project, and compile it in debug mode prior to viewing form1. This is because the class library DLL needs to be compiled before it can be used on the fo ...Show All

• Microsoft ISV Community Center Forums Building dynamic forms in Access

  I need to make dynamic forms in access. For example i have a query that selects a user and 3 jobs he has. So the result in the query has 3 lines. Now i want for those 3 lines 3 different textboxes. Is this possible in VBA or not I already searched the help of access it self and i cant find anything about it. thx for your help in advance. look up parameter queries with forms on the microsoft knowledge base - link your front end forms to the query at the back end and let the user input the information in to the form that will then write into the query behind and produce the information you require on to a form dynamically - i have used it a heck of a lot when building the new company database and ...Show All

• Smart Device Development Application Icon in Start Menu

  hello. Can someone tell me how can I set an icon for an application in the Start Menu Folder I am making a cab file for instalation and in this file I put the icon too. when I install the cab file on my device, in Start Menu Folder I see the generic icon for executabiles files. Thanks. Did all that and still no icon. It puts the icon in my project but no icon in the Start Menu. :( If I deploy the application on the device, the icon appears... but if I install the cab , I see the icon in the instalation folder but the application has the generic exe icon. ...Show All

• SQL Server update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget Pig, What are the datatypes for the following columns: caseNumbers caseNumTypeId caseNumber My guess is that one of the fields -- maybe caseNumber -- is a varchar and contains the string '9368----'. Dave ...Show All