MyselffNot's Q&A profile

• Visual Studio Tools for Office Catching Unhandled Exceptions

  Hi, I am trying to catch unhandled exceptions in my code for a c# workbook. I have tried using the: AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(HandleException); (this is set in the ThisWorkbook_Startup method) but my HandleException method is never called and i get the default "Office document customistation is not available" error message. This isn't ideal as the customisation breaks and stops working, I'd like to handle the exception myself and carry on. The workaround is to put try catches on all my code but handling the unhandled exception would be better. The exceptions only ever tend to be network timeouts, but occasionally something else goes wrong. Thanks ...Show All

• SQL Server Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio)

  Analysis Services Project deployes with success. When you want to browse the deployed cube by draging an attribute from the Metadata pane to drop it on the DataPane the following takes place. =================================== Error HRESULT E_FAIL has been returned from a call to a COM component. (Microsoft Visual Studio) ------------------------------ Program Location: at Microsoft.Office.Interop.Owc11.PivotView.get_FieldSets() at Microsoft.AnalysisServices.Controls.PivotTableHash.get_FieldSetsEnumerator() at Microsoft.AnalysisServices.Controls.PivotTableHash.GetFieldSet(String uniqueName) at Microsoft.AnalysisServices.Controls.PivotTableBoundMetadataBrowser.GetPivotTableDataObject(NodeObject nodeObject) at Microsoft.Ana ...Show All

• SQL Server known error with Transfer SQL Server Objects Task...

  https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=127100 I don't believe that the fix to the above issue has made its way into an SP yet. Can anyone confirm/refute this, and/or state when the fix will become publicly available &/or give a workaround Thanks, Tamim. ...Show All

• SQL Server Page width and height setting problem

  We have a problem in page layout. From the report properties, we set the page width and length. But previewing the page finds the page is much longer than setting in the properties. Exporting the page to PDF gets different page size. That totally messes up our page number. Anyone had this problem before and knows why. I appreciate it if anybody can help. Thanks. Hi, just to be sure, the sum of borders and width does not exceed 8,5 / 11 inches, right You have to differ between the margins of the Report and the actual paper size. If the Report does not dit on the paper size, you probably will get extra pages. For the mentioned error: Which SQL Server version (Reporting Services) are you using If you are ...Show All

• SQL Server Report Designer Save Bug

  When modifying a query on the data tab of report designer, it only appears to save the changes when I switch to the layout or preview tabs before saving. If I just modify the query, save, close and re-open, the changes are lost. If I do the same but switch to the layout or preview tab before saving, the changes are saved. I'm not sure if this is a known bug, but is there a fix Cheers! ...Show All

• .NET Development notifyIcon works with windows forms but not services....

  If I create a NotifyIcon in a designer of a windows application and assign an icon to it - it works just fine. It shows up in the tray, and behaves just as it should. However, if I create it in a windows service, then install that service and run it - the icon doesn't show up in the tray. I have no idea why. Any suggestions oh also, I couldn't find a better forum to post this in, so hope this works. do the following steps: 1. right click on My computer, click Manage 2. select services and applications, then select services. 3. select your service among all services listed. 4. right click , select properties, select Logon tab. 5. select Local System Account, CHECK "Allow service to in ...Show All

• Smart Device Development VS2005(CF2.0) - PPC 2002

  Hi, Presently I am working on VS2005(CF2.0). Can any one tell whether my appliation work (deployed) on pocket pc 2000. If you have an idea please let me know which plat forms are supported by CF2.0 Thanks in Advance. and hopefully that solution was the realization that a CF2.0 application will run on any platform you can install the CF2.0 framework on ...Show All

• Software Development for Windows Vista Debug WM5 app using VS2005

  hi folks, has anyone successfully set up and debug a WM5 application under VS2005 i have just migrated the development setup from Windows XP to Vista. all went ok but when i attempt to start the debug, deployment fails because "activesync is not installed." i understand that Vista has WMDC instead of AS. when i tried to install the latest beta3, it did not seem to complete since it did not display any dialogs and i do not see WMDC in my Control Panel. all i see is the Windows Mobility Center. any ideas thanks... an update for those battling the same issue: in order to install WMDC beta3 completely, you must connect a real device. then, the setup continues otherwise it just exits sile ...Show All

