maestro_h's Q&A profile

• SQL Server How to define a Left Outer Join in report using ReportModel as DataSource

  Dear ppl, I got a Report Model Project, in which i have created a model of my Database and deployed it on the server... Then I have a Report Server project for my reports. The reports are using Report Model as the DataSource... Now in the Report Designer, inside a report, when I define query for Dataset using Report Model , I can't find a way to write a left Outer Join query... It always performs Inner Joins... was wondering ether Report model supports Outer Joins ... I might achive this using two different datasets but then i'll end up using two data regions e.g. 2 tables, but i don't want to do that... instead I want all of my data to appear in a single table which can reference to single dataset. Is there a way to define ...Show All

• Gadgets ActiveX problem

  We have created an ActiveX program in Visual Basic (6) for one of our gadgets, but while the activex control is running, it's not possible to interact with the gadget. Unfortunately, the ActiveX control runs for around 5 seconds, so I can't see this being such a good idea as an end-user gadget *grin* Is there a way to make the ActiveX control run asynchronously Does anyone know how to do it in VB6 Thanks in advance for the help. Andy Is it not possible to kick off a timer and do what you are doing That way, the activex gets a chance to process user events as well as do it's own stuff ...Show All

• Windows Live Developer Forums Beginner Qn: Is Live Search using the existing MSN search only?

  Couldn't find out much from the contents on the website. Is it the same search engine being rebranded or is it totally new algorithm/product for searching If same, why is/was Live search on beta for such a long period of time ...Show All

• Windows Forms After installing SP 2 computer locks up when attempting restart - num lock illuminates also

  I have installed SP 2 and IE 7 through Windows update site. All seems to work until I try to re-start the computer. The screen clears and commences to unload programs when it gets to a point where the num lock illuminates the screen goes blank and the computer locks up but will not re-boot. Manual restart is required. Windopws XP Home OS, AMD Athlon 64 processor. Any suggestions Hi Don Gino, thank you for replying to my message. I have had to completely restore my HD several times in order to rid my computer of this problem. I am a little more lucky than you in that everything else is working save for the auto re-boot. I have been working with a very patient grade 1 technician on the phone from Mic ...Show All

• SQL Server SSAS2000 - Unable to locate the cube

  Hi, I am facing issues with a SQL Server Analysis Services database. Unable to locate the cube SQL Server Enterprise Ed 2000 SP4 - Analysis Services Clustered server Active/Passive node We had a network issue today, and due to that we had a fail-over of our clustered server. What caused what is still unsure, but in general most problems are solved now, except one big nasty one. A couple of databases are around with cubes on our database server, and most of them are available, but the most important one seem to be corrupt. The repository is on SQL Server. In Analysis Manager: - I can't access certain cubes through browse data, the shown message is "Unable to browse the cube XX Unable to locate the cube XX" - I can mana ...Show All

• SQL Server Password in config file

  Hi Config files doesn't seem to work for me :( i want to make a common config file for all of my packages but it is giving me error Validation error. The AcquireConnection method call to the connection manager failed with error code 0xC0202009 I have placed pasword in my config file too. Following is config file which i m using, server name n password are masked. < xml version="1.0" > <DTSConfiguration> <DTSConfigurationHeading> <DTSConfigurationFileInfo GeneratedBy="SSBKD\955688" GeneratedFromPackageName="DTS_ACPM_MarkIT_Indices_Composites_TRAC_X_Asia_Index" GeneratedFromPackageID="{CB3660A1-5E6C-4D08-A7F5-4D6CE83578E2}" GeneratedDate="2006/10/19 14:05:20&q ...Show All

• SQL Server Error creating Subscription to reports

  Hi all,   I am having a HUGE issue with SSRS, I am running SQL 2005 on Win 2003 server, the SQL uses SQL and windows permissions. I have a datasource which stores it credentials securely on the server but for some reason when i try to subscribe to the report it errors saying "Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked server the link is no longer valid." Beats me but the credentials are stored, I am  connecting using a user account which can run the report fine (This is proven). I have SP1 installed, and have literally tried every last option in the book.   N.B i have read all the existing post about this and i seem to have a different ...Show All

