Cbe's Q&A profile

• SQL Server Simple relative time question...

  Hi Everyone, I'm probably missing something very simple here. Our customer request is to compare sales of the current year vs the sales of the previous year at the same date. Ex.: sales from 1 january 2006 to 10 october 2006 vs sales from 1 january 2005 to 10 october 2005 I added some relative time information in my cube using the time intelligence wizard but it looks like this wizard will only allow me to compare 2006 data vs the whole 2005 year... This would work great if i was to compare sales only on the 31 of december. How can i achieve this user request How does the current date work is it using the system date TIA Hi I think the simplest option is creating YTD metric for sa ...Show All

• Microsoft ISV Community Center Forums "variable" to make Macro not associated with one specific sheet in workbook

  Hello, I am recording a macro program in order to pull specific data points out a spreadsheet in excel. Currently the beginning of my macro looks like this: Range("G20").Select Selection.Copy Sheets("Sheet1").Select Range("C3").Select ActiveSheet.Paste Sheets("An32 CD45").Select My problem comes with that last line of text. Does anyone know how I can insert some kind of variable or line of text that doesn't make this macro work only on sheet "An32 CD45" I want it to be able to pull the numbers from any page I ask, but when I try to run the macro on another page is still only pulls the numbers from "An32 CD45." Thank you for any help you can give. L ...Show All

• Visual Studio Express Editions VB/asp projects

  Heya all- just wanted to find out bout express edtion- ive got a vb/asp application in vb.net 2003 editon- however i want to tranfer it on to express editon as there seems to be some errors working with VB.net 2003- but when on trying to open the file- in the express editon- it comes up with error such as no web component not installed and unable to convert project- any suggestions please thanks So this web devloper express will allow me to devlop my application- which is meant for the web- using asp and vb.net where can you get this Web Developer Express or VS2005 Standard or Professional from and is it free thanks ...Show All

• .NET Development Fatal error during AD deployment of RGB9RAST

  Deployment of the components of the .NET Framework 3.0 via AD group policies, as described in http://msdn2.microsoft.com/en-us/library/aa964979.aspx works nice for all components, but with the exception of the RGB9RAST component. Trying to deploy this results (tested on three computers) in an event log entry: "The assignment of application RGB9RAST from policy xxxx failed. The error was: fatal error during installation". Elevated priviliges were set via group policy. Trying to manual install this from the same source by msiexec /qn /i <path-to-rgb9rast-msi-file> results in a successfull installation (on the same computer). Anybody any idea I was in a time crunch when I ...Show All

• Visual C++ Copying a module

  Hi guys I would like to copy a process's module. This is how the scenario looks: Lets say that there is a process called "Main.exe" and it loads plenty of modules  and 2 of the modules that it loads are: 1. "Copyer" 2. "Checker" Now i want to somehow modify something in the module called "Copyer" but if i do that then Checker(which scans this module once in a while) will find out that i have changed something and then exit. So what i have come up with is that i have to somehow copy the Copyer module and then inject it in Main.exe then make this Checker to somehow scan that copyed/injected module instead of the original Copyer module. Could someone please help me to figure out a way to copy a module and make this Checker scan the copie ...Show All

• SQL Server FTP Task Fails - SSIS scheduled with SQL SERVER AGENT as JOB

  Hi, I have created a SSIS package and tested it in V.Stdio where it runs fine and uploads file on the remote server. Now I have scheduled it to run as a job in SQL SERVER AGENT as JOB, but it fails when it comes to the upload task I am quite sure as it is something with FTP connection string or security, but can't figure it out. I have simply added the IP/login/password in the connection manager for upload task. Any help/ guidance would be great. Thanks, Ad Configuration Tools/SQL Server Configuration Manager Check if You use for the SQL Agent a domain or a User Account / and is this the same as the SQL Server Account I use the LocalSystem Account for the SQL Server and a Domain Accou ...Show All

• Visual Studio Express Editions visual web developer book

  i registered visual web developer to get free book. when i will receive that book Hi, has there been any further development with this enquiry The last time I looked the book was still unavailable Many Thanks, Roo. ...Show All

• Windows Live Developer Forums Map events not firing in Firefox 2

  I just upgraded to Firefox 2. Event though this is still a release candidate ( i know ), the map events are not firing on my app. The events in question are "oncontextmenu" and "onchangeview". These are the ones i use at the moment and so i don't know bout the other events. Will Firefox 2 be supported in the near future A lot of people are already switching, and I have to know what to expect (Question for the VE Team) Thank you. Marc- Thanks for your post. This did in fact fix the majority of the problems we are seeing with Atlas ( http://atlas.freshlogicstudios.com/ ) running on Firefox 2. Shawn Miller ...Show All

