Andrew Greatorex's Q&A profile
SQL Server Passing multi value parameter to the Drill through report
Hi I have two reports say Report A and Report B. Both reports using same parameters. I am Navigating from Report A to Report B using Jump to Report option. Now when I pass multiple parameter to the Report B it only displays first parameter results. In report B I have parameter multi value select to true. I would like to know if its possible or not to pass multi value parameter in drill through report I would appreciate if someone can help me here. Regards Amit Yes you can pass multi value parameters to a drill through report. It works similar to multi value parameters for subreports, which is discussed in detail in this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=163803&S ...Show All
SQL Server Copying database using "Copy Database"
I am struggling with the "Copy Database Wizard" in SQL Server 2005. I am used to working with DTS to copy data from one server to another, but with the new tools, I am having serious problems (in fact, it's unusable) 1. When copying a database using the "SQL Management Object" method, I always get errors concerning logins. If I select not to copy logins, I get errors "sp_grantdbaccess failed". If I do select to copy logins, the logins can't be created because the machine names are different (one the source machine, the login is called MACHINE1/mylogin, but on the destination machine, such a login cannot be created) 2. For small databases, I ALWAYS get the error "CREATE DATABASE failed. Primary file must be at least 3 MB to accommodat ...Show All
SQL Server Can we add a button to report using .net script, in visual studio 2005?
Is there a straight forward way of adding button controls in a report How can it be done using a .net or VB script in visual studio (reporting services) thanks!! ...Show All
.NET Development How to invoke SOAP web service with C#
New to programming and need help on invoking a SOAP webservice in C#. I'm not getting a response from my Web Request code below. Is the WebRequest/WebReponse object suitable for invoking SOAP webservices Please let me know what modifications I need to make. Any help is appreciated. public DataSet GetMeter( string DEVICEID, string UID) { //create a web request object WebRequest request = WebRequest.Create(ConfigurationSettings.AppSettings["METERURL"]); //Add MeterPing URL to web.config request.Method = "POST"; request.ContentType = "application/x-www-form-urlencoded"; Stream ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Managed vs Unmanaged, Primitive design and .NET
I actually have three separate questions here. Please bear with me. Managed vs Unmanaged I searched several post and didn't find the answer I was looking for. Simply put, if you are designing a 3D game engine that needs to push 30+ frames a second, would you even consider using a managed language It seems to me that when the garbage collector kicks in your frame rate will/may plummet. What is the concensus on using managed vs unmanaged code in a game engine Primitive Design I have built a rudimentary 3D engine using good OOD where the primitives (points, polygons, lines, etc.) provide methods for their management and transformations. If I have a model with 100,000 points, each point carries the overhead of the virtual function table and ...Show All
Visual C# Input Message Box in C#?
Is there any control like an Input Message Box (users of VB would recognize this) I need a pop-up in the same form (pop-up not being a seperate form or a MDI child) for the Login Id and password Any Suggestions thx in advance, Believe it or not but this question is fairly common, especially coming from those who have previous experience with Visual Basic. Unfortunately C# does not have anything like what you are after, but the beauty of .Net is that you are able to access methods/functions from other certain languages. In order to do this you need to Add a Reference to Microsoft.VisualBasic.dll. Once you have done so you will have access to Microsoft.VisualBasic.Interaction.InputBox. Below is an ...Show All
Internet Explorer Development A problem about IHTMLPainter in IE7
I use IHTMLPainter to draw some shapes in IE. In IE7, some pages, for example: http://runonce.msn.com/runonce2.aspx . The css in this page is CSS1Compact Mode, if the page have a horizontal scroll bar, the method IHTMLPainter::Draw will be called in some strange parameters. for example: IHTMLPainter::Draw(RECT rcBounds, RECT rcUpdate, LONG lDrawFlags, HDC hdc, LPVOID pvDrawObject) doc range :( width:800, height:600 ) window range: (width:700, height:600) scroll pos:(horizontal :100,verticalscroll :0 ) the parameter that called by IE7 will be the following data. rcBounds:(left:-100,top: 0,right: 600, bottom: 600) so I can not draw a regin(600,0,700,600). It is a BUG ...Show All
Windows Forms Closing ChildForm in an MDI Application
Hi, I need assitance in closing a child form under certain circumstances. What I need to accomplish is when the child form opens it checks a value in the registry, if this value is absent I need the form to stop loading and return to the Parent from. How can I acheive this Here's my code so far.. <Code> namespace Mort { public partial class frmFuneral : Form { public frmFuneral() { InitializeComponent(); } private string myPath; private void frmFuneral_Load(object sender, EventArgs e) { CheckRegKey(); } private void CheckRegKey() { RegistryKey myKey = Registry.LocalMachine.OpenSubKey("Software\\Mort", true); string myPath = (string)myKey.GetValue("DBP ...Show All
SQL Server Unix shell Script and Macros are Available in SSIS ?
Hi all , i am preaparing POC Document for SSIS and also compare with already created Job in Oracle Using Data Stage Server. The follwing List tasks are we can do in Data Stage Sever. " 1. Unix Shell scripts can be called before/after the job runs. 2. Programming can be done through: a. Routines b. Macros c. Subroutines d. Functions e. Expressions 3. Programming can be done in Mainframe jobs and COBOL code and JCL files can be generated. 4. The DataStage Reporting Tool is flexible and allows you to generate reports at various levels within a project, for example, entire job, single stage, set of stages, etc. " The above Task will we do in SSIS Pacakge or not pls any one give me the correct ...Show All
Visual Studio Express Editions Trying to install VB Express
Morning all I'm trying to install the above program from this address :- http://msdn.microsoft.com/vstudio/express/vb/download/ I have downloaded the .exe file (2.82MB) and tried to run it as well as just clicking on Open and run it that way. It gets so far and then tells me I have previous Beta installations that I need to get rid of. I have tried using the autouninstall tool as directed, but that just gives me a new window with the following text in it :- < xml-stylesheet type="text/xsl" href="C:\DOCUME~1\Richard\LOCALS~1\Temp\IXP000.TMP\issues.xslt" > <Issues><Issue><Name>Uninstall Visual Studio components</Name><Id>{BB69B4AB-619E-487f-B0C2-5ACD1AE5A9A0}</Id><Descripti ...Show All
Visual Studio Team System Builds Failing - Help
Hi! I have a project (Project A) in Team Foundation Server in source control. I also have Project B which is also in source control which Project A references. When I create a build type for Project A and run it, it fails saying that Project B.csproj could not be found. Shouldn't the build automatically pull the sources for Project B Regards Ray Project A and B are in the same solution (different Team Projects though) and are referenced via project references. I'm also not sure how the workspace mapping actually works. The error I get is "C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets(306,5): error : TF42091: A workspace needed for build could not be ...Show All
Visual Studio Express Editions How to get Free VBE E-Book
I obtained VBE 2005 in a looong download. I registered it using my real name. I accessed the VBE forum using a fictitious name. I want to obtain the free VBE book "Writing my first program" but when I try to obtain it I get a page stating I have no permission to get it and it gives me a long coded value that looks suspiciously like something in the Windows registry. It offers me a change to contact someone and use the entered code as a reference. How do I complete the process to obtain my free copy of the e-book, preferably downloaded Please respond to old7t1@msn.com Thank you. The C#book and the Web Developer book is there for download but the Visual Basic book is not available. It has ...Show All
Smart Device Development HP pda how do i install apps
hey guys (girls) how do ii install a app that i have created in visual studio vb.net i am using btw also 2005 visual studio as my ide You'd need to create installer for it. See this . ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Refrences and book advice
Hi all, I was wondering if anyone had some good advice on books/types of books to pick up for this development. I do not know C# but I have been programming C++, etc for many years so I am not a beginner. Would your advice be to get a book one visual C#, or just C#, or something along those lines I would also assume I need a book on direct X programming I just want to make sure I am heading myself in the correct direction before picking up some books. Thanks a ton and I apprecitae the help! Ok, thanks a bunch. I will wait on the DirectC stuff and try to learn C# while I wait for more resources. Is C# really the place to start Thank you ...Show All
SQL Server NON_EMPTY_BEHAVIOR if NON EMPTY isn't used
A cube I'm working on has lots of calculations. But none of the MDX queries in the reports use the NON EMPTY clause or the NonEmpty function. What I'm wondering is whether the optimizer or any other part of the Formula Engine uses NON_EMPTY_BEHAVIOR for anything else besides removing empty cells from the resultset. If the Sum function is summing two calculated measures, will a NEB on those two calculated measures help the Sum function, for example That's the kind of thing I'm looking for... places where NEB is used other than removing entire cells from the resultset. Mosha, thanks for the reply. The takeaway from your blog regarding NEBs is that the multiplication operator (as in the * operator used for math, not for crossjoin ...Show All