How to format database fields in a report created with Forena? How can I choose how to display the fields from the database returned by the data block (using the Forena module)? Such as a field just returns a number, but each number of that field represents something else that I'd like to display. For example:

 if (id=5) { $text = "see website"; } else { $text = "free"; }


If this is not possible, how in general can I change how the fields are displayed?
When you're &quot;developing&quot; a report (= Specifying the various report options), you have a choice to do so using either of the following features:

Use the WYSIWYG Report Writer, something novice Forena users typically do, or end users that are granted permissions to &quot;develop&quot; their own reports (and which get saved in Forena's typical '.frx' files).
In this case, you should look at Fields (within the WYSIWYG tutorial), located also at /reports/help.reportingwysiwyg#fields in your own site.

&quot;Code&quot; your own reports in the XHTML language used in Forena (saved in '.frx' files), which is called &quot;FRX Report Writing&quot;. This is what the real power users will want to do, since it gives them the full XHTML power to build any report.
In this case, you should look at Fields (within the FRX tutorial), located at /reports/help.reportingwysiwyg#fields in your own site.


Be prepared: there are quite some options to pick from ...