Monthly Archives: August 2012

Crystal report formula field Tutorial

Posted on August 31, 2012 by

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

Posted on August 28, 2012 by

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

Posted on August 27, 2012 by

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

Posted on August 27, 2012 by

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

Posted on August 23, 2012 by

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

Posted on August 22, 2012 by

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

Posted on August 20, 2012 by

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