Overview
Problem
From Printing/Exporting the Checkbox Widget During Data Entry, you can learn that the configuration modification method only applies to the printing or exporting of checkbox widgets and checkbox button widgets.
However, during the creation of some reports or contracts, radio button group widgets may exist in cells. Only the selected values will be displayed by default during exporting/printing, while other options are not displayed.
In this case, how to print or export all values of radio button group widgets?
Solution
During exporting or printing, cell values will be affected by the display setting. You can set Data Dictionary for the cell under Cell Attribute > Display. To realize the effect, you can set different selected statuses of display values based on different options through the geometric symbols in the Microsoft input method.
Example
Report Design
Create a dataset named ds1, and retrieve five records of data through the SQL statement.
Create a general report, add radio button group widgets to cells B1 and B2, respectively, and design the table style, as shown in the following figure.
Select cells B1 and B2 separately, choose Widget Setting > Attribute > Advanced > Data Dictionary, set Type to Data Query, set Dataset to ds1, and set Actual Value and Display Value to Product_name, respectively. Keep Adaptation selected. (Adaptation is selected by default in Advanced.)
Method One: Setting the Display Mode Record by Record
Select cell B1, choose Cell Attribute > Display, select Data Dictionary, and set Type to Custom, as shown in the following figure.
The following table describes the setting of the actual and display values.
| Actual Value | Display Value |
|---|---|
Apple Juice | ●Apple Juice ○Milk ○Ketchup ○Salt ○Sesame Oil |
Milk | ○Apple Juice ●Milk ○Ketchup ○Salt ○Sesame Oil |
Ketchup | ○Apple Juice ○Milk ●Ketchup ○Salt ○Sesame Oil |
Salt | ○Apple Juice ○Milk ○Ketchup ●Salt ○Sesame Oil |
Sesame Oil | ○Apple Juice ○Milk ○Ketchup ○Salt ●Sesame Oil |
Among the above-mentioned display values, ● and ○ are two strings entered through the geometric symbols in the Microsoft input method. The following figure shows the input method.
Method Two: Setting the Display Mode Globally
Method one requires individual configuration for each option, which is inefficient for dealing with radio button groups containing numerous or dynamically changing options. In view of this, another global configuration method is introduced here. Formulas can be used for judgment and processing.
Select cell B2, choose Cell Attribute > Display, select Data Dictionary, and set Type to Formula Form, as shown in the following figure.
Set the formula to joinarray(MAPARRAY(value("ds1", 2), if(item = $$$, "●", "○") + item), " ").
The description of the formula is as follows:
value("ds1", 2): obtains all values of Product_name in the second column in dataset, and returns the values as an array.
MAPARRAY(value("ds1", "Product_name"), if(item = $$$, "●", "○") + item): iterates through the array and prepends ● to the currently selected value while prepending ○ to all other values.
joinarray(MAPARRAY(value("ds1", "Product_name"), if(item = $$$, "●", "○") + item), " "): converts the array to strings with spaces as separators.
Effect Preview
Save the report and click Data Entry Preview. The following figure shows the effect.
Click Print or Export. The following figure shows the effect. (You can select Excel, Word, PDF, or Image in Export to export the report in the corresponding format normally.)
Note:Method one: The Export or Print functions are unavailable when no value is selected in the radio button group widget.
Method two: The Export or Print functions are unavailable when no default value is set for the radio button group widget and the widget is not edited after preview.
Template Download
For details, you can download the template Printing and Exporting the Radio Button Group Widget.cpt.
Previous：Print and export check button widgets
