Hello All
Is it possible for me to get a default value in the prompt every time a report is refreshed or opened.
This default value should be the latest fiscal week and comes from the database.
For eg. if the current fiscal week is 200436, the prompt should display
200436.
Next week, it should show 200437.
The mapping of fiscal week against calendar date is stored in a table.
aashoo_5 (BOB member since 2004-09-01)