Report Best Practice with calculated values

Hi guys,
I have no problem generating a report from a MySQL query o table using frxDBDataset.
The problems begins when I want to add a variable in the report in each row.

For example, table "PRODUCTS" ID|PRODUCT|SHELF-LIFE

What's the best practice if I want to generate a report that shows me

ID | PRODUCT| EXPIRE-DAY

Where: EXPIRE-DAY = TODAY + SHELF-LIFE

Thanks in advance for your help, even a link would be greatly appreciate.

PS: I come from PHP, where you simply load your query results in an array and you print row by row in a table or in a pdf file, printing row by row and cell by cell let you add every variable you need.
Is there anything similar?

Thank you in advance.

Michael

Comments

  • gpigpi
    edited 8:37PM
    You may use FR's internal function DATE to get current date: [Date + <YourDatasetName."SHELF-LIFE">]

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.