imj's Q&A profile

• SQL Server Query on YTD Distinct Count

  Is it possible to calculate " YTD Distinct Count " of number of Customers who are been serviced by a agent. We have two dimensions for period...as Year and Month . Other dimension for agent heirarchy.... "Is their any way to access fact column in my MDX qry for calculated measure ". Thanks !! I can't seem to get Aggregate to work with YTD. My measure is a distinct count: [Measures].[DC MctBrandID] I ended up having to do this (which I found on another forum): Count(NonEmptyCrossJoin(Descendants([MerchantBrand].CurrentMember,,Leaves) ,YTD([DateLevels].CurrentMember) , {[Measures].[DC MctBrandID]},1)) I tr ...Show All

• Visual Studio font

  hello, I made a crystal report in a desktop. everything is ok. but when It was moved to a laptop, the report could not show proporly. some words have been cut half. some lines moved. another thing when I opened source code in laptop, the report desinger also can not show the report proporly. all words became very small. can anyone give me answer or comments for these two questions Jay Hi, Check on what type of font is it that your are using in your report. Is it present in your laptop Also, what version of Crystla reports are you using, coz there might be some service pack available for your version. cheers, Paul June A. Domag ...Show All

• SQL Server Property DefaultSchema is not available for Database [DatabaseName]

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on 2005/08/29 My first try was done at through Database\Security\Users.  I tried going through Server\Security\Logins and I got this error message    Alter failed for User 'Domain\Group'. (Microsoft.SqlServer.SMO)   Additional Information:   --> An exception occured while ...Show All

• Software Development for Windows Vista Rasing an event on HandleExternalEvent activity using Web Services

  Hi, I'm experiencing scenarios on WWF and I designed a Workfflow like this. First Activity : WebServiceActivityInput Second Activity : HandleExternalEvent Third Activity : WebServiceActivityOutput So I can access my workflow from a Web Service but I couldnt find a solution to raise an Event from my UI through a web service, is to possible to do that thanks in advance Thanks Jon for the rapid answer, That's what I was thinking so I try to do that with my own Web Service and I'll be back to you for probably the next question :). ...Show All

• Visual Studio 2008 (Pre-release) WCF on Windows Mobile 5.0

  I've seen a few posts on blogs from a few people indicating that people are actively working on this product. If anyone knows anything about the status, or how I can get into the beta to get my grubby little geek hands on a CTP, please let me know :) p.s. I am extremely interested in finding out if the compact framework version of WCF will support the NetPeerTcpBinding Here is something on the WCF support in .Net Compact Framework 3.5: http://blogs.msdn.com/romanbat/archive/2006/10/21/windows-communication-foundation-compact-edition-and-the-story-of-the-lunch-launcher.aspx In a nutshell, .Net Compact Framework 3.5 supported features for WCF like messaging-layer communication, WS-Security, Http transport and Mail transport (M ...Show All

• Windows Forms ListBox Click/MouseClick

  What's the difference between a ListBox: 'Click' and 'MouseClick' event Online help says: Click: Occurs when the ListBox control is clicked MouseClick: Occurs when the user clicks the ListBox control with the mouse pointer. To me it sounds cryptical-equal. Does 'Click' mean that the listbox can be clicked by some other 'thing' Henk (confused...;-) ) Hi,   the mouse click is when the mouse clicks on the control, a click can be generated by other events such as the enter key.  From the MSDN documentation:   " Click events are logically higher-level events of a control. They are often raised by other actions, such as pressing the ENTER key when the ...Show All

• SQL Server How to define a user variable on Execute Sql Task??

  Hi everyone, How to define a Input variable in a Execute Sql Task I've defined a User::Inicio variable which contains 4 as value. In Parameter Mappins it has been defined. Then, I've gone to General->Sql Statement and allocated the following SQL Statement: UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [Inicio] or UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [User::Inicio] Anyway, I'm stuck, both did not work Thanks in advance for your comments Well, the error talks abour the ResulSet porperty; what is your value for that what is you set that to None. Also i think you do not need anything in your parameter tab since the SQL statement is being created by the expression RAfael Salas ...Show All

• Visual Studio 2008 (Pre-release) A component to display a database table

  hi i have this code : string myQuery = "SELECT Name From [User]" ; OleDbCommand cmd = new OleDbCommand (myQuery, myConn); OleDbDataAdapter da = new OleDbDataAdapter (cmd); DataSet ds = new DataSet (); da.Fill(ds); Object []temp = ds.Tables[0].Rows[0].ItemArray; object has the returned items of the select query.... i want a component to display the returned records same as datagrid in .NET Web development ...any suggestions thx If you only want to display the data (i.e. the user will not edit the values) then use the ListView. If you need editing capabilities, there really is no out-of-the-box way to do that. You might want to give the Infragis ...Show All

