Ricardo 8a's Q&A profile

• Visual Studio Showing the summary data only on last page?

  I have a summary field in my Invoice report. It is the Total of the Amount (currency) field. I would like to show it only on the last page, so I use the formula: If PageNumber = TotalPageCount Then Formula = Sum ({GetOrder;1.Amount}) However, suppose my report is 2-page long, the first page will show $0.00 for this Total field . I like to hide this $0.00 and show nothing. In other words, I would like to hide the field object. Is this possible Thanks for replying. Hi, Modify the Suppress Formula in your Format Editor (Common Tab) create a statement that would return true (to suppress it) if your field value is 0. cheers, Paul June A. Domag ...Show All

• SQL Server Native SQL Server SOAP Services vs Custom SOAP Services

  Hi I have an SQL Server DB that I want to make available to a Business Process engine . The Business Process Engine can talk direct to the SQL Server or it can call Web Services which would in turn call the SQL Server. The DB in question has a jumble of data in it some of which may not live in there for the life of the systems; hence I thought that by using a Web Services interface I would de-couple the Business Process engine from the underlying data storage. Now SQL Server has native SOAP end point support, so I was wondering what advantages there are between using SQL Server native SOAP and building a Web services laying in .NET or Java. Advantages of SQL Server Less infrastructure required means simpler infrastructure ...Show All

• SQL Server Performance optimization in SSIS

  Hi, our package have design like this, OLEDBSource a Derived Column a Lookup | Matching Records Un Matched Records | | OLEDBCommand OLEDBDestination (Update) (Insert) and our source & destination table are oracle. when we execute the package the performance is very low and some times its showing like processing ( yellow color) even for 1 hrs .what could be the problem.can any one help us.is there a ...Show All

• SQL Server Connecting to an Oracle Databse Server using SQL Express

  Hello everyone,   I am working on a project for a professor. The project entails designing and creating a database.   We were given individual space on the schools database server and we were given SSH secure shell to connect and manage our respective databases.   I took it upon myself to try out SQL Server Express.   Using the management studio I am trying to connect to my school database and can’t seem to figure it out.   Can someone please give a noob some simple and quick instructions on how to achieve this   Thank you, Your Friendly Neighborhood Programmer,   This is the SSH product in case any one was interested, ftp://ftp.ssh.com/pub/ssh/SSHSecureShell ...Show All

• Visual Studio Express Editions how to use a control using a string

  Hi All, I want to change the properties of a control, by calling it names. I have several labels in my form (L1...L100 for example) and in the code I want to select one of these label, using a string ("L" & i) in order to modify it property. I can write Activecontrol=L2 But not Activecontrol= Numlabel where numlabel = "L2" But if L2 is a result of a calculation how can I select the proper control. Not sure it is clear ( ) thanks, VSC Thanks, but I'm still having trouble. Using that line I get an error "cannot implicitly convert type 'System.Windows.Forms.Control' to 'System.Windows.Forms.Button'. An explicit conversion exists (are you mis ...Show All

• Visual Studio Team System Multiple Solutions for one Team Project

  Hi all, I setup a new Team Project and now I want to add 4 different solutions into this project. The first 2 worked fine and are now checked in, but when I want to check-in the 3rd i get this error message / warning: (Imageshack) Does the third solution contain any projects that live under Solution1 or Solution2 If so, that is where the message is coming from. Visual Studio / TFS Source Control like to have all of the projects in the solution residing physically beneath the folder that contains the .sln file. - Steve ...Show All

• Visual C# Change ReadBufferSize...

  Hi there. I want to change the ReadBufferSize value of a Serial Port object. The ReadBufferSize property has the following form: public int ReadBufferSize { get ; set ; } When I am writting to my code port.ReadBufferSize = 300000, where port is the serial port object, nothing seems to happen. What might be the problem and what am I doing wrong I would really appreciate any help of you. Thank you in advance.. Hi, the property ReadBufferSize needs to be declared as follows: ---------------------------------------------------- 1)You need to have an int variable and then  define property.    private   int nReadBufSize;     public int ReadBufferSize  ...Show All

