MacroHard's Q&A profile

• SQL Server How to add YTD (Calculation) to Time Dimension?

  Is there any you can add YTD to Time Dimension as attribute Or it has to be Calculation Then how do we do this Is this need to base on Dimension or Measure I would prefer this to be base on dimension and show in Time dimension hierarchy. Any inputs on this are highly appreciated.   If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other p ...Show All

• SQL Server How to get the value of script of various SQLDMO(version 8.0) objects

  Hello, I am working on a project where I want to access and modify some objects of Microsoft SQL 2000 database. Would someone help me how to do this I need following informations; - Script of the checks of a table - Script of the Indexes of a table - Script of Key object(Primary or Forign key) - Script of Permissions of View and Stored procedure The following code returns no result; MyTabelClass mytabelClass = new MyTabelClass(); mytabelClass.Naam = table.Name; mytabelClass.ChecksScript = table.Script(SQLDMO_SCRIPT_TYPE.SQLDMOScript_DRI_Checks, string .Empty, string .Empty,SQLDMO_SCRIPT2_TYPE.SQLDMOScript2_Default); mytabelClass.Indexe ...Show All

• SQL Server order of packages within a project

  Is there a way to reorder the packages within a project For example, if a parject contains three packages (p1, p2, and p3) and I decide that p3 really logically belongs first (gets executed in that order, maybe), then is there a way to move p3 so that it is at the top of the listing of packages for the project I like to keep things neat. Thanks! What is the best way to edit that file. I tried notepad with success. ...Show All

• Smart Device Development PocketPC 2003 Full Screen App

  I am modifying a PocketPC 2003 Visual Basic app. I am using VS 2003. Does anyone know how to write the app so it runs full screen I basically want my app to start full screen when the user turns on the device and lock the device down so that's all the user can do and use all of the real estate on the screen.. I'll include some backdoor way to get to the OS if required. Any help or direction would be greatly appreciated. Actually, no. It seems as if the task bar and main menu are related in that they are on the same "layer". As long as there is a main menu displayed, it appears the maxi ...Show All

• SQL Server Create File Option In File Connection Manager

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the properties that you could want to change; often I need to change the same property in the same way each time (for example I'd like to set the Batch Size for a OLE DB destination to 1000 instead than 0 ...Show All

• Visual Studio Tools for Office VSTO 2005 Hands on Excel Lab Problems

  I'm having some trouble with trying to run through the Hands-on Labs for Excel 2003 which I downloaded from the MS VSTO 2005 site. Not sure if my problem is an installation problem with VSTO 2005, VS 2005 or Excel 2003. I can create the Hands-on project using the Excel Workbook template. However when I run the project in Debug mode I receive the following error message. Problem #1: A call to PInvoke function 'WRDomainSetup!WRDomainSetup.EverettPolicy::GetRequestedRuntimeInfo' has unbalanced the stack. This is likely because the managed PInvoke signature does not match the unmanaged target signature. Check that the calling convention ...Show All

• .NET Development Efficient code for connecting to SQL, advice please

  Hi, I have an application which is similar to the following example Private Sub Start() For a as int16 = 1 to 300 lstResults.items.add(GetPriceFromItem(a)) Next End Sub Private Function GetPriceFromItem(byval item as int16) as String 'Connect to SQL 'Execute "SELECT Price FROM Table WHERE Item='" & item.tostring & "'" 'Close Database connection 'Return Price End Function I want to know if there is a more efficeint way of doing this, i.e. i'm concerned that the routine creates 300 SqlConnection instances, 300 open/closes and 300 queries Would a better way be to connect to SQL once, get the entire tab ...Show All

• .NET Development Deprecated API?

  I am migrating a body of C++ code from VS .NET 2003 to 2005. While still in the documentation, GCHandle::op_Explicit() seems to have vanished (the compiler and intellisense no longer know about it). Does anybody know if this was intentional or accidental Thanks Henry op_explicit (and other op_ ) methods are "pseudo" functions that are used by compilers in place of standard operators like addition and conversion. In the case of op_explicit it is defining an explicit conversion from one type to another. This permits you to do a typecast and the compiler not complain about it. As far as I kn ...Show All

• Visual Studio Difficulty setting ReportParameter

  I am running into issues with setting the ReportParameter method. I am dynamcially setting an ObjectDataSource that is connected to a class object, and dynamically setting a ReportViewer Object. I am running into issues setting the parameters for the report dynamicallly. Here is my code: ------------------------------------------------------------------------ public partial class ProductReport : System.Web.UI. Page { protected ReportViewer reportViewer = new ReportViewer (); protected ObjectDataSource objDataSource = new ObjectDataSource (); protected System.Web.UI.HtmlControls. HtmlTableCell tdRptViewer = new ...Show All

• Visual C# Loading word document parameters into datagrid

  Hi, I am developing an application where user will browse and load the word document template into the webbrowser control. This word document template will contain few words like <<word>>....<<word>>. I want to load only these items into the datagrid. I am trying to use mailmerge but it is not supporting. Thanking you, Prashant ...Show All

• Microsoft ISV Community Center Forums Vba commands used to connect to sql

  HI, Use the FileSystemObject... Sub OpenTextFileTest Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile( "c:\testfile.txt" , ForAppending , TristateFalse ) f.Write "Hello world!" f.Close End Sub ...Show All

• Visual Basic I did the whole "XML Saving Data" thing, how do I load the data?

  Ok, I followed the instructions given to me: ------------------------------------------------------------------------------------------------ First, create a class that has properties for the values that you want to change. Make sure that the class has a constructor (Sub New) that doesn't take any arguments. If you don't have a constructor on your class, you're fine. Add read/write properties for the data that you want to store. Now, you can use XML serialization to load/save your data. There should be a code snippet that shows how to do this: Right-click where you ...Show All

• Visual C++ Compiling x86 / x86-64 asm in VC++ projects

  I have VS 2005, running on Windows XP x64 on an AMD64 3400+. I recently learned some assembly, and I'm wanting to use it in some of my programming projects. Obviously, i want to compile for the x64 if possible. I'm disappointed to find that Microsoft, for some reason, does not support the __asm keyword for x86-64. I found some tutorials on compiling and linking asm files for VS 2003, and I tried them out, but they don't work for me in VS2005. Using CMD in windows, I can successfully assemble obj files using both ml.exe AND ml64.exe. However, when I put an asm file in a VC++ project, and set up the command line to "C:\Program Fi ...Show All

• Visual C++ CDialog::DoModal asserting in CWnd::DestroyWindow

  To Brian and Martin, who were involved in helping me out with this , please don't shout at me... This thread does follow on from that post - and I'm now investigating refactoring a static library which contains a few MFC classes into a shared DLL - using __declspec(dllexport) to export functions and classes that will be needed across all facets of the solution that need the shared functionality. I've looked all over the place for an answer to this question - and found loads of other people using MFC 6, 7 and 8 with similar problems. I'm not going to be naive enough to suggest that MFC has a bug - I'm well prepared for this being a s ...Show All

• Visual C++ Where is CWnd::CreateControl ?

  Hi, I am investigating if MSVC 8 provides a viable upgrade path for us. I have ported my MSVC 6 applications to MSVC 8 and have gotten all my libraries to compile. However, every application that uses an ActiveX control generates a linker error regarding CWnd::CreateControl. But my other MFC based applications link and apparently run correctly. What gives I appreciate your help but I have had to abandon my evaluation. I can't justify spending any more time on this. cheers ...Show All