sllik's Q&A profile

• SQL Server Item Detail Sub-Report

  Hi, I'm trying to build a summary report which expands on each line item to provide some additional key detail fields. The report has a matrix with the following on the row: Product Description Month/Year Currency In the data section: Sales Total Quantity Total Average Unit Price Average Quantity Sold Ideally I would like to have Product Description expand a row in the middle of the report which would link to another report which extracts a few columns (single row) of data from SharePoint. I have the two reports working separately, but I'm at a loss to figure out how to get the Product Description field to toggle visibility of a sub-report. Any thoughts Thanks, Colin ...Show All

• SQL Server Database mail does not work from Sql Server Agent Job after upgrade to SP1

  Upgraded SQL Server 2005 x64 to Service Pack 1 expressly for the purpose of enabling Database Mail from SQL Job, which was a known bug that was listed as fixed in this Service Pack. It still does not work; in fact after installing SP1 on an x86 SQL Server Standard, Database Mail does not work from there now either, although it did prior to the upgrade! I am using Integrated Security. Error message received: The job succeeded.  The Job was invoked by User <name>.  The last step to run was step 1 (Select).  NOTE: Failed to notify 'Mike Schelstrate' via email. Message in Error Log: [264] An attempt was made to send an email when no email session has been established. Send test Email does work on both Servers ...Show All

