Monthly Archives: August 2012

Crystal report formula field Tutorial

You can use formula field in Crystal report for a custom field, for example You want to find total sales based Qauntity and units sold You want to multiply, add two numbers You want to add number of days to … Continue reading

Posted in Uncategorized | Leave a comment

Equivalent font sizes of H1 H2 H3 H4 H5

Wondered what is the equivalent size of html header tags H1, H2, H3, H4 and H5? I rendered an XSLT containing these 5 heading into a word document, the following was the result   [table] Header,Font Size (pt),Font Weight H1,24,Bold … Continue reading

Posted in Uncategorized | Leave a comment

Database Vendor code: 229 – Crystal Report

If you get the below error in Crystal Report Failed to retrieve data from the database. Details: [Database Vendor Code: 229] This mean you do not have access to the data. This possibly occurred because you created your report on … Continue reading

Posted in Troubeleshoot | 4 Comments

SQL function says command completed successfully

I got the above error when I was trying to return a value from my sql function (scalar) and it would instead say, Command(s) completed successfully. without actually returning the value. So I investigated Scalar SQL Functions Scalar SQL function … Continue reading

Posted in Uncategorized | Leave a comment

Western Union vs MoneyGram Cost Comparison

Use this calculator to Compare western union rate vs MoneyGram. Usage Notes: Note that Western Union (WU) and MoneyGram(MG) dollar conversion rate changes on daily basis. There service fee also changes and is usually different state by state. You must … Continue reading

Posted in Utilities | Tagged , , , | Leave a comment

How to write complex SQL Query or Report

There will be times when you will be asked to write a complex report that involves more than 3 tables, has obscure fields that do not know where they are in the database. You will posed with the problem of … Continue reading

Posted in Uncategorized | 1 Comment

ASP.NET Weird Error

The following error in thrown in my asp.net web application (folder based) Keyword not supported: ‘id’. Guess where could be the problem? When I look at the compilation error warning CS0109: The member ‘Employees.id’ does not hide an inherited member. … Continue reading

Posted in Uncategorized | Leave a comment