Monthly Archives: August 2012

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 →

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 →

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 →

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 →

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 →

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 →

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 →