Sunday November 19th 2017

Categories

Insider

Archives

‘Crystal Reports Deployment’ Archives

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to categorize transnational data by phases if the information about phase is not stored in transactions table ?

How to aggregate transnational data by phases if the information about phase is not stored in transactions table. Recently I encountered a scenario where I have to aggregate the information about Account holders spending transnational history by different phases, let's say there were 3 phases in which these transactions were falling. Transaction [...]

Alternate Color shading in Cross Tab Crystal Reports for more legible reports

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

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

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

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

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

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. [...]