• Windows Forms Seeking sample code for DataGridView

  All, I am quite familiar with ASP.NET but am struggling with WindowForms.NET. I am hoping you can help. The application is very simple: I have a database with two tables that are related: TABLE 1 - tbl1_ID tbl1_col1 tbl1_col2 tbl1_tbl2_ID TABLE 2 - tbl2_ID tbl2_col1 What I would like to do is to display a DataGrid with the following columns: tbl1_col1 | tbl1_col2 | tbl2_col1 where tbl2_col1 is in a ComboBox column. The user should be able to edit any row and add new rows. If a new value is typed into the ComboBox, this should create a new row in TABLE 2. I know exactly how to do this under ASP.NET 2.0, but am really struggling with WindowForms. Would you please point me to an e ...Show All

• Visual Studio 2008 (Pre-release) WCF, WPF VS 2005 RTM Extension?

  Hi, Just was wondering when the RTM version of the WCF and WPF Studio 2005 extensions will be released. It looks like the WWF extensions are RTMed already. Thanks Andy To be fair, this was announced in our November CTP post here : This November CTP is the last planned release of Cider as an extension to Visual Studio 2005. Future CTPs of Cider will be available in the preview releases of the next full version of Visual Studio which is currently code named "Orcas". ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Plain ContentTypeReader

  Hi I have been reading through the forum for hours now and there is something I do not quite understand: Any class that is required for readers comes from Microsoft.Xna.Framework.Content.Pipeline. This library is not available for the Xbox 360, thus leading me to the conclusion that it is currently not possible to write a custom ContentTypeReader for the Xbox 360. Is that correct My other problem is that I do not want to write an importer as I use an application to compile my models. I only want to write a ContentTypeReader to load it into XNA at runtime. Is that possible without utilising the ContentTypeWriter.GetRuntimeReader function cheers Daniel The importer, processor, and writer are in the Window ...Show All

• Visual Studio 2008 (Pre-release) Displaying DataTable in run-time

  Hi, I've got the following issue: My application is intended to show any table from the database. It means that the structure of the table is only known in run-time. I looked through the samples, but all the examples contain DataTemplate definition in XAML file that is not my case. I browsed the documentation but did not manage to fing the way how to create DataTemplate programmatically. Are there any ideas how can I display a table when its structure is only known during runtime. TIA Thank you. But ListView.ItemsSource is supposed to implement IEnumerable interface, but neither DataSet nor DataTable do this :-( ...Show All

• Visual C++ Information about handle

  hi all As VC++ programmer we are always use HANDLE 1> What is handle 2> Why handle is useful more than pointer . 3> What is benefit of using handle Please explain me in details Handle is C-style replacement of pointer to class instance. In C++ you can create object of some class and use pointer to it to access class methods. C-style API also creates different objects, and returns handles which should be used for all subsequent calls to this object. For example, CreateWindow function returns window handle HWND, which must be stored by caller. All window functions, like GetWindowText, have first parameter HWND, which is used to identify object created by Cre ...Show All

• Smart Device Development Load Method and Close Method in C# and Vb.net

  i try to convert C# code to vb.net, but below code i do not know how to convert can some one help me Below code is appear in private void InitializeComponent(){} this.Load += new System.EventHandler(this.Form1_Load); this.Closed += new System.EventHandler(this.Form1_Closed); In vb.net i cannot found me.Load and me.Closed because Load and Closed is Method for Class. There are two ways you can do this... with the AddHandler keyword (very similar to the C# way) or using the Handles keyword. First up... AddHandler : Assuming you’ve already got your event handling functions setup that look like this: Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) H ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Is DirectX9c realistic for all my UI needs?

  I am currently wanting to use the DirectX 9c UI for all of my UI needs in my game. Like using a MultiListEditBox for a complex trade window tracker editor and also an inventory being able to drag and drop 3d images of my items. Is it realistic Do I need to wait for XNA and how much would it cost I would like to use it for free but if not willing to pay a few dollars. Do I have to use something else like CEGUI or something else Thanks I changed my name from Ioncycle to Pantomime. Don't ask why...:-) I am using C++ DX9c to write it. No managed code but would use it if I needed a library for something minor that C++ didn't have. OK, I probably wont use XNA then, maybe for a different game, because I have my ...Show All