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

Writing Complex SQL Queries

I have had a chance to work with some complex SQL Query in different reports, I will highlight the skillset that you will need writing such a report. First Thing When writing a report the field names might not be … Continue reading

Posted in Uncategorized | Leave a comment

Fieldnames Abbreviations in Database

The following shortcut codes are used in some database to shorten field names. Underscore characters are used along these shortcut codes to separate different words. [table] Abbreviation, meaning NM, Name DT, Date CD, Code COMM, Commission TX, Text field CALC, … Continue reading

Posted in Uncategorized | Leave a comment

Western Union vs Moneygram

There are two popular ways of sending money within United States or across different countries. Western Union MoneyGram Western Union vs MoneyGram Comparison Calculator Western Union Wester Union is the most popular one. They have more agents thoughout united States. … Continue reading

Posted in Utilities | 2 Comments