kfsoft's Q&A profile

• SQL Server Finding the last previous Non-null member (MDX)

  I have a problem, that at first I thought was a fun challenge, now its getting irritating as I haven't been able to figure out how to deal with. Its easiest to show by example - imagine the stock market.. for a stock MSFT, we have Date, Open, Close etc etc. What I would need is a calculated measure for "Previous Close". The problem is weekends and holidays etc have no data (of course). So for Monday you'd want the "Previous Close" measure to show the Friday close... unless of course Friday was a holiday (Good friday) then thursday etc. You get the idea - basically traverse up the Close measure until you get a not null value (unless its the very first date something appeared). If you use the NON EMPTY clause you ca ...Show All

• Visual Studio Tools for Office Client Machine minimum requirements for web based excel office VSTO Solution using asp.net?

  I have to generate interactive excel reports(interactive only to get excel features of formulas , charts etc) having multiple worksheets with graph using asp.net . Currently we have Office 2000 installed on all client machines . 1) If I develop an office excel solution using VSTO in Vs.net 2003 having excel 2003 insatlled iapghn web server , Does it open the excel files on excel 2000 client machines for the asp.net web application 2) Does client machine needs .net framework installed to display excel reports for the asp.net web application Hi, To run VSTO applications you will need - a version of Excel that supports Visual Studio Tools for Office. -.NET framework 2.0 - VSTO runtime - ...Show All

• Visual Studio crystal reports deployment problem

  hi is it possible to use crystal reports for my complied file without installing it with embedded Crystal reports module for example just copy some dll files and run the application on any computer I want to run the application without installing it. thank you in advance Hi the target computer needs to have the reg modules for crystal reports installed, otherwise your report won't work Hope this helps, please close the thread if it does. ...Show All

• SQL Server UPDATE TRIGGER. HELP!!!

  I created a trigger to change a personnel_id from another table if status field changed. CREATE TRIGGER TR1 ON TABLE1 FOR UPDATE AS NOCOUNT ON IF UPDATE (stataus_id) BEGIN If EXISTS (select * from inserted i inner join deleted d on i.status_id=2 and i.status_id<>2) UPADATE table1 SET Personnel_id= a. personnel_id from table 2 inner joing table 1 b on a.user_id=b.user_id END When I tried to update the next row after privious one updated I recievd a message : Data has changed science tehResult pane was last retrieved. Do you want ti save you changes now Click YES to commit you changes to database. Click No to discard your changes and Cancel to continue eding. What I am doing wrong I qu ...Show All

• SQL Server Declare cursor based on dynamic query

  Hi, I am declaring the cursor based on a query which is generated dynamically. but it is not working Declare @tempSQL varchar(1000) --- This query will be generated based on my other conditon and will be stored in a variable set @tempsql = 'select * from orders' declare cursor test for @tempsql open test This code is not working. please suggest Nitin Hi, I dont know for the moment how to declare a cursor on a query from a string.. I dont think its possible this way. An alternative is to find a solution other than using the cursor, else you'd lose development time in trying to find a solution. If you cannot find a solution, try to explain the problem, someon ...Show All

