September 12, 2007, 10:18 AM
SGHow to generate alert links
Hello,
can anyone help me how to generate dynamic alert links in html page?
requirements:
ALERTS
1) Click here for invoices (invoices.fex)
2) Click here for orders (orders.fex)
3) Clikc here for sale (sales.fex)
I want to display alerts only when there are records in the fex files.
Thanks,
SG.
September 12, 2007, 03:43 PM
John MillerHi SG,
so, say you first create a report that lists customers and that's where you want to have a hyperlink to a report of orders for the customer, if any exist..
When preparing the customer report you should create a column with the number of orders for each customer. The column can then be used to create a column that will be displayed, if 0 orders then a blank is displayed, otherwise the text 'see orders' could be displayed.
The hyperlink to the orders report can be created on that column, passing the customer number, and make the hyperlink conditional so it will exist when the value is not blank.
Cheers