• Windows Forms Winform Automation Challenges

  Hi, I was looking some information on automating winform applications. Are there are any controls having some specific testing challenges (e.g. let's say DataGridView control) Any other special challenges in automating winfoms applications I've gone through various articles related to winform automation on MSDN. As we can do automation in varous ways through reflection, Low-Level UI Test Automation, MSAA, UIA so which one is most appropriate -Aaryan Have a look at Nunit for your Class library stuff i.e Buslayer and Datalayer. Try and keep as much logic off your presentation layer to get the best return . Have a look at http://nunitforms.sourceforge.net/ NunitForms ; ...Show All

• SQL Server prompting for date range parameters with Report Builder?

  Hello, I am trying to create a report using Report Builder (not Report Designer) that prompts the user for a Date range to filter on.  The problem is that once I change the filter to be a "From...To" parameter, it removes the "promptable" green question mark icon from the filter condition.  I can't click on the field and get the "Prompt" option either.  I only see "Edit As Formula" and "Remove Condition" in the context menu when I set the date filter to a "From...To" filter.  Is this a limitation in Report Builder I have found that by using both the "On or After" And "On or Before" I can mimick this functionality, but I can't control how the prompts are displayed. Assuming my Date field is called "Created Date", ...Show All

• SQL Server Set paper size to landscape: always

  Hi I have a report that I have set up as page width 11 page height 8.5 within VS, when I deploy the report and view it and print preview the report always defaults to legal size paper. How can I make sure the report prints on letter in landscape view ...Show All

• Audio and Video Development Xpath expressions in Include in Markup Files

  Is there any restriction whatsoever on the kind of X-Path expressions that can be used in <include> element. e.g. can a stylesheet be included on a condition whose truth value is determined by an xpath expression refering the DOM nodes. i think i got it.......... another question the spec says ...7.5.3.1.7 .. the infset for each include is the infoset of document prior to include processing.Does it mean the partial DOm tree (if any) built upto the include node can be reffered It seems so. ...Show All

• Visual Studio Tools for Office Accessing an Excel TextBox from c#

  I need to access a named Excel text box from c# code. I have successfully been using Microsoft.Office.Interop.Excel.Range to access cells, but I don't see how to get the handle of a textbox. Should I be doing this through the TextBox interface, or the IShape interface Hi Neophyte This still isn't the right place, but probably a bit closer than where ever you were :-) The best place to ask questions concerning automation of Office applications are the office.developer newsgroups, as listed in the " Please Read First " posting at the top of this - the VSTO - forum (primarily concerned with the VSTO technology). I recommend office.developer.automation for this particular question. When you as ...Show All

• Visual Studio Team System Converting build process to Team Build

  Hi all, In our current build process we use Nant, and have the following configuration: Each solution has an associated build file, that builds only that solution and places the dll in a shared location. Developers run this build file when they have made a change to ensure their modification does not break the build. We then have a master build file, which calls each individual build file (of each solution that make up the program) in order of dependencies to build the full program. We are moving over to TFS and are hoping to use Team Build. The problem is i cannot seem to see how our current way of working can be mapped to the Team Build process; here are the options we have discussed: ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. What is a sprite

  i found everything about sprite, but nothing about what it is. could anyone tell  (2d object i guess) (i cannot translate "sprite" to turkish and i have a problem with this :)  ) thanks A "sprite" in simplest terms just relates to an image or object that you draw on the screen. So using the old game "Pong" as an example. The ball would be a "sprite", each of the paddles would be a "sprite". ...Show All

• Software Development for Windows Vista Is there a standard local folder that a non administrator can always write to.

  That is, is there a standard folder which is both guaranteed to be writable by a non- administrator and guaranteed to be local rather than on a network share Yup- char szPath[_MAX_PATH]; SHGetFolderPath (NULL, CSIDL_COMMON_APPDATA | CSIDL_FLAG_CREATE, NULL, 0, szPath) This finds the Vista equivalent of XP's "\documents and settings\all users\application data" folder. In The flag CSIDL_COMMON_APPDATA is one of many (for Start Menu, Favorites, Templates, Documents, etc). The CSIDL_FLAG_CREATE flag causes the folder to be created if it doesn't exist. These flags are defined in shlobj.h. ...Show All