Javier_Uy's Q&A profile

• SQL Server Error on Export to Excel with Bookmarks and Navigation Jumps

  Hello All, We're running RS 2005. I have a problem in a report using two main sections. There's a top level report, made up from 4 tables within a rectangle. The second section of the report contains the detail of the calculations making the top level figures. The second section of the report contains bookmarks and jump links to drill to different levels of the reporting structure. This works fine. The top level of the report also has jump to bookmark links to drop into the relevant section of section two, and display the detail. The problem I'm having is that although the jump links work fine within report manager, the report will not export to excel from report manager. It errors with the error at the bottom o ...Show All

• SQL Server Saving Carriage Return in a nvarchar field (SQL Server 2005)

  Hi, As you can see, I'm totally new at Sql Server. I have a problem, I store text into a nvarchar field (could be a 200 or 20,000 characters long string), inside the text there are several carriage returns which I would like to preserve to later presentation, but when retreiving the data from sql server I got the "cr" as " ", also I opened the database from Sql Managment and all cr's were saved as " ". What can I do to preserve the cr inside each field Thanks in advance. Hi George, Yes, you'll have to replace the vbCrLf with NCHAR(13) in the query/parameter string. It's not obvious, but if you look closely in my previous post, the NCHAR(13) is now encolsed ...Show All

• Smart Device Development Windows Mobile 5.

  Hi , I tried to pair the Blue tooth Flodable keyboard with HP iPAQ RW6828 getting the error message " unable open port com1 c = 55 " Using windows mobile 5 Anyone has Resolution Please help Thanks Raja. Checkout this sample code http://msdn.microsoft.com/library/en-us/mobilesdk5/html/mob5samBluetoothDeviceDiscovery.asp Manav ...Show All

• .NET Development Control the XML using HTTP POST NOT SOAP??

  Hi: I'm trying to learn how to send a specified chunk of XML to a Web Service (.asmx) page and then have that page return a specified response chunk of XML. My spec is to use HTTP POST, not SOAP so I'm stuck with that. I can't figure out how to tell what exactly the client is sending me (how do I debug with a client sending specific XML using HTTP POST) The client I'm using currently is just a straight .htm page with a form in it. The action statement of the form is the URL with a /<methodName>. How can I see what the .asmx page sees When I return a chunk of XML, the .NET Web Service first reformats it as a string that's usable within XML (ie. > = & gt;) and then wraps it in a valid XML string tag. I have a specific D ...Show All

• Visual Studio Express Editions Windows layout bug when running the application

  I have a problem that's driving me nuts! When i run my application in debug, all my windows ( properties,Solution explorer,locals,call stack,output, database explorer...) are going all over the place (in floating mode) on my main window. Even if i reset the window layout using the reset function, it still don't work. I try to fix it using the guide diamond to dock the layout window..same thing, the settings are not saved and the windows are going all over the place in floating mode. I also imported *.vssettings from another computer where the application and layout is running good and it still don't work. I reinstalled VB express, same result. Somebody help me!! do you experienced bug like this Thanks a lot! ...Show All

