Monthly Archives: November 2014

WordPress Redirect Test

This page should redirect to google [redirect]

Posted in Uncategorized | Leave a comment

How to Enable Save as Excel in Stimulsoft

In ReporViewer.aspx, set ShowExportToExcel2007=”True” Now when you generate the report, and the dialog is presented, you will have an option to save the report to Excel.

Posted in Tutorials/Tips | Tagged , | Leave a comment

RAISERROR and Exceptions

RAISERROR with severity level below 10 are not catched by ADO framework. To fix it simply raise severity level to 10 or above or you can instead use THROW statement which has severity level of 16 by default and will … Continue reading

Posted in Tutorials/Tips | Tagged , , | Leave a comment

Be careful with CASE and NULL statement

Checking NULL values in database can be a little tricky. It is very easy to trickle those if you do not provide correct syntax. The recommend way to check null is ISNULL(myfieldname,”). When using NULL in case statement, it might … Continue reading

Posted in Tutorials/Tips | Tagged , , | Leave a comment

How to create dates reference table in SQL

I needed to create date reerences as needed in my sql report. I stumbled upon this link which create dates in sql on the fly but there was a typo because of which my function did not run. The following … Continue reading

Posted in Uncategorized | Leave a comment