Monthly Archives: May 2012

No connection could be made because the target machine actively refused it 127.0.0.1:25

Error: No connection could be made because the target machine actively refused it 127.0.0.1:25 Plateform: ASP.NET Problem: You are trying to send mail from an ASP.NET application and you are getting this error. Solution: Go into web.config file and remove … Continue reading

Posted in Uncategorized | Leave a comment

Getting Started with Excel VBA

Quick start with Excel VBA Excel VBA is same as classic Visual basic 6. Think of it as Visual Basic optimized for Excel Every VBA are also called Macros inside Excel You can program inside every excel sheet. Infact you … Continue reading

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

Export to Excel does not export headers – Nexant

It can happen in Nexant Revenue manager, if you export a crystal report in Excel Data only, the report headers are not exported. This could be because in Crystal Report the headers and data was not place close togather. Solution: … Continue reading

Posted in Troubeleshoot | Tagged , , | Leave a comment

Setting Parameter Order in Crystal Report

Right click on Parameter Fields in the fields explorer. Select “Set parameter order”.

Posted in Uncategorized | Leave a comment

Display Ampersand character in XSLT

XSLT does not compile if you put & character in it. To display an & (ampersand) character, the following code worked for me & Simply replace & by & #38 in your XSLT. In my exact case, I was generating … Continue reading

Posted in Uncategorized | Leave a comment

Font-Family inherit does not work in XSLT

According to w3schools CSS propery Font-Family is inherited by default. … this element does not get the fonts from body tag This is true for HTML document but be aware it is not true for XSLT generated document. If the … Continue reading

Posted in Uncategorized | Leave a comment

Alignment and formatting in Crystal Report

When writing big crystal report alignment and formatting can be a pain esp if you are changing every field individually. Luckly formatting and alignment is available that you can apply to mutlipe objects at the same time.   Alignment You … Continue reading

Posted in Tutorials/Tips | 3 Comments