• SQL Server SQL 2005 Express local admin access denied

  I am using a standard installation of SQL 2005 Express installed with Visual C# Express. I have tried several connection strings, have tried connecting different databases, all of which end up giving me access denied for user <machineName>\Greg (Greg is the local admin account for this PC. I found this guideline for connectivity questions (http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=362498&SiteID=1), and have gone through it all, posting the answers to questions here. One thing that may be different about this machine is that it is a tablet PC (WinXP Tablet edition) and I am running VMWare Server. I also tried loading it on a WinXP Pro workstation with no VMWare, and have gotten the same results. Any help will be greatl ...Show All

• Visual Studio How to add DropDownList Control inside ReportViewer Control.

  Hi, I am working with ASP.NET.I am using ReportViwer Control to show my report.I like to add dropdownlist with in the reportviewer control. ( Not top to the control some thing like that).I need to place dropdown near to Export link ( Excel and PDF Export).Is it possible to add at the dropdown list with in report viewer control . I found the property as ReportViewer.Controls.Add.But its not working.Please help me. Regards, S.Sevugan. ...Show All

• SQL Server Aggregation functions in Calculated Measures displays wrong values.

  Hi, I think this calculated measure implementation is making me absent minded, so if this seems like a silly question, please ignore my behaviour but do answer to my post :-) I will ask this question with a sample data: consider that the cube consists of School Children's names as the first dimension (school_children) and date(jan, feb....) as the second dimension. the measure (M) is the 'exam scores' of the school children. jan feb mar school_children M M M ----------------------- tony 50 20 40 bony 10 40 40 mony 60 60 70 Now when i add a calculated measure where I want to display the avg marks of each. so in the calculated measures formula I add: Avg([Measures].[M]). (This is ...Show All

• SQL Server toggle all

  I have seen other places where this question is asked, but I am still not seeing the answer clearly. If I have many groups that are collapsed and I want to expand them all at the same time, it there a way to accomplish this Many talk about a param that can be passed in, but even if you have the parameter set, this is only for the initail state, is it not My initial toggle visibility and images are working just fine with the parameter solution. I did the following: Add a new report parameter: Name: ExpandCollapseAll Data type: Boolean Prompt: Expand / Collapse All Available values: Non-queried Label: Collapse All. Value: False. Label: Expand All. ...Show All

• Visual C++ Disable Found New Hardware Wizard

  Is there a way to prevent (with some API calls) the Found New Hardware Wizard from starting when a new device appears. I need to write a service that will install the drivers for a device when it appears without any user assistance. The actual device is not known beforehand, so the preinstalling of the required drivers before the device is plugged is not an option.   zelenoto wrote: Is there a way to prevent (with some API calls) the Found New Hardware Wizard from starting when a new device appears.  Yes it should be possible using WMI.  You can either write your own script if you understand WMI well or search the net for WMI scripts to do this.  BTW this question ...Show All

• Visual C++ How to make dynamic 2D arrays?

  Is it possible to have a dynamically sized 2D or 3D array For a normal 1D array, I have 2 methods: 1) create a pointer to a variable, then initializing it with a supplied size: int *iTemp; iTemp = new int[100]; 2) use a CList. CList<int,int&>iTemp; But these methods fail when I try to make a 2D array. i.e. iTemp = new int[10][10] \\not possible Is there a way to achieve this instead of CList   einaros wrote: That's the same URL I posted. It doesn't hurt to read other people's posts once in a while, to avoid dupes I appologize, it was unintentional. Please delete my post, since it seems I cannot do that. ...Show All

• SQL Server INTERSECT MDX Query - Reg

  Hi Everyone, We are facing some problem in the cube particularly in INTERSECT function. Here are the details. Dimension Tables: DimTime 200601 200602 DimProduct 01 02 DimUser 101 102 103 FactTables: FactPlayer Time Product User 200601 01 101 200601 02 101 200601 01 102 Transact SQL Query: Select Count(*) from ( Select userid from FactPlayer where productId = 01 ...Show All