NoelF's Q&A profile

• SQL Server Column Header Color

  Is there a way in SSRS to conditionally set the color of a column I want to do something like: =IFF(some condition, Color(Fields!Date, "Green"), Color(Fields!Date, "Red")) Yes you go into the Color property of the text box in the Detail row of the table and set the color to an <expression..> then in the dialog that comes up enter somthing like this... =iif(Fields!Name.Value = "Smith" , "Green" , "Red" ) if the name = smith make the color green other wise make it red the key point being that you go to the property and set the property equal to an expression. if you need more value/color options you can put in a little code in the report that you can ...Show All

• Visual Basic Microsoft Excel

  Hi, I have sucessfully exported data from a VB.Net datagrid inExcel. How can I programmatically make a particular cell have a format of just a data rather than a datetime format Rgds Bill Patridfe ...Show All

• SQL Server Unable to start SQLEXPRESS

  Hi I have downloaded and installed the trial version of MS Visual Studio 2005 Team System. The installation was successful. However, I am not able to start SQLEXPRESS using the SQL Server Configuration Manager. It shows me SQLEXPRESS but when I right click and select Start it tries to start the service and after some time gives the following error "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details." The event log shows the following errors: 1. FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the o ...Show All

• Windows Live Developer Forums Windows Live Mail Desktop BETA Syncronize problems

  Hi, I'm having problems with the desktop beta. It says I must sync and it give me the address: http://ideas.live.com and to join the notification list. I went there and I cannot find it. I'm computer illiterate when it comes to things like this. Everythign I find directs me to the forum for it, but nothing directly says how to syncronize. Can someone please just say how to do this in dumbed down terms Thanks Hi, having found that aol is considered spam by all other isp's especially to the uk, this was found recently when installing a new with vista for a client who originally got round the problem by using a relay isp that works to aol now I found that windows mail doesnt work to well with ft ...Show All

• .NET Development Update Issue

  I'm updating my data table this way: DataRow row1 = this . Ds . Tables [ "Group" ]. NewRow (); row1 [ "Name" ] = this . txtNewGroup . Text ; this . Ds . Tables [ "Group" ]. Rows . Add ( row1 ); this . AdGroup . Update ( this . Ds . Tables [ "Group" ]. Select ( "" , "" , DataViewRowState . Added )); But later when I access the added group in the dataset, the Id column(which is auto-increment) returns DBNull value. To solve this, I refill my dataset again which needs new connection to be established with sql server and it affects my application performance. Is there a way to force the adapter to update the table with the new Id TIA ...Show All

• .NET Development Phone number dialer. VOIP. Skype. Dial. Dialling etc.

  Hi everybody I need to make an application that dial a phone number and then register the response status for statistics issue (if it was connected, if the line is busy, etc) How can I manage those signals May I use SerialPort object Please, if you have some example code, I will appreciate so much Thanks in advance Dr CRs Hi, Maybe you could hook into a VOIP program like Skype to do the dialling and return the results you are after I wouln't know how to to this though, sorry, i am just passing you the idea. Regards, S_DS ...Show All

• SQL Server Can't set the owner to the current login

  I'm using express edition, compatibility set to 2005. I'm logged in as DOMAIN\user , using windows authentication. When I try to set the owner to this login, I get a "login does not exist on the server" error. Setting the owner to sa works fine. Any fix to this problem Also - can I just work with the owner set to sa or can this cause problems in the future Thanks. Buck, Thank you for trying to help. The diagrams work fine - but the thing is that I have to set the owner to sa in order to work with them. The problem is that although I am logged in as DOMAIN\user , the server claims there is no such login when I try to set the database owner to that login. ...Show All

• SQL Server Accessing Linked Excel Server

  I created a linked Excel server that is stored in a SQL2000 database. I can run the following from the SQL server with no problem. Select * From CSCNEDI ... EDI$ When I try and run the select from my WinXP computer I get the following from both SQL2000 Query Analyzer or SQL2005 Management Studio (these are configured for client access) [OLE/DB provider returned message: Unspecified error] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ]. Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Thanks David Davis Schuette Inc. Hi, David, The error above simply indicates ...Show All

• SQL Server Create the package on the server, and execute through sql server agent

  Hi, Some of you guys seem to be gurus with the new Integration Services technology, so I hope someone can lend me some advice, as I haven't worked much with integration before. Ok, here we go. What I want to do is select some data from my database and export the result to a flat file (really a .csv file with values delimited by semicolons). Sounds like a simple thing to do Well, I'm sure it is when you know how to do it :) I know I could manage the same thing by writing a C# class that creates that .csv file, but the decision has been made to use Integration Services for these kind of operations. I created an SSIS project in Business Intelligence Development Studio, and created a package (I defined the task flow etc.). By choosing ...Show All