• Visual C++ VARIANT in VC++ net 2005...where??

  i have An ocx COM i add to vc++ net 2005 no problem happen and all methods works fine except any method contain VARIANT type.. here is the original prototype of a method as appear in vc++ 6 long AddPlot(const VARIANT& X, const VARIANT& Y, long Color); BUT at vc++ net 2005 VARIANT& ---> Object^ HOW it tried many codes which gave me no error but doesn`t make the component work NOTE:: the component is 100% working In VC++ 2005 it looks like this: long AddPlot(Object ^%x, Object ^%y, long color); and usage: Object ^x = 1; Object ^y = 2; AddPlot(x, y, 3); VARIANT -> Object ^ and VARIANT% -> Object ^% (% is the tracking reference operator which is the eq ...Show All

• Windows Forms Progress Bar

  HI I am a beginner at C# and found the following code on this website but when i buld it the progress bar does not fill up could someone please help using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WindowsApplication2 { public partial class Form1 : Form { static int count=5; //time count public Form1() { InitializeComponent(); this .timer1.Interval = 1000; // set timer to tick each 1000ms this .label1.Text = "LOADING ..." ; //"Loading ..." text } private void timer1_Tick( object sender, Even ...Show All

• Connected Services Framework SOAP with attachments in BizTalk

  Hi, I want to expose a web service that accepts SOAP attachments in BizTalk. Does anyone have any information about this Is this the same as the multi-part message Any help would be appreciated. ...Show All

• SQL Server programmaticaly save deployed report in ASP.NET 2.0

  Hi Does somebody knows how to save a remote report on the webserver when the report is generated in a report viewer, all programmaticaly behind the scenes So I can view the report later. Thx Thx I have found a solution for the problem by using the Render method as you suggested. On my localhost it works fine. Only thing to check is if it works on the internet as well. Warning [] warnings; string [] streamids; string mimeType; string encoding; string extension; string deviceInfo; deviceInfo = "<DeviceInfo><SimplePageHeaders>True</SimplePageHeaders></DeviceInfo>" ; byte [] bytes = rptAfdruk.ServerReport.Render( "PDF" , null , ...Show All

• Visual Basic no to make a property readonly

  Hello, We are developing a security library, it just takes the controls and, with some data in the database, set the enable and visible property. But I set that properties in the load event of the form according with the database, i would like to avoid programmers to set the enable and visible property by code after the load event. Do you now a way to make that properties readonly after setting them I would like that just for certains controls, nor for all of the form. Thanks in advance. creaturita wrote: well, being direct, what i want is this: textbox1.visible=false And make that property readonly. Noone could change it. The Windows.Forms.Control type does not support this kind of functionality di ...Show All

• SQL Server Delete's Value

  Has anyone ever had an issue when they try to commit changes back to the database based on a value they enter in a application...the value that u would use (i.e Select * From Customers Where CustomerID = 'value') to get the rest of the value's pertaining to that value you enter gets deleted from the database....its really wierd but i have that problem You mean that rows have been deleted by selecting them HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual C# Using Dispose Method - System.Windows.Forms

  Hi, I need to do some closing/cleaning actions when users close a System.Windows.Forms application that I have designed. However despite a lot of reading I need some clarification. The user may use a button I have provided or the main window [x]. If they use my button then the process is easier - however I as yet am unable to handle the [x] closing. I tried adding: public void Dispose() { //Do my stuff GC.SuppressFinalize(this); } But got the following error: '...Form1.Dispose()' hides inherited member 'System.ComponentModel.Component.Dispose()'. Use the new keyword if hiding was intended. What am I doing wrong and how can I handle what I am trying to do. Thanks Andrew You're going to kill yo ...Show All

• Windows Forms Override DataGridView KeyEvent to allow AcceptButton to work

  Hello, I have a DataGridView on a standard form with a Select Button. The Select button is currently set to the Form's AcceptButton property. The Form's KeyPreview property is set to true. When the user finds the item they are looking for and presses the Enter key, the DataGridView moves to the next row. The DataGridView is set to ReadOnly and is not in any EditModes. I have found code to suppress the Enter key by overriding the ProcessDataGridViewKey method which works great, the problem is, I am still unable to get the AcceptButton to work. Anyone have any ideas as to why the Enter key isn't making it to the Form Thanks for the help, Jeremie Grund ...Show All

• Visual C# Displaying Print Dialog box when printing

  Hi, I must be missing something, but I cannot find how to display the print dialog box when printing documents from a standalone Windows application. Similar to the javascript print() function. I am successfully printing word documents using System.Diagnostics. Process () but this does it automatically without the need for user intervention. I need to sometimes display the Print Dialog box so the user can decide the printer they want to use. Also so far unable to find how System.Diagnostics.Process() allows you to print more than one copy at a time. Any help greatly appreciated. Thanks Andrew take a look at the printdocument/printdialog classes: http://msdn.microsoft.com/library/default.asp u ...Show All

• Visual Studio VS 2005 Pro SQL Version

  Which Edition of SQL comes with VS 2005 Pro The VS 2005 Product Comparison shows it coming with SQL Server Developer Edition (which is what I need). But the Trial version I downloaded came with SQL Server Express, which doesn't include any of the BI tools I need. The product comparison here is incorrect then: http://msdn.microsoft.com/vstudio/products/compare ...Show All