Neeraj Pandey's Q&A profile

• SQL Server Exporting into Excel - Cell Format Problem

  From a newbie Reporting Services user: when my users export their reports into Excel the cell format is always "Customised" so they can't manipulate the data, use Macro`s, formulas etc. How can we get the data to export so the cell format is the same as the format I have set Properties Many thanks. ...Show All

• .NET Development Viewing SOAP packet sent to a vendor's Web Service

  We are calling a vendor's web service and under normal circumstances it works without a problem. If our requests are large then the service fails. The vendor would like us to send them a text file containing the actual soap packet we are passing in. Since VB handles all of the soap envelope assembly how can we capture the actual soap packet being passed Any help would be appreciated... Thanks I don't know what are you using on your client side, if you are using WSE you can enable tracing in the config file. <microsoft.web.services3> <diagnostics> <trace enabled="fals ...Show All

• Visual Studio Express Editions Visual Studio express C++ forms controm template

    Hello, I'm trying to make a new forms control project but the template is missing in the new project screen. Maybe it's normal but I don't know, so I'm looking for an answer. If it should work what should I do to recover this problem Thank you in advance. Bye. I have the same problem with Visual C++ 2005 express. Can anyone tell me where to find this template ...Show All

• Visual C++ Incremental linking

  Our solution contains 8 projects - one MFC exe, one DLL, and six static libraries. We are using VC++ 2003. To do a full link on the executable is very slow - as much as 10 minutes. We believe this is the fault of some third-party libraries we are linking to, but right now we don't have an alternative to using them. Incremental links, by contrast, take less than two minutes. This ought to largely take care of the issue, but it doesn't. If just one file in any of the libraries changes, the exe seems to always require a full link. Static or dynamic library does not seem to make a difference. Why is this Has it been fixed in VC++ 2005 ...Show All

• SQL Server Matrix reports & MDX Hierarchies

  Does anyone know how to properly us MDX hierarchies within the matrix object of RS. This object seems to supress any rows (at run time) that have null values in any of the fields, even if your report is only referencing fields with values. For example: a) Create a hierarchy in AS, using 2 or more characters on some dimension. b) In a report create a Member expression (i.e. AxisName) to reference the caption via the Axis. c) Use that hierarchy (i.e. via AxisName) in a matrix control (with some measures). Only the lowest level items will display when you preview the report (even though there's data and you've used AxisName). With the June ...Show All

• Visual Studio Remote access timeouts in VSS 2005

  Hi, I'm setting up a VSS2005 database. It is accessible with http. For small projects it seems to work fine, but when we try to add or open a larger project, the webservice is throwing errors, wich state it are timeouts. I'm looking for a solution to this problem, or a setting to make the webservice timout a higher value. I hope someone here can help me with that! thx in advance. Ivo Ivo, You can increase the default timeout of the web service by editing the web.config file in %program files%\Microsoft Visual SourceSafe\VSSWebService\bin. You need to add a line like that <httpRuntime executionTimeout= ...Show All

• Visual C# P2P Protocols

  I have been making some research for an upcoming project of mine (LAN Messenger) and I cannot find any library which support any kind of known protocols .. I already seen JXTA which sounds like a really suitble for my project buy I didnt find any .Net implementations .. Suggestion for another protocol which has an implementation will be welcomed :) Thank you, Shimi. thoughtpost component looks nice but Im having a trouble running it could it be because of using the new 2.0 framework to compile it with express 2005 ...Show All

• SQL Server How can I make a Matrix Transposition in SQL ?

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL 1 2 3 4 5 6 7 8 9 changes to 1 4 7 2 5 8 3 6 9 how about the situation when no of rows <> no of column let's consider the no of rows it's fixed and known before running the SQL statement. thanks. What do you mean standard SQL   Here is a 2005 version that will rotate your data (it is not as elegant without CTE's, UNPIVOT and PIVOT, but it can be done if you need it: The basic idea used was to add a key for the rotate, and then do an UNPIVOT followed by a PIVOT:   set nocount on create ...Show All

• Visual Studio Team System Lock Binary Files on Checkout

  Is there a way to force a check-out lock on binary files when they are checked out Since you cannot merge these files, wouldn't it make sense to automatically lock them on checkout Seems like disastrous consequences are looming without this capability since someone will check their changes in over a previous checkin changes. Thanks. Lots of common binary files are set to non-mergeable (exclusive lock) by default. You can customize which file extensions are mergeable via Team -> TFS Settings -> Source Control File Types. ...Show All

• Visual C# Buttons Backcolor in C# 2.0

  I recently started using C# 2.0 and put a button on a form, left the flatstyle as standard, then changed the backcolor. The button now has a square with the color I chose over the top of the button and the outline of the button still showing the standard style. Is there anyway to change the backcolor of the button in standard flatstyle without having a big colored square over the top of it Thanks in advanced Shane Hi! Button have UseVisualStyleBackColor property. If it's true - then back color rendered by Windows XP Themes API and your back color won't be seen. Try turn this property of ...Show All

• Windows Forms deployment of a .NET application

  Hi, I'm wandering which strategy to use to deploy an application to my users. The problem is that the application is only partially finished and many new version will have to follow. I know there is something called 'Dynamic update' which automatically pulls new versions of an application but I have no clue how to implement it. Suggestions, examples will be greatly&n ...Show All

• .NET Development Insert/Select Pic/Clip from MSSQL2K DB

  Insert/Select Pic/Clip from MSSQL2K DB Hello, Can n e 1 show me the code of inserting/selecting the pics/movie clips from the SQL 2000 database from "IMAGE" datatype column set to the particular table Pics need to display in the web brower one below the othere and movie clips need to be played in the windows media player browser plug-in. taan ku phor your time. with regards, Beau Peep The Hospital (Bed Pans II - Sponge Bath Revange) Use binary type data for the image field in the table. When u upload the picture read the file in binary mode and store the binary data. When u retrive read the binary data back from the database ...Show All

• Visual C# Helper ... what is it?

  Sometimes i hear developer say i will make a helper .... what is a helper exactly Thanks, a helper is just a class or a method that is seperate from what you are working on that is designed to do one task that you need done. Sometimes a function will simply be overloaded and the more complicated overload will be private inside the class the public function will take the parameter and figure out the correct parameters for the more complicated function (perhaps a searching algorithm) then pass it to that "helper function" to do the search. Or maybe you have some extra class that handles parsin ...Show All

• SQL Server Cannot add a Dimension in Analysis Server 2005

  Installed MS SQL Server 2005 with Analysis server. Installed both the services and components. Was able to migrate the database from 2000 to 2005. I can process existing diminsions. But, I do not have the option to add a new dimension or edited existing dimensions. Did I miss something during installation Yes. You might be missing a bit of information here. Analysis Services 2005 has bit different concept. You no longer have single tool for managing and desining cubes, you have 2 different toolsets. SQL Management Studio is used for Analysis Server administration. BI Dev Studio is development envioron ...Show All

• Visual C# Windows Services - Is there any code that cannot run in a service?

  At startup, I need to check the status of a variable on my systems. First I tried using task scheduler to launch the code at boot, but it didn't work, so I am now looking into just writing a windows service. The idea is, I launch a dos based utility to check the stauts of the variable (I cannot check it directly it is proprietary), storing the status in a registry key. After the utility completes, I read the key. If the status is correct, I want to check the time. If the time is within a certain timeframe, it should launch a seperate program. The service seems to start ok, but as soon as it goes to check the time, it stops working. Code ...Show All