Unable to add data connection. The DataConnectionDialog could not be initialized. - Resoved

When you try to add data connection (MS SQL Server) through the server explorer, sometimes you get the following error.

In order to resolve this you need to do a change in the windows registry.
Close visual studio IDE and open the registry editor and navigate to 'HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0' and change it to 'HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0Bak' (What ever you want).

Restart visual studio IDE.

The type initializer for 'crystaldecisions.crystalreports.engine.reportdocument' threw an exception - Resolved

Today I got this error, when I tried to deploy an application developed using Visual Studio 2005 and Crystal Reports 10.

I googled the problem and found out many solutions which worked for many people. But only one solution worked for me. Anyway I will post all the things that I have tried.

Solution #1

Run ‘CRRedist2005_x86.msi’. This file can be found on ‘C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports’. And if you have already installed this you will be prompted to Repair or Uninstall. But none is required if it’s already installed.

Solution #2

Uninstall the Crystal Reports for Visual Studio 2005 using the Visual Studio Instalation DVD and Reinstall it again.

Steps to uninstall the Crystal Reports for Visual Studio 2005

1. Insert the Setup DVD


2. Select ‘Change or Remove Visual Studio 2005’ (Then the setup will run on Maintenance Mode)


3. Select ‘Add or Remove Features’


4. Uncheck the ‘Crystal Reports For Visual Studio’ checkbox


5. Click on ‘Update’ button


6. Afterwards do the above steps and on step 4 select the ‘Crystal Reports For Visual Studio’ checkbox and click on ‘Update’ button

Solution #3

Create a setup using the Crystal Reports Merge Module, It can be downloaded from http://support.businessobjects.com/downloads/merge_modules.asp. And run it on the deployment machine

Solution #3 worked for me..

Hope this will be helpful to you …………

Get number of days in a month using SQL

Here is a sample to get the number of days in a month, for a given month and a year

declare @zMonth as varchar(2), @zYear as varchar(4)
set @zMonth = '02'
set @zYear = '2009'

select datediff(day,cast(('01-' + @zMonth + '-' + @zYear) as datetime),dateadd(day,-1,dateadd(month,1,cast(('01-' + @zMonth + '-' + @zYear) as datetime)))) + 1

**Please note: The date format of the machine that is running SQL should be 'dd/MM/yyyy'. Or please change the order in query prior using it. Or use the following Code. (Thanks to Rohan for pointing that out)

  

declare @zMonth as varchar(3), @zYear as varchar(4)
set @zMonth = 'Feb'
set @zYear = '2009'

select datediff(day,cast(('01-' + @zMonth + '-' + @zYear) as datetime),dateadd(day,-1,dateadd(month,1,cast(('01-' + @zMonth + '-' + @zYear) as datetime)))) + 1