‘Crystal Reports Deployment’ Archives
Alternate Color shading in Cross Tab Crystal Reports for more legible reports
Alternate Color shading in Cross Tab Crystal Reports for more Readable formatting To complete the formatting: - uncheck the "Show Cell Margins" option. - select the field then go Format field Select Border tab and then go to back ground and in the formula option enter the following formula you can select different colors try to change [...]
Use of Array function in Crystal Reports for producing comma delimited list of related orders
This example will demonstrate the very practical use of Array function in Crystal Reports. A client wants see the customer orders list in the comma delimited format in crystal report view used in a custom application. Customer name and related orders are stored in 2 different tables. Please figure 1 below report can be created by placing [...]
ToWords is resulting in as one hundred twenty three and 10 / 100
The subject query was posted by one of our visitor and he wants to write as $123 and 10 cents. Following is the solution to that; local stringvar isNumber := cstr({SalesOrderDetail.UnitPrice}); local numbervar iswhole := ToNumber ({SalesOrderDetail.UnitPrice}); local numbervar ispos := instrrev(isNumber, ‘.’); local numbervar isdecimal [...]
Writing Indian Ruppees and Crore using towords
This formula has been contributed by one of our valued visitor in response to querie posed by other users of Crystal Report numbervar RmVal:=0; numbervar Amt:=0; numbervar pAmt:=0; stringvar InWords :="Rupees "; Amt := tonumber({@Amount}); if Amt = 10000000 then RmVal := truncate(Amt/10000000); if Amt = 10000000 then RmVal := 1; if RmVal [...]
The waterfall method in report development
This is critical requirement for report development and extensive questions may be asked during interview process for Crystal report jobs. Undoutedly all reporting anaylst/developer do follow steps, we including this post in datamart.org for formal way stating, with reference backed by CRCP Crystal Reports Certified Specialist exam guide by Harper [...]
Crystal Reports Runtime Packages
If you are developing an application using one of the Crystal Reports SDKs for Visual Studio, you need to deploy the Crystal Reports Runtime on each computer where your application is expected to run. In order to help you easily deploy the runtime on any computer running your application, Business Objects provides a set of runtime packages, i.e. [...]
