QuantumMischief's Q&A profile

• Visual Studio Page break after group

  Is there a way to turn this off for the last page I know how to do it in Crystal Reports, have been searching hi and lo for this ;). I must be overlooking something obvious. No one knows how to get rid of the extra page after each report that uses 'page break after group' This makes the entire control pretty much useless.... ...Show All

• SQL Server Group By, Max(date) query problem

  Hello all: I have an invoice header and detail tables and a customer table using sqlserver 2005. The Detail invoice table has price and product id. The header has the date and customerID. I need to create a list of the most recent invoice date (and the product price) for each product for each customer. I can't use the group by because when I select both the max(date) and the price (as well as the productID and customerID which all have to be included in the group by) , I get more than one date per product per customer. I can only get the most recent date when I leave out the price and headerdetailID from the field selection. Any help would be appreciated. Here is sample data & results. invoiceHeadertable invheaderID ...Show All

• SQL Server MDX query count of customers who purchased in prior period and this period

  Hi there I'm looking for help with an mdx query that will tell me how many of my customers are returning to purchase each period and thus by default how many existing customers haven't purchased this period. So in English I want; Count of distinct customers who were active in this period and were also active in prior period. Or in T-SQL something like this select count (*) from ( Select distinct customer_id from fact_table where date = current period and exists ( select distinct customer_id from fact_table where date = prior period) ) I have a measure called distinct customer count and a dimension called DIm Customer which currently doesn't have customer_id as a level in any hierarchy, althoug ...Show All

• .NET Development import certificate into internet explorer (IE) keystore

  hi how can i import certificate into internet explorer (IE) keystore thanks ...Show All

• SQL Server Different execution plan between stored proc and ad-hoc query

  We have just encountered a problem with a particular stored procedure which I would appreciate anyone's thoughts on. The proc in question contains a single select statement which simply joins four tables and filters based on two parameters. It normally runs in well under a second but t his morning we came in to find it was running in anything up to a minute. After investigation we found that it was running a clustered index scan on one of the larger tables (approx 10.5m rows) rather than using the appropriate index. However, when we took the select statement out and ran it as an ad-hoc query it was utilising the index and performing correctly. We tried recompiling the proc and also ran sp_updatestats on the database but we were s ...Show All

• Visual Studio Installing VS2005 on Vista Business: Error in installing MS Document Explorer 2005

  I downloaded the Windows Vista from MSDN and installed it successfully but when I attempted to install VS 2005 (Team Edition for Software Architects) It failed due to the following error: The following components failed to install: - Microsoft Document Explorer 2005 And the log shows the following detail: [11/19/06,21:11:28] Microsoft Document Explorer 2005: [2] Error code 1603 for this component means "Fatal error during installation. " [11/19/06,21:11:28] Microsoft Document Explorer 2005: [2] Setup Failed on component Microsoft Document Explorer 2005 [11/19/06,21:11:35] setup.exe: [2] ISetupComponent::Pre/Post/Install() failed in ISetupManager::InstallManagerHelper() with HRESULT -2147023293. [11/19/ ...Show All

• Visual Studio suply report parameters at run time

  Hi I have a date field in my database table and would like to retrieve records from my database where date lies between a specified date range using reportviewer in local processing mode. Problem is that i want to supply data range parameters at run time.E.g retrieve records where date is greater than Jan 1 2006 and less than Feb 1 2006. (January Report) Any help guys or is that possible using reportviewer in local processing mode. Nick In local mode, the host application is responsible for supplying the data. So you don't really need support from the report viewer to parameterize your query. But if you do want to use report parameters, you can supply values at runtime using ReportViewer.LocalReport.SetParameters(). ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Multi threading in a game (using XNA)

  Hello. I am able to create thread and make them exchange information through common objects they know (server / each other reference) Now I would like 2 threads to update a server. Each of those threads takes for inputs a keyboard for one, a mouse for the other one. However, it seems that the thread that listens on the keyboard do not detect events from it. Seems like it is the parent thread that is able to listen to a keyboard event and only that parent thread. How would you do so that a children thread is master over a device even if it does not have the focus Regards, Chryso The XNA Racer Starter Kit (or whatever its official name is going to be) is going to be an example of taking advantage of threadi ...Show All

• Visual C# Trying to stop a service - but getting exception.

  Hi everybody, I'm trying to stop a service using the ServiceController object in System.ServiceProcess. I call the stop() method (after ensuring the service is actually RUNNING), but I get an exception returned. The inner exception is a Win32Exception - error code 109 - something about a broken pipe (or the pipe being ended). Can somebody push me in the right direction as to why this is happening NOTE: When I attempt to stop the process manually from the Windows service control panel - the progress bar will move, but never return. If I click "cancel", the progress bar closes and the service says it is stopped (and it is in actuality closed). Thanks in advance, Adrian Configuring/modifying a ser ...Show All

• Windows Forms Communicating with Printer drivers?

  I need to write a C# program to print data through printer driver. I am not sure if this is possible but these are the things I need to do: 1) List all the printer drivers installed on the PC 2) Send a print job to a particular printer driver for printing 3) Check the print status through the printer driver 4) Send a "Cancel print job" request through the printer driver Really not sure what API to use. Any URL or sample source code will be greatly appreciated. Please kindly help and enlighten me. Thank you very much .NET doesn't let you enumerate the printers. Something about not getting it done in time. Check this Google query for alternatives. ...Show All

• Visual Studio Tools for Office Smart Tag aspect

  HI, I'm wondering if there is a way of changing the underline aspect of a recognized text by the smart tags. I'd like the underline to be thicker and of another color (so old people half blind can see it). Are there any properties to set this visual behavior Many Thanks ...Show All

• SQL Server Creating a job for SQL 2000 using SQLDMO in c#

  I have a quick question on how one can create a backup job using SQLDMO in C# I have not really been able to find any information on how to do this. I can create backups using SQLDMO and I can create Jobs but I do not know how to bind the two together. So if anyone has any information on how to do this it would be great. I'm writing a similar app using SQLDMO. Could you please give me sample code of how did you combine the two Thanks in advance. mct. ...Show All

• Visual C++ reading graphics

  is there any way to read what color a spot on the screen is i know its a general question, but im not sure exactly what else i need to do, just get the color of a spot on the screen. please provide as many ways as possible (if there is a way) thanks in advance ...Show All

• Windows Forms Programatically reading lines from multi-line textbox

  Firstly, is this possible i.e. to read individualy lines of user text consecutively. If so, is there any way of knowing how many lines were originally written to the textbox via some index which I can find no reference to. It seems to me that you get either the whole blasted string or nothing. ...Show All

• Visual Studio Express Editions Project help needed

  Hi people I have this project that I have being messing around with and I am trying to display the Randomgenerator in two labels any ideas   Private Sub displayButton_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles displayButton.Click 'generates and displays six unique random 'numbers 1 through 6 Dim numbers(1) As Integer Dim subscript As Integer Dim searchSubscript As Integer Dim randomNum As Integer Dim randomGenerator As New Random Dim isFound As Boolean 'gernerate the first random number,and 'store it in the first array element numbers(0) = randomGenerator.Next(1, 6) 'fillremaining array elements with un ...Show All