Tag Archives: crystal report

How to restrict the text based on date condition by using the cdate() function in Crystal report

Crystal report is an application used to create custom reports from a various of data sources. It includes major features such as formulas, cross-tab reports, sub-reports , special fields and conditional formatting etc. In Sage X3 recently we had an requirement that one of our client wants the hardcoded declaration based on supplier type and… Read More »

How to limit the number of rows to be printed in a page in Crystal report

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop own custom reports as per client requirement.Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a… Read More »

PREVIOUS() function in Crystal Reports

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop new customized crystal report as per the client’s need. For one of our client we have developed a report that contains all the information related to Work Orders (report is printing in… Read More »

How to conditionally format fields using the Highlighting Expert in Crystal Report

In the Sage X3, we have various standard reports for almost every screen which are developed in Crystal Report. Also we can develop customized reports as per client‘s need. Crystal Reports is a popular Windows-based report writer solution that allows a developer to create reports and dashboards from a variety of data sources with a… Read More »

Dynamic Row-Column structure report for Quote comparison

In Sage X3, one of the client’s requirements was to have a comparison report for Quotes made by the suppliers for the given RFQ products. This report needed to have a dynamic nature of rows-columns design for which we’ve implemented the use of cross-tab option in Crystal report. New Stuff: Weigh Bridge Integration in Sage… Read More »

How to Repeat Group Header on Each Page in Crystal Reports

In Sage X3, we developed one custom report for our client where the detail section continues to the next page of the report but the heading/captions did not get printed on each page as captions were placed on the group header section (please refer to screenshot below). One would think that placing the captions in… Read More »

Special Fields in Crystal Report prints in different language

In the Sage X3, you have various standard reports for almost every screen which are developed in Crystal Report. Also you can develop your own crystal report as per client need. After printing report, the content in the report gets printed depending on the language setup done in the Sage X3 for the login user.… Read More »

How to print a field once which is repeating in Sage X3 report

In Sage X3, developer has freedom to develop their own reports in Crystal reports as per their client requirement. So we have also developed one of the report in India pack report called as Vendor transaction/Ledger report. This report display all the vendor transactions for selected parameter range. In this report, there is section where… Read More »