Tag Archives: crystal report

Crystal report with oracle query in sage X3

In Sage X3, there are various modules, each equipped with standard reports for almost every screen, and these reports are developed using Crystal Reports. Additionally, we have the capability to create customized reports to meet specific client needs, especially in the context of Indian legislation. For these specialized reports, we utilize SQL as the data… Read More »

How to print dynamic Company Logo on Sage X3 Reports

Crystal report is a business intelligence application used to design and generate reports from a wide range of data source. It supports connectivity to various data sources such as Microsoft excel, SQL server, Oracle and more. It includes major features such as formulas, cross-tab reports, sub-reports, and conditional formatting etc. In crystal report sub-reports are… Read More »

Crystal Reports: Time cut off from date-time field

Crystal Reports is a business intelligence tool that creates custom reports by capturing data from multiple sources. The tool offers features such as data access, report design, data formatting, report viewing, and application integration. In Sage X3, we have various standard reports for almost every screen, which are developed in Crystal Reports.Recently, we had a… Read More »

How to show comma-separated value for single or multiple fields in Sage X3 reports using crystal report

Crystal report is a business intelligence application used to design and generate reports from a wide range of data source. It supports connectivity to various data sources such as Microsoft excel, SQL server, Oracle and more. It includes major features such as formulas, cross-tab reports, sub-reports, and conditional formatting etc. In crystal report sub-reports are… Read More »

How to include portrait and landscape sub-reports in single report in Crystal Report

Crystal Report, a powerful reporting tool allows users to create both portrait and landscape report. It provides the flexibility to design and customize reports based on the specific needs of the data being presented. Portrait Reports – In a portrait oriented report, the height of the page is greater than its width. Portrait reports are… Read More »

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 »