Lee Alexander's Q&A profile

• SQL Server DSV and Cube do not match - generates Key Errors

  Hi All, This is strange behaviour, hopefully I can resolve it without rebuilding the cube and all the dimensions from scratch. I have a cube with a fact table, and a number of dimensions, including an EventType and Event Date.  (Event Type is "Sale", "Return", etc.etc, Event Date is the date it occurred) When I created the DSV for this I accidently joined the fact table EventTypeID field to the EventTimeID on the Event Date dimensions. Not suprisingly this gave me a key error, as my EventTypeID on the fact table has values from  1-12, and the EventTimeID records start at 10000 and go upwards. Having seen the e ...Show All

• Visual Basic Disappearing handles clauses

  Has anyone had issues with the handles clauses at the end of eventhandler subroutines just disappearing I have a ton of eventhandlers and when this happens it just wipes all my additions to the code base I've been working on out because I have to undo until I get back my missing handle clauses. I see "Designer Generated Code" in the undo list and I know I didn't enact that. It also puts an extra " ,MyBase .Load" or similar on all the assigned form events. I've had it like this " Handles MyBase .Load, MyBase .Load, MyBase .Load" at the end of the form load event. Let me know if you've had similar issues or know what's causing it. ...Show All

• Visual Studio Tools for Office strange behaviour with offline deployment model

  Hello Everyone, I have a smart doc Word application deployed with the model "Offline Model for Word and Excel Solutions using the Internet Explorer Cache". When the Word document is opened for the first time on the client machine, the dll is created in the internet explorer cache. But if I am offline and I try to open the document (after switching to offline mode using Internet Explorer's Work Offline command on the File menu), I have the error "The customization is not available offline, but it might be available online.". At the same time, when the Word document is opened for the first time on the client machine, the dll is create ...Show All

• Visual Studio Team System Backup you data with Team Foundation Server Beta 3

  Since the documentation looks to be outdated: What are the steps to take to backup all the data within TFS3. It should be a backup of all tables (including SharePoint Services and Reporting Serves data) from SQL Server and a backup of Windows SharePoint Services. Is that it Are the attachements now stored within the database Thanks, Neno Yes, all of the mutable data is now within the database.  So backing up TFS is just backing up all of the SQL databases on the data tier.  Our admin and operations guide will have details on how to do that but it's pretty straight forward. ...Show All

• Visual FoxPro CA

  Hello Guys Can someone redirect me to a page where i could find a simple sample of CA (Native) or if one could send me an email. Please don't use the ca class if you would send me an email. The problem is when i use an access database, it works fine but when i use a vfp database, it shows me just one record. Please help me out with this too. Jitendra Shahani shahani.jitendra@gmail.com You will find some articles on CA in the article section at www.foxite.com . Registration while required is freen. ...Show All

• Visual Studio Express Editions WMP duration problems

  Hi, i'm currently using AxWindowsMediaPlayer1.URL = songs(songnum)AxWindowsMediaPlayer1.Ctlcontrols.currentPosition = Math.Abs(Rnd() * AxWindowsMediaPlayer1.currentMedia.duration - 10) to try starting a song at a random position but it seems like the duration isn't loading fast enough so it always starts at 10 seconds. (Math.Abs(Rnd() * 0 - 10)) = 10 Does anyone have suggestions on how I could get the duration loaded before changing the song position Have you tried AxWindowsMediaPlayer1.URL = songs(songnum) dim duration as integer = Math.Abs(Rnd() * AxWindowsMediaPlayer1.currentMedia.durati ...Show All

• Visual Studio Team System TFS Build numbering

  Hi there, I've just started out using the build server in TFS and I have loads of questions, but I won't ask them all at once :-) One question I have is; is it possible to control assembly version information with the build process For example if my solution contains a class library, can I set the assembly version to say, 1.2.* and then team server will put in an auto incrementing build number (not a random number!!) If TFS can't do this, would it be possible to do in a custom MSBuild step Thanks for your help Graham We overloaded the BuildNumberOverrideTarget target. Create a custom task that will generat ...Show All

• SQL Server How to make an if in the dataflow ?

  I have a dataflow where i import 2 files. The one is the file containing a couple of million records. The other file contains rows with summed values on a specific key. The file with the millions of records is aggregated on the key, sorted, so that the 2 collums from the files can be compared. I then do a mergejoin on the key and now i have temptable with the (key,sum1,sum2). Now there must not be a difference between sum1 and sum2. I can make a conditional split where i say ([sum1] - [sum2]) > 0.1 so that i get an output with rows where the diffence is more than 0.1. My question is now, how do i make an action on that. If that task put o ...Show All

• Visual C# how to save a graphics into a jpg file

  Now the graphics are painted in a form and i want to save the graphics into a jpg file. Which class will implement that what about ImageConverter class should i first transform the graphics into a image. By the way, i am not sure whether the image class will be useful. thank you Hi,    I still get a big black box, here's some of the code I'm using: first my toolbar button for print: if (e.Button == this .tbPrintForm2) // print the validated version of the doc { _bmp = (Bitmap)_currFormImage; pd2 = new PrintDocument(); pd2.PrintPage += new PrintPageEventHandler( this .DrawPanel); PrintD ...Show All

• Visual C# Running time of a process?

  Hi, I was wondering, how do I get the running time of my process. Standard approach would look like this: Process process = new Process(); process.StartInfo.FileName = "bla.exe"; process.Start(); DateTime startTime = process.StartTime; process.WaitForExit(); DateTime exitTime = process.ExitTime; TimeSpan runningTime = exitTime - startTime;   The problem occurs when trying to measure execution time of very short processes. I can't get the start time of the process. I really need a very precise measurement of execution time. Any ideas Regards, Mantas OK. I will do it properly. I am in n ...Show All

• Smart Device Development Copy Files (and use them) on Smartphone Emulator

  It seems as though I can create a share on my dev machine and the Smartphone Emulator accepts them via File - Configure - General - Shared folder (although there's no way of telling). However, because the Smartphone emulator does not have a built-in File Manager there is no way to copy around the files on the device (emulator). For example, say your Smartphone app relies on some .xml files for storing app-related information. I cannot figure out how to move those files into the app folder so my app can use them...or anywhere else on the device for that matter. Are there any tools out there that I can deploy to the device (emulator), such as ...Show All

• Windows Forms OverDrawing Custom Inherited Controls

  Hi, Using VB.NET. I'm a beginner so please be gentle..  I am trying to overdraw most of the windows controls, including Listbox among others, so that they have a solid 3 pixel border. Currently I am doing this by creating a customcontrol inheriting from the specific windows control i.e. CustomListBox, inherits ListBox. CustomTextBox inherits TextBox.. etc.. then han ...Show All

• Visual Studio How can I NOT show a subreport if there is no data for it?

  The table headings still print even though there is no actual data. That looks sort of odd. There doesn't appear to be anything in the SubreportProcessingEventArgs that will cancel that instance of the subreport. In the main report, click on the subreport and set the NoRows property to a text message. This message will be shown if the subreport queries do not return any data then.   -- Robert ...Show All

• Visual Studio Pushing Data/Passing Values to Crystal Reports from C#??

  Ok, I'm having a very difficult time finding information on how to get data from C# code into a Crystal Report. This is what I want to do: I have a report that will list everything sold withing a certain timeframe. No problems with that in Crystal Reports XI. However, I want to be able to specify a single date value or a date range, and the customer account number. I do not want to use Crystal Reports to prompt the user for the data. I want to decide in my C# what the select values will be and then use that data in the Crystal Report. For Example: WHAT I HAVE: In the Crystal Report rpt file, I have a filter on date (give the sales for only 1 ...Show All

• Visual Studio Express Editions Order Tables Ascending in DataSet

  Hey there, I have a problem cause I don't know how to order tables ascending within a dataset, so I need to know how can I do that, I have for example these tablenames within a dataset in this order: "0050Colors" "0021Cars" "0120Symbols" "1008Field" "0215Country" that's the order in what the tables are added into the dataset, and I need them in the next order: "0021Cars" "0050Colors" "0120Symbols" "0215Country" "1008Field" So what would be the code, to order the tables in that way, please help, thanks!!!. ...Show All