• Visual Studio Team System Why is the database stored in the .dat file?

  Hi, What is the rational for storing the contents of the design DB in a .dat file in the root of the project folder It seems strange to me to build the DB from the .dat file rather than from the .sql files. If you're storing the same information in two places then you run the risk of the two becoming inconsistent - as happens when you are using CTP6 and the .sql files are under source control (this bug has now been fixed). I am in a horrible pickle because of this problem. -Jamie I've just added my project files to TFS source control, and started getting access denied errors to the .dat file (because it's read only). So I checked it out which seems to have worked. My question is how are we meant to deal with the dat ...Show All

• Visual Basic Excel Functions within VB

  Hey, I'm using the PMT function in excel and in VB 2005. Basically what I'm doing is trying to make my loan calculator an actual program, instead of always having to write everything out within an excel spreadsheet. I have all the needed information and I thought that my VB code was correct, and according to all the help files I can find they are. However the number I get from the function in my VB program is wrong. I'm not sure why the answer is different if all the inputs are the same in both the program and the spreadsheet. Thanks for the insight. Here's my code for the PMT Function in my program, incase you need to see it: MonthlyLoanPayment = -Pmt((InterestRate / 12), Math.Round(MonthsWithoutMedicaid), LoanedAmount) Azrael ...Show All

• Visual Studio Team System Add Form Field for Validation Rule

  I have a request, and under this I have form post parameters like following: - ctl00$MainPaneContentPlaceHolder$pgGeneral$txtClientName = ajdfkjakl I want to add Validation Rule\ Form Field for this request. I set information like following in "Add Validation Rule" window: - Form Field Name: ctl00$MainPaneContentPlaceHolder$pgGeneral$txtClientName - Expect value: ajdfkjakl I expect that the value that is responded to textbox Client Name is ajdfkjakl. But when I run this web test, the result always failed in this validation. System informed "The HTTP response does not contain an HTML document". Can you help me analyzing this case Do I understand Form Field correctly Thank you very much! Hoa Pham The validation rule ...Show All

• Visual C# Generics: List vs Collection

  Ok so I'm working with a generic collection and realize I need to sort. Track down the generic List (which I didn't know about). So this leads me to 'why is there a list and a collection' Is one lighter weight When should you use one vs the other Thanks! Nick H Hi, This thread is on the topic: http://forums.asp.net/thread/1511096.aspx And you can compare Collection and List with their members. Thanks ...Show All

• Windows Forms Where can i get the issuevision's c# code??

  need help...looking for the c# source of issuevision Hi, http://www.windowsforms.net/Applications/application.aspx PageID=40&tabindex=8 Here it is! ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Weird backface glitch

  I'm not sure what's going on here; I wouldn't be surprised if it's just my video card. But has anyone seen this before cellphone_rendering_bugs.jpg That's a series of screenshots I took as the model rotated... the original model in Maya has all its normals facing the right way. I exported it as an FBX200611 model. I'm (unfortunately) using a Compaq Presario with an NVIDIA GeForce 6150 LE video card. I thought it might have been a matter of the near/far draw limits being too far apart and the Z buffer lacking the precision to draw this relatively small area properly, but I turned it down to 1.0 -> 100.0 and it still happens. Any thoughts Hahah, success! :) That was it, B1narySh0t! I had to tweak the co ...Show All

• Visual Studio When will VS 2005 and VSS 6.0 work?

  Open vs 2005, select "pending checkin window" for about 10,000 files wait 45 min to 1 hour.. Thanks for your time.. "We suspect that the VB hot fix contains the bad Pending Checkin Window perf bug." See the thread ,problem is with RTM, hotfix did not make any real difference ( if it did, given the slow times then any change was not noticable). "2. Server->Configure..." You must have adiffernt program no sever->config option.. ...Show All

• Visual Studio No HyperLink event in WebForms ReportViewer?

  Why oh why isn't the WebForms ReportViewer exposing the HyperLink event I need it in order to invoke a method on my page based on information in the link in the report. Any way around this Thanks in advance! The hyperlink event is always handled by the browser, so there is never a postback that would fire an event. There can also be a problem depending on the HyperlinkTarget. If HyperlinkTarget is "_blank", to cause the link to show in a new window, then displaying that new window as a result of the page reloading will usually be blocked by pop-up blockers. You can work around this problem by using a bookmark instead of a hyperlink. Set the bookmark to the url you want to use, then handle ...Show All