Putting a Conditional Sub-report on a Letter
/documentation/pages/Guides/Desktop/Design/View/Letter/Putting a Conditional Sub-report on a Letter.xml
The following example shows how to put a sub-report, which containing variable content, on a letter only when specific conditions are met. The first step is to define the sub-report, which in this case is named "foursomes". This sub-report displays the data from the table FOURSOMES, which is sorted by the foursome field. The result is the firstname and lastname fields from the records that have the same foursome value.
Manually Inserting UX Component Data into a DBF Using Xbasic
/documentation/pages/HowTo/UX/Saving Dialog Contents to a DBF.xml
In this example we will save some UX Component contents to a DBF database record. First we will need to create a DBF table to store the data. Create a new DBF table in the control panel and add the following fields:
How to Display a QR Code in a Report
/documentation/pages/HowTo/Reports/Display QR Code in Reports.xml
You can generate and display QR codes in reports using a variety of methods.
Importing a Layout as a Starting Point for a New Report
/documentation/pages/Guides/Report/Getting Started/Importing a Layout as a Starting Point..xml
If you have already created a form or browse, you can use it to create a report. The following example creates a report from the CustomerBrowse browse in the AlphaSports sample database.
Run a report that is embedded in a UX component using a custom filter for the report
/documentation/pages/Ref/Action Javascript/Run a report that is embedded in a UXcomponent using a custom filter for the report.xml
Create a highly customized 'Search Part' for a Report. Allows you to submit a UX component that contains 'search' fields to compute a filter expression and then run the report using the computed filter expression.
Grid Component - Opening a UX from a Button on a Grid and Passing Information Into the UX
/documentation/pages/Server/Guide/Design/View/Grid/Opening a UX from a Button on a Grid and Passing Information Into the UX.xml
You can open a UX component from a button on a Grid using several different actions in Action Javascript. For example, there are built-in actions to edit the data in the current row of a Grid using a UX.
Clear a Search a Grid Component that is Embedded into a UX component
/documentation/pages/Ref/Action Javascript/Clear a Search a Grid Component that is Embedded into a UX component.xml
For use in conjunction with the 'Search a Grid Component that is Embedded into a UX' action. Clears the search form in the UX and removes the filter from the embedded Grid.
Creating a Script to Print a Report for a Selected Record
/documentation/pages/Desktop/Tutorial/Design/View/Database/Creating a Script to Print a Report for a Selected Record.xml
In this example, you will create a script that prints out a mailing label for a particular customer. The script will prompt the user for the customer's name. This script will be a Global Script. as you will recall, a Global Script appears in the Control Panel in the Code tab, and can be run by double-clicking the script name, or clicking the Run button.
Search a Grid Component that is Embedded into a UX component
/documentation/pages/Ref/Action Javascript/Search a Grid Component that is Embedded into a UX component.xml
Create a highly customized 'Search Part' for a Grid. Allows you to submit a UX component that contains 'search' fields to compute a filter expression and then filter a Grid component that has been embedded into the UX component.
How To Print a Report Containing the Currently Selected Records
/documentation/pages/HowTo/Reports/Print a Report Showing Currently Selected Records with Action Javascript.xml
With Action Javascript, it is easy to put a button on a Grid that prints a report. You can easily link the report to data in the current Grid row. For example, if the value of the State field in the current grid row is 'MA', you can easily define a filter for the report that shows all states with a value of 'MA'.