AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Morphx logo12/8/2022 On the Properties sheet of the new data source, set the Table property to Employee and set the Name property to Employee. In the AOT, expand the Reports node, expand the EmployeeReport node, expand the Data Sources node, expand the Query node, right-click the nested Data Sources node, and then click New Data Source. To join the Employee table with the Department table in the report For more information, see How to: Add Multiple Data Sources to a Query. In this case, the DeptId field is the primary key of the Department table and is a foreign key of the Employee table. For more information, see How to: Override the fetch Method to Filter Data for Reports (MorphX Reporting Tools).įirst you must specify the data sources to use in the query and the relationship between the two data sources (tables). Use the Query system classes to create a query. Under the EmployeeReport node, right-click Methods, point to Override Method, and then click Fetch. You can also create a query by using X++ (see How to: Create Queries by Using X++). Now you can populate the tables with data that will be displayed in the report. On the Properties sheet of the new field, set the Name property to Location and set the StringSize property to 25. On the Properties sheet of the new field, set the Name property to DeptName and set the StringSize property to 25. In the AOT, expand the Department node, right-click Fields, point to New, and then click String. On the Properties sheet of the new table, set the Name property to Department. To create another table to use as a data source for the report In this procedure you create a second table that will be used as a data source for the report. On the Properties sheet of the new field, set the Name property to DeptId. On the Properties sheet of the new field, set the Name property to LastName and set the StringSize property to 25. On the Properties sheet of the new field, set the Name property to FirstName. In the AOT, expand the Employee node in the AOT, right-click Fields, point to New, and then click String. On the Properties sheet of the new field, set the Name property to EmpId. In the AOT, expand the Employee node, right-click Fields, point to New, and then click String. On the Properties sheet of the new table, set the Name property to Employee. Right-click the new table and then click Properties. In the AOT, expand Data Dictionary, right-click Tables, and then click New Table. To create a table to use as a data source for the report For more information, see How to: Create Tables. In this procedure you create a table to use as a data source for the report. Creating Tables to Use as the Data Sources for the Report No association with any real company, organization, product, domain name, email address, logo, person, places, or events is intended or should be inferred. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious.
0 Comments
Read More
Leave a Reply. |