I am currently trying to develop a simple customer invoice that can be batch e-mailed nightly on Crystal Reports. I seem to be running into many problems. Does anyone have an easier solution for what I am trying to accomplish or any advice would be appreciated.
hi King,
The versi> I am currently trying to develop a simple customer invoice that can be batch
Yes King, Once you develop the report you need to develop one file in same directory of crystal report in notepad with extention of .def so if your report file name is myreport.rpt then def file would be myreport.def. Now what this file contain see below:
Crystal Reports New Crystal Reports can be created for Microsoft® Business Solutions Retail Management System. Although Retail Management System ships with a runtime license for Crystal Reports, the Crystal Reports program needs to be purchased to create or edit new Crystal Reports.
The Crystal Reports files included in Retail Management System are located in the Crystal Reports folder where the product is installed (C:\program files\microsoft\retail management system\store operations\CrystalReports).
Crystal Reports Rules Follow the rules below to produce Crystal Reports for Retail Management System.
The DEF filename must match the RPT filename. For example, Customer.def must be used to generate Customer.rpt.
The DEF file and RPT file must be stored in the folder dedicated for Crystal Reports. This folder is defined in Retail Management System Administrator and is stored in the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Retail Management System\Store Operations\Manager\Paths\Crystal Reports subkey.
Retail Management System v1.2 distributes Crystal Reports v8.5. Ensure that the new Crystal Reports are compatible with these versions.
An OLE database SQL connection to the Retail Management System database must be used.
A formula field for ReportDate must be included in the report.
Note: This can be blank at design time since the application passes data to this field at runtime.
In the Crystal Report definition files, use the variables listed in the following table.
Variable Description Filename The report filename. Description The description that appears on the report window. GroupCount The number of group sections in the report, not including the detail section. StartGroup Indicates the first group section for sorting purposes. TableCount Number of tables used in the report. VisibleSectionName Include one for each section displayed on the report. GH1 indicates the header section for group 1, GF1 indicates the footer section for group 1, and DETAIL indicates the detail section. Field Defines the fields that can be sorted or used in the selection criteria. They are defined as follows: Field = {description}, {field name}, {type}, {level}, {criteria}, {G.T. #}. Description The information used to identify the field in the user interface and the field in the database. Type Indicates the type of data in the field: 0 = string; 1 = numeric; 2 = date,
3 = Boolean. Level The sort level in which the field appears. For example, 1 means this field can be sorted at sort level 1. Use 0 if this field is not to be sorted. Criteria Indicates if this field is used in the selection criteria. Use 1 for yes, 0 for no. G.T. For future use."knightsbridge" wrote:
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.