sQL cookbook

Datetime cookbook

if else in sql

Crystal report 101

Sample 1

CR for MVC


display image

without this line in web.config you're dead.
add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"/>

make sure the above line also appear on
system.webServersection

painful 2
Connection, make sure you use the same servername for development and product and use host file to map them to the correct ip on production server

Google mail setup

1.Sign up as reseller program using reseller.yourcompany.com as the domain account, you need DUNS
number during the registration.

Reseller program will not be able to see Customer PIN under [Support]

Go to add customer page and provide Customer PIN and domain info

2.Sign up for yourcompany.com, provide Customer PIN and domain to reseller.
http://reseller.googleapps.com/add-customer

Both above need verification on account.


After setup, you need to configure email MX setting under [Setup]. Make sure it is setup.

Crystal Report

Crystal report  for vs 2010

All you need from here

Redist is for production server

Complete Package is for your visual studio 2010

Basic sample

process xlsx

you need to use this

and the below connection string

Provider=Microsoft.ACE.OLEDB.12.0; Data Source=  PATH ; Extended Properties=Excel 12.0;