Erno Vuori's Q&A profile

• SQL Server How to Control Sheet Name of Exported Excel Report?

  Is there a way to control the sheet name when a report is exported to Excel I have four matrices where a page break is made between each of them. Once exported to Excel, the resulting file has "Sheet1", "Sheet2", "Sheet3" and "Sheet4" as the names of its worksheets. Would it be possible to change it to a more user-friendly name This is not possible with RS 2000 or 2005 by itself. It's on our wishlist for a future release. You can do this today with a third party tool SoftArtisans OfficeWriter. With OfficeWriter you can name sheets at design time: http://officewriter.softartisans.com/officewriter-250.a ...Show All

• Visual Studio Express Editions Can't assign a property from a module

  Hello I have a form called Mainform and a module called module1. On the form, there is a statusbar with a label and a progressbar. Now I have this code in the module: '// Place a progressbar an our statusbar Public Sub provide_status( ByVal text As String , ByVal complete As Integer ) Mainform.ToolStripProgressBar1.Visible = True Mainform.ToolStripStatusLabel1.Text = text Mainform.ToolStripProgressBar1.Value = complete End Sub '// Please call this when your process finishes Public Sub status_finish() Mainform.ToolStripProgressBar1.Visible = False End Sub I call the f ...Show All

• Visual Studio Express Editions link.exe error

  I followed this tutorial: Building Windows Forms Applications with Wizards in Visual C++ Express (12 Minutes - 8.2 MB) And I get an alert box that pops up and says: --------------------------- Microsoft Visual C++ Runtime Library --------------------------- Runtime Error! Program: C:\Program Files\Microsoft Visual Studio 8\VC\bin\link.exe This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. --------------------------- OK --------------------------- When I click OK, the output window at the bottom of VC++ EE says: Project : error PRJ ...Show All

• Windows Forms DLL Reference Flip-Flop

  I've got a project with a reference to a DLL that was provided by a colleague of mine.  When my solution is using the Debug configuration, everything is fine.  When I switch to Release Configuration, one of the types exposed by the assembly disappears from Intellisense and I get a compile error when I try to use it. I haven't used any co ...Show All

• SQL Server How to Fetch the Recrods from MS Access and using it in Script Task Using Control Flow Tools(Execute SQL Task)

  Hi I have an application like fetching records from the DataBase(MS Access 2000) and results i have to use in Script Task. At present i have used the record fetching query,connection string in Script itself. I would like to use in Independently. Is there any Tools like (Control Flow Tools like Execute SQL Task) are there to fetch the result set from Acccess and can use the fetching results in Script Task.... Thanks & Regards Deepu M.I Hello, Yes, you can achieve this by loading the data into an ADO recordset using the Recordset Destination Adapter. This adapter loads the data into a var ...Show All

• Visual FoxPro RSA Public/Private Key Encryption in VFP 9.0

  Hi, I need to be able to decrypt data pulled from a MySQL table encrypted with RSA public/private key encryption within a FoxPro application.  I am currently using the FoxPro Foundation Class known as _cryptapi as a wrapper to the CryptoAPI interface.  The problem I'm having is that I can't seem to figure out how to decrypt a RSA encrypted string of data.  I know that the _cryptapi class provided by Microsoft uses the Microsoft Base Cryptographic Service Provider which in itself uses RSA public key encryption algorithms, but for some reason I am having the hardest time finding the methods that support this in the _cryptapi fo ...Show All

• SQL Server move report server to new machine

  Can someone tell me how I can move report server web sites into a new machine without reinstall it I like to keep the current report server database intact, it’s residing on a third server. I copied the report server file folders including bin (dlls) into the new machine and set up in the new machine the Reportserver and Reports web sites pointing to these two folders while keeping the report server database still residing on the third machine, but the new site did not work, I got "Event source Report Server does not exist. (rsEventLogSourceNotFound)" error Any advice will be greatly appreciated. Thanks ...Show All

• SQL Server can't modify stored proc which is in a publication

  Hi SQL 2005 sp1 - merge replication - HTTPS. We have 2 publications for the database - one which has subscription.SyncType = SubscriptionSyncType.Automatic and another with SyncType = SubscriptionSyncType.None. The first publication is there so we can add new stored procs etc, the second contains the initial schema and the data. When we try to modify a proc which is in the publication with SyncType = Automatic, the query never returns. This is most urgent - thanks for your help. Bruce There are 2 subscriptions - one for each publication - but the proc is only in one publication ...Show All

• Windows Forms Adding Designer Verbs to a Windows Form

  Anyone know of a way to add designer verbs to a windows form Thanks  Read about designer verbs in this article: <a href="http://msdn.microsoft.com/library/default.asp url=/library/en-us/dndotnet/html/custdsgnrdotnet.asp">http://msdn.microsoft.com/library/default.asp url=/library/en-us/dndotnet/html/custdsgnrdotnet.asp</a> ...Show All

• Windows Forms Balloon tip

  A built-in control to display balloon tips on a given control (currently I'm using 3rd party libraries and self-written components to do this via a Platform SDK invocation). Check out this ToolTipExt - http://component.cheapcard.com.au ...Show All

• SQL Server Service problems after SP1 upgrade

  We have an instance of SQL 2005 enterprise that was upgraded to SP1 over the past weekend. This instance has been very stable and the server hardly ever has any issues. After upgrading to SP1 a couple times a day SQL service has been terminating unexpectedly. The following events are being logged - Application Log: Event ID 17311 SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To re ...Show All

• Visual Basic problem with arraylist Is this a bug?

  Hi all is the following a bug or something i misunderstood PopulateList1 the array list will take on the last value updated   PopulateList2 worked but is this the correct way   Note the location of " Dim TempData As New Data" with the two sub   please advice   Public Class Form1 Private ArrayList1 As New ArrayList() Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click textbox1.text = "" TextBox1.AppendText( "PopulateList1" + vbNewLine) PopulateList1() ArrayList1.Clear() TextBox1.Ap ...Show All

• Visual Studio Express Editions pchnotify.exe error

  This is my errors poping up!. 1. first error: Just-In-Time Debugging An exception 'System.TypeInitializationException' has occured in pchnotify.exe. However, no debuggers are registered that can dubug this exception. Unable to JIT debug. 2. second error: JIT Debugging JIT Debugging failed with the following error: Odefinierat fel "undefined error" Please check the documentation topic 'Just-in-time debugging errors' for more information. This error's started after i installed 'Visual Studio 2005 C# express', i allready had an version of 2003 installed. When i for the first time started the new version i was ...Show All

• SQL Server how to write an mdx subquery

  i want to write a subquery using mdx. in sql that would be something like CREATE PROCEDURE sp_proc @param1 varchar(55) as Select id,name  from table1 where id in( SELECT distinct  id FROM         table2 where field='param1' ) GO   please let me know how to implement this functionality using mdx queries. This is only supported in AS 2005, but it is similar in concept to SQL SELECT ... FROM ( SELECT ... ) Regards Darren Gosbell http://geekswithblogs.net/darrengosbell ...Show All

• Visual Studio Team System Source Control Not Displaying in VS Team 2005

  We have been using VS 2005 Team Edition Beta 2 and Team Foundation Server Beta 2 for several months with only minor erratic issues, but today when you attempt to view the source control screen for any of the projects from within studio, no response at all is received and no files are displayed.  Developers were posting changes up to close of business yesterday but today no one can access the source control system.  The only thing I can see that may be an issue is that the URL is not populated in the properties of source control for any of the projects, but honestly do not remember what was there. Any and all suggestions are greatl ...Show All