Greg Y's Q&A profile

• SQL Server Hiding columns until toggled

  Hi all, Sorry if this question is a bit basic but I'm fairly new to reporting Services, I've searched for the answer but cannot find a definative answer. I have created a table report with three groups, Product Group, Product Type and Location. When the report is run there is obviously no data displayed in the report except for the first group, Product Group. What I would like to do is hide the columns without data until the first group is expanded and so on with all three groups. Is this possible and if so how Humbly yours, Chris Take a look at these forum threads; I think they can help you out! http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=519430&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx ...Show All

• SQL Server ClusterDistance value

  Can somebody please define the result of the ClusterDistance() function for me.  BOL and MSDN are vague about what the output means and I am getting some cases that have a value of zero and sometimes there are more than one per cluster.  Thanks in advance, Dan Meyers That's ok - it's an issue if you get more than one cluster per case with a ClusterDistance() of 0. Imagine if you have two identical cases - it would make sense that they have the same ClusterDistance(), would it not ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. mesh not rendering

  I set up my camera matrix to look at the origin. Then in my render loop I transform to the cameras matrix d3d->GetDevice()->SetTransform(D3DTS_VIEW, camera.GetViewMatrix()); begin the scene and set the render state. d3d->BeginScene(); d3d->GetDevice()->SetRenderState(D3DRS_FILLMODE, D3DFILL_WIREFRAME); then transform to the meshes matrix d3d->GetDevice()->SetTransform(D3DTS_WORLD, m_Object->GetMatrix()); and render the mesh m_Object->Render(d3d->GetDevice(), &meshes[m_Object->GetMesh()]); end the scene. nothing shows up on the screen, I took a look in the debugger and everything is positioned where it should be, is this not the proper way to set up the render loop. ...Show All

• SQL Server KeepTogether header does not work correctly.

  I selected "Repeat Group Header" in my grouping properties. This is working fine; however, if a group is to start as the last line in a page, the header prints on that last line and then the header is printed once more in the next page. Consequently I end up with two consecutive headers with no detail lines in between. How do I prevent the printing of two consecutive headers for the same group I want to get rid of the one that occurs as the last line on the page. For all the textboxes in the group header, select hide duplicates and select that group in the dropdown below that. It's just a suggestion which may or may not work. Shyam ...Show All

• Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

  Hi, Newbie using VSTO and developing office applications. The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done I installed PIA, VSTO2005SE w/ runtime, MS Office 2003 Web Components and will use MS Office 2003 (ver 11.0.7969.0) with ASP.Net 2.0. I tried some links and cannot find Actions Pane Control. What Am I missing Can anyone point me to some sample codes or resources to do this Thanks in advanced. den2005 Exactly what components should be working in which manner isn't clear from your description ...Show All

• SQL Server sql prob

  hi, i get Msg 208, Level 16, State 1, Line 1 Invalid object name 'a1'. i do have a1, what is the problem here thanks set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo] . [STP_InvoiceByPono] AS BEGIN SET NOCOUNT ON ; declare @Fieldname varchar ( 25 ) declare @stmt varchar ( max ) declare fields cursor for select amounttype from Inv_AmountTypes set @stmt = 'Select distinct a1.date_, a1.suppliercode, a1.invoiceid, a3.pono' open fields fetch next from fields into @fieldname while @@fetch_status = 0 Begin set @stmt = @stmt + ',(Select b3.amountfc from invoice b1 inner join Inv_Detailed b2 on b1. ...Show All

• Visual Studio 2008 (Pre-release) Transactions in DLinq

  Hi there, As I understand it DLinq automatically wraps any call to SubmitChanges() in a Transaction right Does this mean that all the updates made since SubmitChanges() was last called are guarded by the transaction I.e. that either all the updates made since SubmitChanges() was last call will succeed or none of them will be submitted Thanks, Ulrich I started with the DLINQ designer for C# I worked through the whole example and all worked OK. Then I wanted to see what SQL was being generated I started application as a SqlServer express application with an attached file. The sql profile analyzer did not show me any sql generated againast the db. I changed it so I ...Show All

• Visual Basic NotInheritable -> but I want to Inherit :)

  Hi! I'm trying to add a property to System.Windows.Forms.HtmlElement I've created a class that inherits HtmlElement. Howerver, HtmlElement is NotInheritable...so the question is: Is there any way of overriding NotInheritable so that I can make my HtmlElementWithProperty object (having all the features of HtmlElement + my string property ) Any other workarounds that might help Regards, Alex You'll have to fall back on the "aggregation" principle. Create you're own class that contains a HtmlElement and use it. ...Show All