• Visual Studio What is the properties for rebuild a solution/project

  Hi; What is the correct syntax to tell it to rebuild (not build, rebuild) a solution. To build I have: <MSBuild Properties="Configuration=Release" Projects="WindwardReports.sln" Targets="Build"/> but I don't think that does a rebuild. Same question for building a single project in the solution. thanks - dave ps - if stuff like this is answered in a url somewhere, please give me the url. Hi; Where can I find the documentation for all of this. I hate to have to ask here if this is all documented. But I have looked and looked and can't find it. And to bring in a previous post - how can I do a Rebuild on a single project thanks - dave ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is it realistic to create one's own engine?

  I'm not new to programming, but I'm new to game programming and C#. I'm wondering to what extent it's realistic for someone to make their own 3D (or for that matter 2D) game engine. The two projects I have in mind for myself are a turn-based 2D war/strategy game, and a 3D adventure game in the manner of "Dreamfall". On the 2D side, I feel confident I could come up with a 2D interface on my own. I haven't done a lot here yet, but I did manage to whip up a little 2D hockey game without peeking at Bill Reiss's excellent 3D airhockey tutorial at http://xna101.spaces.live.com/ . I've even given my computer hockey opponent a very primitive AI. OK, my collision detection and physics aren't great, but I'm not sure how much I'll need either of ...Show All

• Microsoft ISV Community Center Forums Generating Dialog Messages thru VBA over Excel

  Hi Guys and Girls, Thanks for the help so far. I'm on the last step. I need to generate fairly long dialogue messages dependant upon the data the user has entered. A sort of lok up using Inputbox which I understand and Dialogue boxes which I don't. I'm really stuck, I just need a little code that goes if data_entered = XX then .... open this dialogue box containing this text else if .... open another dialogue box else if .... another end. Is it possible to dynamically load texts to dialoge boxes rather than hard code them Again thanks for the help so far. Hamish Thanks but MsgBox is limted to what Excel offer. It n ...Show All

• Visual Studio Dynamic Image Location

  Hi, I am using Crystal Report XI Release 2 with VS2005. I know there is a new feature to change the images in the report dynamically which is explained all over in many websites. But it is not working. Whatever string I give in "Graphic Location" forumla , it is not at all displaying the image. I had tried various options like below. {Command.TableName} "File path" + {Command.TableName} ".\" + {Command.TableName} None of the above is working. And I am using only .jpeg file format only. Any one had ever tried this feature and fully succeeded Please let me also know if there is any trick in this. Thanks in advance, Sachi what does {Command.TableName} have for data ...Show All

• SQL Server Bulk Insert into a Table Variable

  I am attempting to use a table variable as a destination for a bulk insert. DECLARE @TEXTFILE_1 TABLE ( CHAR_FIELD1 varchar ( 1 ) , CHAR_FIELD2 varchar ( 1 ) , CHAR_FIELD3 varchar ( 1 ) , CHAR_FIELD4 varchar ( 1 ) ) BULK INSERT @TEXTFILE_1 FROM 'C:\TRASH.TXT' WITH ( FIELDTERMINATOR = ' | ' , ROWTERMINATOR = ' \n' ) The input file looks like: A | B | C | D E | F | G | H But the errors indicate that the input is not the issue (or at least not yet...). The errors look like: Msg 102, Level 15, State 1, Line 6 Incorrect syntax near '@TEXTFILE_1' . Msg 319, Level 15, State 1, Line 8 Incorrect syntax near the keyword 'with'. If this statement is a ...Show All

• Software Development for Windows Vista User shutdown of Vusta terminates dependant processes before ancestors?

  I read an article describing shutdown changes in Vista: http://windowssdk.msdn.microsoft.com/en-us/library/ms700677.aspx In some testing I was doing with the July CTP, I noticed that if an application (A) starts another application (B) that has no gui, and then the user shuts down, if A registers an objection (using the new api), B is still killed before A has a chance to close. Process explorer does show that B was started by A, but there doesn't seem to be any regard for this when shutdown occurs. To be more clear: 1) Application A is started 2) A starts application B 3) The user makes changes to A 4) The user issues a shutdown. A registers an objection, and pops up a message asking the user if they want to save their ...Show All