• Visual Studio Express Editions Cannot install VC# Express

  I have tried unsuccessfully to install VC# Express several times over the last few days both from the download now link and from the .ISO image. Here is the install log from my latest attempt. [11/14/06,18:47:50] Setup.exe: [11/14/06,18:47:50] Setup.exe: ========== Logging started ========== [11/14/06,18:47:50] Setup.exe: ===================================== [11/14/06,18:47:50] Setup.exe: GetGlobalCustomProperty({481CEF9F-033A-11D3-ACE2-00C04F8EEBA1}) [11/14/06,18:47:50] Setup.exe: GetGlobalCustomProperty(B51015E7-26A5-4c8f-B871-26ABA9BEFB65) [11/14/06,18:47:50] Setup.exe: Command line parameters: [11/14/06,18:47:50] Setup.exe: entering ISetupManager::RunIntro() [11/14/06,18:47:50] Setup.exe: LoadSetupDatabase() [11/14/06,18:47:50] Setup ...Show All

• .NET Development colon

  Hi gurus I am new to c# or dot net i am having n xi interface which sends a soap msg to the webservice ( genrated by dot net ) . this soap message has a "ab1:" which is not accepted by the webservice and the receiption is failed . i would like to eliminate the "ab1:" from the soapmessage "ab1:acknowledgementsbase x mlns:ab1 = " urn:xxxxx.com/xi/utils.acknowledgements" Please advice on this its a burning issue right in my company thanks Hi first lemme appreciate the patience u r trying to help me and understand the problem. forget about XI interface, I have a soap that is sent to csharp or dotnet which is having a "ab1:" from the namespace . i need to eli ...Show All

• SharePoint Products and Technologies Using WorkFlows in subsites

  I have a main site and subsites(blogs, Wiki). I'd like to implement a workflow which does run whenever someone adds a new item to a list in the main site, to automatically create a new wiki page. It seems that metadata (lists, workflows, ...) doesn't show up in subsites. Is there a way a subsite can "inherit" some of the parents' metadata/structures Regards ...Show All

• .NET Development Problem using Left() in ASP.NET

  I am having problems manipulating strings. I want to take the first 15 Characters from a databind for example: <%# DataBinder.Eval(Container.DataItem, "Reference").ToString().Replace("-", "").Replace("/", "").Replace("(", "").Replace(")", "").Replace(" ", "").Replace(",", "") %> I have used the replace to replace some characters and take out spaces (Although ideally I need to remove all non-alphanumberic charcaters) Then I want to shorten the remaining string to 15 characters I have tried using Left(DataBinder... etc. but this just gives me a compiling error. Can anyone help me please ...Show All

• SQL Server Accessing the variable in Execute SQL Task

  I have a variable SYear with the data type Integer and the value 2005. Connection type is OLE DB, and my sql statement is: DECLARE @MyYear Int SET @MyYear = I have set the variable User::Syear as Input with the parameter name=0, there is no result set. I set BypassPrepare both True and False. However, this simple statement does not work. I keep having an error. If I put integer value directly into @MyYear, it is fine. What is wrong in here Somebody help me! This is VERY annoying. It is a type cast problem between the .Net type and the SQL type. When it can't cast the .NET type to the SQL type you selected, it just fails SILENTLY and gives you NOTHING in your task and NO ERROR. What EXACTLY i ...Show All

• Customer Care Framework Did Bank of America launching mobile access have anything to do with their CCF deployment?

  Since Bank of America is a CCF site and they have announced support for mobile access I wonder if there is any link between the two ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. using the XmlImporter w/Content Pipeline

  I have all my game objects defined in XML files and I would like to use the Content Pipeline to load them. Looking at the available importers, it seems like the XmlImporter is the right choice, but it appears to want the XML in a certain format (a reasonable requirement). So far I haven't found any documentation on the correct way to format the file. It seems like this would use the XML serialization in C# to serialize/deserialize the object. When you pick XmlImporter in the properties, however, it appears to want a particular root element. Also, I would assume that you would use the No Processing Required for the Content Processor. If that is the case, then I think it is just a matter of formatting the XML file correctly, selecting the XM ...Show All