(Adnan Masood) Reporting Services exposes web methods via XML web services to facilitate cross platform reports management and delivery. It’s a simple SOAP based API makes it very easy to add full functionality of reporting services in your application. It provides a set of rendering and viewing

(Mike Chapple) Inner joins (also known as equijoins) are used to contain information from a combination of two or more tables. The join condition determines which records are paired together and is specified in the WHERE clause. For example, let’s create a list of driver/vehicle match-ups where bo

(Dinesh Asanka) Up to now we have discussed Basics of InfoPath 2003 and How to view data from InfoPath 2003 from the previous articles. Now it’s time to discuss the basics of saving data from InfoPath 2003. (R)

(Tibor Karaszi) Encountering a suspect database or corruption in a database is a rare thing. It can happen, however, most often due to faulty hardware or operational mistakes (like deleting a transaction log file).

(Andrew Novick) As we headed into Maynard to join some of our friends for an evening at a club listening to overly loud music, my wife, Ulli, suggested that we should go with some of these same friends and their kids to one of the local Chinese restaurants that has a buffet. My reply was that I don

(Allan Mitchell) When building our own custom pipeline components two methods in particular are very important and it may become a little confusing as to which one is used in which situation. The two methods are: –ProcessInput –PrimeOutput

You can use Kerberos authentication with Microsoft SQL Server 2000. SQL Server 2000 supports this functionality as part of a typical Microsoft Windows 2000 Active Directory domain installation. With Microsoft Windows 2000 Service Pack 3 (SP3), you can enable Kerberos authentication on server cluster

(Stephen Lasham) I recently received correspondence from Denis Oliynik, IT manager at JSC ‘Rise’, Kiev in the Ukraine, who kindly provided me with a script improving on my previously published solution. Denis’s solution removes the CASE statement for handling where a second delimiting character is

(Bruce Johnson) While the use of AutoNumber and Identity fields in tables is greatly applauded by database designers the world over, they can be annoying for developers to use. The problem being that, when we add records to the database, there are many cases where we need to know the key of the reco

(Adnan Masood) Not all reports are static, most of the enterprise reports are data driven or parameterized. In the following section I’m adding two variables, startdate and enddate in the Orders Report. These arguments will be used to filter the data being queried from orders table.