ilatzis's Q&A profile
SQL Server How to hide subtotals if only 1 row in group?
Hello, I have established a group so that I can provide subtotals following the presentation of the group's detail rows. I'm finding that many of the groups have only one row and my subtotals just echo what was already presented on the detail line. The overall effect is confusing to the user and a real vertical space-waster. Can someone give me a technique or expression for hiding subtotals when the group size is 1 but showing subtotals when the group size is >= 2 If I hide the group when the group size is 1 row then the one detail row is hidden as well, no Thanks! BCB But I just want to hide the subtotal line. Won't your approach hide the one detail line that belongs to the group as wel ...Show All
Visual Studio Express Editions Making Bullets
I have Just began learning how to program, and i wish to make a game. In the game i am creating, i have a few questions 1) How would you make bullets move across the screen. (I have a little square picturebox for now) 2) if two objects are Dragdropped onto each other, is there any code that would make the one that was dropped apear next to the picturebox that was dropped on 3) Is there a code that would randomly create one of 3 possible pictureboxes every 10 seconds Thankyou for answering my questions in advance. for #3 you can use a timer control, set the interval to the interval you wish then just create a new instance of a picturebox and place it on the form on the desired location.. ...Show All
Visual Studio Team System Hang Up Loading Project
I have a project containing about 3200 objects under TFS source control. When I load the project DataPro often (but not always) hangs. The message at the bottom left of the Status bar says "Validating Identified Objects". According to Task Manager, neither the 'devenv.exe' or sqlservr.exe' processes show any CPU activity. It was hung for at least 1/2 hour before I shut everything down. Amos. ...Show All
Visual Basic Questions about enums
Is it possible to do the following: I have a combobox with the selected item "Item One". I want to insert all the objects in enum Item_One to a listbox. Is it possible Say, Dim t As Type = GetType(Item_One) For Each s As String In [Enum].GetNames(t) ConvertFrom.Items.Add(s) Next But I want the GetType to be whatever the selected item is in the combobox. So if the item selected is "Item Two" then I want Dim t as Type = GetType(ItemTwo) I know I can use select case but that would be huge as my combobox has many entries. Thank you. Oh, I'll throw another brick on the fire, here: If you use reflection, and you then dotfuscate the assembly, you won't have access to the meaningful en ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Meshes near eachother misrendering.
Hello all once again, I have what appears to be a simple problem that's not so simple. It is best described with a picture: (http://www.zooptek.net/misrender.gif) At the bottom, you will see that I have two rectangular blocks (they have depth, not billboards or 2D rectangles). On one side, it is gray. On the others, they are red. When I place one beside the other, as indicated by the bottom-most arrow with the red front face of the left one touching the back of the right block, they get the weird rendering problems shown at the top of the picture. That is where the middle question mark is pointing to. A simular rendering problem shows up when I have them side b ...Show All
Silverlight (formerly WPF/E) WPF/E And Visual Web Developer 2005 Express Edition
The documentation with the February 2007 CPT of WPF/E indicates that WPF/E should work with the Visual Web Developer 2005 Express Edition. Hmmm...When an attempt is made to install the "template", an error occurs claiming that Visual Studio 2005 needs to be installed and to see section 4.22 of the WPF/E documentation; " 3. Supported Compiler, Platforms and Related Software This release of the "WPF/E" SDK supports the RTM release of Microsoft Visual Studio 2005. A free trial of Visual Studio 2005 is available at the Visual Studio 2005 Developer Center . Express Editions of Visual Studio are available to download from the Visual Studio Express site, free of charge. This release of the "WPF/E" ...Show All
SQL Server can I create a VIEW on the sesult of stored procedure ?
I have a store procedure which select/calculate fields from multiple tables, can I create a VIEW on the sesult of the stored procedure I want create a cube fact that is base on the result of a stored procedure, but the cube cannot accept SP as a source, so I want to create a view that can be the source of cube fact ...Show All
Visual C# Visual Studio 05: How to create a new popup box, and then design the popup box
Hi sorry its me again, How do i create a popup box for eg: i click on SETTINGS, it pop out a box which then i can edit the box so that i can set dropdown menu on the box for the relevant settings. coz the program im doing is a webcam player, i want the user to click on settings where it can choose the type of video and which camera to use... now i only know how to use the MessageBox.Show("Your Text here") command. Just dont want to create a new thread is it possible to change this code into individual code try { MenuItem m = sender as MenuItem; capture.RecFileMode = (DirectX.Capture.Capture.RecFileModeType)m.Index; this.txtFilename.Text = this.capture.Filename; switch(capture.RecFileMode) ...Show All
Visual C# Code alignment lost
I prefer to have my code aligned in such a way that a straight-forward edge detection results. For example (from a .Designer.cs file): private System.Windows.Forms. Label prefix_LAB; private System.Windows.Forms. TextBox prefix_TBX; private System.Windows.Forms. Button retrieve_BTN; private System.Windows.Forms. Label user_LAB; private System.Windows.Forms. TextBox user_TBX; However, if I cut and paste the code, I obtain private System.Windows.Forms. Label prefix_LAB; private System.Windows.Forms. TextBox prefix_TBX; private System.Windows.Forms. Button retrieve_BTN; private System.Windows.Forms. Label user_LAB; private System.Windows.Forms. TextBox user_TBX; Problem: I want to keep the automat ...Show All
.NET Development Is this only possible in XPath 2.0
I can't fugure out how to write an xpath to do the following in xpath 1.0: Doc < Plane > < Seats Number =" 1 " Window =" No "/> < Seats Number =" 2 " Window =" Yes "/> </ Plane > I would like to concatinate the @Number & @Window fields on each node set returned Desired Results: 1^NO 2^Yes The problem is if I use concat in xpath 1.0 I only get a single string result. Any ideas I guess this may be simplified to translate(concat( normalize-space(concat(/*/*[1]/@*[1], ' ', /*/*[1]/@*[2])), '
', normalize-space(concat(/*/*[2]/@*[1], ' ', /*/*[2]/@*[2])), '
', normalize-space ...Show All
.NET Development DataView RowFilter not filtering on percent sign
I have a DataView that contains two rows, and contains only one column called Name. The data is shown below: 1% Potassium Sulfate Solution 10% Hydrogen Peroxide We have implemented a search functionality on the DataView by using the RowFilter property. But I also need to be able to filter by the percent sign, which is a special character in the RowFilter property. I want to be able to search '*1%*' on the Name column so that only the 1st row is returned. But I am having problems properly escaping the % sign. I have tried RowFilter = "Name LIKE '*1%*'" but this returns both rows RowFilter = "Name LIKE '*1\%*'" but this throws a syntax error of "unrecognized escape sequence" RowFilter = " ...Show All
Visual Basic movie collection starter kit
Hi there I trying to run movie collection1 and I have a problem When I try to add some dvds to the collection via online, I get a error message saying that the movie cannot be added to the collection, and it is not. It adds some dvds and I get the error message with others. For instance, it cannot add the sound of music or The Firm to the list, but I can add DUEL All of this is with the movie collection template I downloaded. Any suggestions Thanks I am having the same problem. An exception is being thrown when a row is being added. Copied the debugger output here. {"Cannot set column 'Actors'. The value violates the MaxLength limit of this column."} System.Exception {Syste ...Show All
SQL Server NET_ADDRESS in the master.dbo.sysprocesses table
Does anyone knows how the field NET_ADDRESS in the master.dbo.sysprocesses table is encoded May I extract the IP address or MAC address from that field I had the same thought as you but my sql server reports strange values for some PC: B7D36284FF31 MICHELENEW CBB6ACE3C807 CARLOP are clearly strange values, CBB6ACE3C807 is My PC and my MAC is 00-0E-A6-1D-BE-29 do you have any idea about here the complete report from master.dbo.sysprocesses table NET_ADDRESS HOSTNAME ------------ ------------- 00096B67790E SERVER2003 000EA61DBBCE NICOLA 000EA61DBD4D EMANUELEXP 000EA61DBEFF MICHELENEW 000EA61DC006 ENRICO02 000EA6C49C83 BAMBINO999 000EA6C71205 DOMEXP 000EA6D0B069 MICHELA2 000FEA8184 ...Show All
SQL Server Grouping by Age
I have a table Age and need to create Report by Grouping Salesfigures according to Age. I put the following expression into Grouping and Sorting Properties/General/Filter /Sorting Expression... as well as in Textbox Properties/ values.. =IIF(Fields!Age.Value < 16, "<16",IIF(Fields!Age.Value <21,"16-20") Errormessage: Value expression for textbox "Age" error: Argument not specified for parameter 'FalsePart' of 'Public function IIF(Expression as Boolean, TruePart as Object, Falsepart As Object) As Object'. Question 2 . How to return Month as January, February... In correct order "DATENAME(mm, Sales.time) AS Month" (Ascending ) returns starting with April, August... DATEPART(mm, Sales.time) AS ...Show All
Visual Studio Error: Some parameters or credentials have not been specified on drill through report
I am creating a report of users' productivity. I would like the main report to display the user name and location. I would like to then click on the name to display the user's information. The main report seems to be working, but the drill through does not. When I click on the hyperlink on the main report, I receive, "Some parameters or credentials have not been specified". Can anyone tell me what I am doing wrong FYI: I am using VS 2005 Professional and my datasource is a business object. Thanks in advance. Private Sub ReportViewer1_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WinForms.DrillthroughEventArgs) Handles ReportViewer1.Drillthrough Dim Detaildata As New List(Of ActionLogDetailData) D ...Show All