• Windows Forms Datagridview - Specific color on one row

  Hi all. Is it possible to mark one row with a specific color I have a datagridview with one or more contracts.(Datasource dtContracts). I would like to mark rows with a specific date RED. (if date column ct-mend is beyound today....it means that this contract is finished ). Is this possible Thanks. Yes. You should be able to do it using the DefaultCellStyle property. I wrote a small example and tested it to make sure it worked. Here is the code: public Form1() { InitializeComponent(); dataGridView1.Columns.Add( "Column1" , "Column1" ); dataGridView1.Columns.Add( "Column2" , "Column2" ); dataGridView1.Columns.Add( "Column3" , "Column3&quo ...Show All

• Visual Studio Duplicate items are not supported by the "Resources" parameter error when building project

  Hello, While building our current project using Visual studio 2005 we stumbled on this error, === Error 16 The item "xxx" was specified more than once in the "Resources" parameter. Duplicate items are not supported by the "Resources" parameter === we traced the issue down to resource file naming convention differences between Windows Vista and Windows XP ie, for a given form, if we include chinese traditional and chinese simplified resources, On Vista the resx files must be named with zh-HANS / zh-HANT , using zh-CHS/zh-CHT VS2005 will choke On XP the resx files must be named with zh-CHS/zh-CHT, using zh-HANS/zh-HANT VS2005 will choke This is really causing trouble, as we develop both in XP and ...Show All

• Smart Device Development WM5: Icon IDs for shell standard icons

  Can you just give me an exact link where I can find the information (I search in the NG but found no post) A list like this will be useful: OS       DLL      Icon    ID PPC2002  coredll  Folder  WM2003   coredll  Folder  WM2005           Folder  etc. Why is this not documented in MSDN and why was http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=933098&SiteID=1  closed but not answered! Of course I can search via Google all over the world but an MSDN forum should be the right place to aks such a question... Best regards, hfrmobile ( developing software since Windows ...Show All

• Visual Studio Seems Like A Problem With Visual Studio 2005 SP1

  Hi, Seems like there is a problem with the Visual Studio 2005 Service Pack 1... I am using Visual Studio 2005 Professional and recently applied/installed Service Pack 1. Previously, I can add new item inherited Form or inherited Control without encountering any problem. But now, I have to do repetitive steps (build the project then rebuild again) just to add new inherited form or control. Here's a sample steps : 1. Build MyControls.dll containing my own controls. 2. Open MyApplication.dll. Add reference MyControls.dll. Build the project. 3. Add inherited control. Click Browse. An error will prompt "Unable to load assembly 'MyApplication.dll'. Ensure that the file is a valid .Net Framework assembly" ...Show All

• SQL Server "Copy" within a table - plain SQL

  Hi. I'm quit new into SQL - have a problem - and hope someone here ca n help me. I have a table TABLE1 with different fields. A part of it looks like this: FIELD1 FIELD2 FIELD3 111111 121212 0 111111 121212 91 222222 232323 0 222222 232323 73 etc. etc. I want to "copy"/write over '0' in FIELD3 with the number in FIELD3 from the line that has the same numbers (and unique for these two lines) in FIELD1 and FIELD2. The table will then look like this: FIELD1 FIELD2 FIELD3 111111 121212 91 111111 121212 91 222222 232323 73 222222 232323 73 I can make a temporary table or a new field if necessary. I j ...Show All

• Visual FoxPro specify monitor application

  Hello,all. I want to write a program(A.exe) on my laptop(support dual view) that can run another program(B.exe) and specify B.exe display on the extension monitor . Is there any API can do what I want Thank you for any help. Do you really need an API for that Wouldn't _screen.left setting would do Check universalthread for "dual monitors". I remember a thread last week. ...Show All

• Visual C++ Urgent!!!How to start learnign VC++.net 2005

  Hello every one, im really a starter to Vc++, but i have to do it very quickly as the demand of my work , but problem is that i have tried out net and books like Sams teach your self but still cant get a hang of Vc ,But i have ordered Ivor Horton's"begnning Visual C++2005 ,As the main problem that i can make logics as i have done programing , but here its getting out of control all the different libraries, the Enviorment And the use of syntax, and So please any one of you could giude me how to start and which books are there which are good for stepby stepby learning or are there tutorials softwares to know it. Thankyou Here are some good books on C++: Deitel's "C++ How to Program" Lippman's "C++ Pri ...Show All

• Visual Studio 2008 (Pre-release) SQL SubQuery using LINQ

  How to write a LINQ Query with Subquery where I want to use "In" or "Not In" clause It would be helpful if someone could please provide an example: For example I wanted to convert following sql query to LINQ. "Select CusotmerID from Customers where ProductID in (Select ProductID from Products)"   The left-hand-side of the .Any() operator is the subquery. query.Any(x => predicate) is equivalent to the SQL EXISTS( SELECT * FROM query WHERE predicate ) ...Show All

• Visual Basic Program Path

  How would I, on program startup, get the program to write its current path in which the exe file is, to the registry Thank You! Sorry but this is the incorrect forum. Also please do not cross/duplicate post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=696280&SiteID=1 the same would apply, except when you are loading your form/application instead of doing it via a custom action ...Show All

• Visual Studio Tools for Office Error 0x80040F04 while Accessing Outlook using VSTO 2005

  I am getting error 0x80040F04 while accessing properties of Objects from Outlook. I can not test on these computers as they are not my systems (I am not having these issues and neither are most users, but some have this error). Basically, when ever the program tries to access a property, such as Name, the VSTO throws error 0x80040F04. They have Office 2003 installed and the proper support files. They have the service packs up to date (Windows and Office). So, what can I do Has this been seen before Any ideas Thanks, Mark Hogan Here is some code from the program and where the error occurs. Module modArchivER Private ERROR_FILE_NOT_FOUND As Integer = 2 Private ERROR_ACCESS_DENIED As Integer = 5 Public _AppOutlook As Outl ...Show All

• SQL Server script formatting options in SQL 2005?

  Where do I set the default Script Formatting options for generating the TSQL to create database objects I know how to "right-click > Script As > Create To..." What I need is to set the default scripting behavior to include a check for existence, drop the object if it exists, and also include object-level permissions. In SQL 2000 Query Analyzer , it was easy (Tools > Options > Script ). The result would look like: if exists ( select * from dbo . sysobjects where id = object_id ( N'[dbo].[CustOrderHist]' ) and OBJECTPROPERTY ( id , N'IsProcedure' ) = 1 ) drop procedure [dbo] . [CustOrderHist] GO CREATE PROCEDURE CustOrderHist @CustomerID nchar ( 5 ) AS SELECT ProductN ...Show All

• Visual Studio Team System MDX syntax question

  Hello, I am starting to play with customizing some of the TFS Reports and have been able to create a couple of simple ones on my own. I am just trying to get my head around MDX and learn the basic syntax by playing with some of the box reports. I am having a simple problem however and I don't understand what is wrong. I am trying to modify the Remaining Work report and add in a filter in the WHERE clause that only returns items where the Exit Criteria is set to false. i.e. [Work Item].[Microsoft_VSTS_Common_ExitCriteria].&[Yes]. So my modified query looks like this. ---START WITH MEMBER [Measures].[Date Key] AS [Date].[Date].CurrentMember.UniqueName SELECT { [Measures].[Date Key], [Measures].[Cumulative Count] } ON COLUMN ...Show All

• Visual Studio Printing without the ReportViewer

  In a Win Forms app, is it possible to print a report without using the ReportViewer control I want to provide a print button on a Form (like Outlook does) and then use an embedded Report to print the data so I don't really need the ReportViewer. I would want to display the PrinterDialog though and use the settings from here to control the printed Report. Is this possible too Regards Graham In the final product you'll be able to print using the code below. Notice that ReportViewer object is not required. (This code will not work in Beta 2 unfortunately.) using System; using System.IO; using System.Data; using System.Text; using System.Drawing.Imaging; using System.Drawing.Printing; using System.Coll ...Show All