• Visual Basic How to create a form to display 8 bits seperately of the byte and toggle them individually

  I am very new to VB and trying to do following. I am trying to create a form so that i can toggle bits to write to the parallel port also i wanted to read bits seperately insteady of byte in decimal or Hex. My main goal is to Read/write data to parallel port which i can do it. I do not know how to group bits in a byte using form. I want to toggle bits to see the response. Any help will be greatly appreciated. Try out this test program and see if it helps. < Global .Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _ Partial Class Form1 Inherits System.Windows.Forms.Form 'Form overrides dispose to clean up the component list. <System.Diagnostics. ...Show All

• Visual Basic Login via Access Database help

  Hi, I recently got VB 2005 and really like the new features. However, I am on an intermediate level learning Visual Basic. For a test project, I plan to create a login form that validates users through an access database located on a server. Basically, there is a set username and password in the access database and I want my program to execute the main program once the user is validated via the database. I was struggling on this for about a week, but I have no idea on how to do it. I can arrange the controls on my form, but I just need to know how to validate the users. Any ideas Dim myReader As OleDbDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection) Has anyon ...Show All

• Visual Studio Tools for Office Embedding Active X control in Office application using VSTO 2005

  Hi All, I have developed an add-in for Ms-PowerPoint using Visual Studio Tools for Office 2005 (VSTO SE 2005). This add-in is developed in C#.NET. The functionality of the menu item developed is to embed my own Active X when clicked. I used this piece of code to embed my ActiveX control. Eg: To embed Calendar control. Microsoft.Office.Interop.PowerPoint.Shape shp = this.Application.ActiveWindow.Selection.SlideRange.Shapes.AddOLEObject(42,48,630,438,"MSCAL.Calendar.7","",Microsoft.Office.Core.MsoTriState.msoFalse, "",0,"",Microsoft.Office.Core.MsoTriState.msoFalse); I could successfully able to embed my ActiveX control as a PowerPoint shape. Now, I have some exposed ...Show All

• SQL Server Basic questions on Service Master Key

  Hi. I'm reading about encryption and not totally up-to-speed on what the Service Master Key is all about... Let me paraphrase this book: Microsoft SQL Server 2005 Implementation and Maintenance Training Kit by Microsoft Press, while I ask questions... ___________________________________________________________ The database engine uses the Service Master Key to encrypt... - Linked server passwords (example ) - Connection Strings (example ) - Account credentials (example ) - All database master keys You should back up the Service Master Key and store it offsite. (Even if I never plan to use encryption ) ALTER SERVICE MASTER KEY REGENERATE regenerates the service master key. (Is it building a completely different key, or regenerat ...Show All

• Visual C++ error LNK2001

  Hi, (I saw the post on same subject but it seems to be a little different. so I'll use some word from that post!) There is a project earlier written in VC++ 6.0.  I opened the same project in VS. NET 2005 and I am trying to compile.  The code compiles properly (with couple of warnings) but while linking I am getting unresolved external symbol errors like this: The linker seems to have problem with seeing .obj from files in program (which are in the debug directory). It doesn't seem that the /Zl switch or the /NODEFAULTLIB  are on. 1>Linking... 1>Utm.obj : error LNK2001: unresolved external symbol _RTC_Shutdown 1>Zone.obj : error LNK2001: unresolved external symbol _RTC_Shutdown 1>Zones.obj ...Show All

• Visual Studio Express Editions Questions / Answers : Evaluation Outlines !!!

  I am developing an ITS System , in the Evaluation Stage , can someone help me with the outlines for developing the evaluation : What is the most approciate way for storing the Questions and Answers : Multiple Choices , TRUE / FALSE , and any other Questions and Answers form and ... What is the best way for Representing the Questions and Answers to the Learner and ... Finally Thank you so much :) okay charles let's go through this one by one to show the question to the user i am using the DataReader : I'm using a label control to show the question text if i tried this line while (MyReader.Read()) { label2.Text = MyReader[ "Question ...Show All

• Visual Basic How can I connect to the internet with windows internet connections

  In each computer there are several network connections in "Network Connections" in the controll panel. How can I get a list of them and connnect to one of them For example , the user has a DSL connection in his Network Connections i want to establish this connection with my program ... Use the System.Net.NetworkInformation Namespace and start with: Dim MyNetworkInterfaces () As NetworkInterface = N etworkInterface . GetAllNetworkInterfaces () From there you can test each interface for usability and properties ...Show All