• SQL Server date parsing

  Hello, I have a source with two smalldatetime fields, the first field contains 8/1/2006 12:00:00 AM, and the second field contains 8/10/2006 7:57:00 PM. I would like to have the date from the first field and the time from the second field. No chance of changing the source system to do this for me. What I have so far works, except the time portion is converted to 19:57:00 instead of 7:57:00 p.m. Any Ideas My expression is below. (DT_STR,2,1252)DATEPART("month",FIELD1) + "/" + (DT_STR,2,1252)DATEPART("Day",FIELD1) + "/" + (DT_STR,4,1252)DATEPART("Year",FIELD1) + " " + (DT_STR,2,1252)DATEPART("Hour",FIELD2) + ":" + (DT_STR,2,1252)DATEPART("Mi ...Show All

• Visual Studio Express Editions how to add the firewall that i do to security zone

  how to add the firewall that i do to security zone. i tried but i couldnt. Sorry but this is a development forum and the question posted is in the wrong forum. you may wish to repost your question to the Microsoft communities as those are the correct forums/newsgroups to post your question to and to recieve a reply to quickly. www.microsoft.com/communities ...Show All

• Windows Forms Scrollable Datagrids & Freeze Panes

  I have created a datagrid using C#.NET and was looking to make the datagrid scrollable and have the header frozen when u scroll, like excel. I have got sample code from various sources and it keeps mentioning apply to a CSS file. Do I create a css containing all the necessary code and call it in, if so how and where If there's a different / correct way of doing it place let me know. Thanks for looking Paul. I don't have the answer, but I have done this with some blackmagic ASP - not C#.Net - the basics is that you create a single row table of headers on top of your datagrid - might take a little effort to adjust column borders (if you have them, I don't) and then hid the ColumnHeaders of your ...Show All

• Gadgets Sidebar Gadget Generator

  I'm a newbie on all this stuff, but a buddy of mine made a gadget generator that I thought I would post the link here for people who want to learn the basic file and folder structure of gadgets. The generator is a wizard that takes user input and makes all the files and folders needed to create a sidebar gadget. I know that 99% of the people in this forum are more than qualified to make this stuff on your own, but it did help me understand how the files link together..Maybe someone new to gadgets will find this helpful. It is nice when you mess everything up and you can generate the base files in half the time... Feel free to take a look if you like. http://www.blogcastrepository.com/files/folders/gadget/entry7954.aspx Sorry, b ...Show All

• SQL Server SQL Find DUplicates query

  Hi all, i can find duplicate emails in my table like this select ExistingEmail, count(ExistingEmail) as cnt from YM_Email_Updates group by ExistingEmail having(Count(ExistingEmail)>2) but that groups and returns the email address and the NO of duplicates which is good. Is there a way to modify this query to actually return the ENTIRE row (not just the one column) would it involve including this query as a subquery. Ideally id like to return all the columns of all rows with duplicates but this query only returns the email address. I have tried adding the other cols and including them in the grouping but it does not work . TIA, mcm Try: select * from YM_Email_Updates, (select ExistingEmail, count(*) EmailCoun ...Show All

• Smart Device Development Drawing in a Pocket PC Picture Box

  Hi! I have a Picture Box in a Pocket PC application and I don't know how to draw images in it since there isn't any Picture Box Paint event. How should I do it Thanks! You should also check this MSDN article http://msdn.microsoft.com/library/en-us/mobilesdk5/html/mob5samInk2.asp Manav ...Show All

• .NET Development Xml Namespaces

  I have code which creates an XmlDocument from a file including namespacesXmlDocument document = new XmlDocument(); document.Load(filename);I want to do an xpath query /my:doc/my:section/more(possibly other namespaces)I am using an XmlNamespaceManagerXmlNamespaceManager manager = new XmlNamespaceManager(document.NameTable);when I run the above XPath query I get errors, so I have been able to temporariliy remedy the situation bymanager.AddNamespace(document.DocumentElement.Prefix, document.DocumentElement.NamespaceURI);However, I am only adding the document elements namepace, I would like to dynamically add all of the namespaces, is there a way to do this without parsing the entire xml file and hand adding them all to the the manager.Greetin ...Show All

• Visual Studio Query Engine Error + load report failed

  Hello all, I have a C# app that takes information off a form, turns it into a dataset and uses that to populate a report that is to be viewed in Crystal. Anyway, the code that is used has been working since the beginning of the apps life. However, we installed windows updates this past weekend and ever since, we get a query engine error when trying to open the report. The message that pops up for the user is that of a "query engine error" and then the full path of the temporary .rpt file (which is located where it says it looked) that contains the data. The exception text that we see after the error dump says "crystaldecisions.crystalreports.engine.loadsavereportexception: Load report failed". My question is: S ...Show All

• Visual Studio 2008 (Pre-release) Open TCP Channels

  I have some WCF services that work fine with HTTP bindings, but when I attempt to convert it to run with NetTCP bindings, it fails after about 10-12 connection attempts. I suspect that this has something to do with exceeding the maximum number of open TCP channel connections. Do I have to manually close a channel connection on the client side after using it Thanks, Chuck Wat happened to MaxInboundConnections It no longer seems to be present in WCF RC1. We're running into the 10 connection limit and would like to know how to get past it on Windows Server 2003. Thanks, David Pallmann Architectural Consultant Neudesic ...Show All

• Visual Studio 2008 (Pre-release) How does one express a many-to-many 3-table arrangement as an entity model?

  Take this schema: Authors (ID, First Name, Last Name, etc) Books (ID, Title, ISBN, etc) BookAuthors (BookID, AuthorID, IsPrimary) So, this is a representation of your standard "mapping" scenario where you map many rows of one table to many rows of another table via an interim "mapping" table that supplies the many-to-many relationship. In my experience, I encounter this table structure all the time and is considered extremely common and still satisfies 3NF. As a rule, using ADO EF, I should not have to modify my schema to de-normalize to produce a better relational model - the model should be object/relational and the schema should be 3NF - that's the whole point of an abstracted entity model in the first place. So, I w ...Show All