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
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