We have a report where the user is prompted to give a listnumber, where the highest number will generate the most recent data. We want the same report to be processed by the BCA with the highest number available, without having to put in the highest number manually every day.
Is there a way to combine the user input for ad-hoc queries and the highest number available for the BCA in one prompt (thus one report).
In short we want one prompt where we can select either a number from the LOV or a value that will select the highest number available!
We tried to use the solution for the optional prompt mentioned inearlier discussion in this list, but we didn’t succeed.
DISCLAIMER******** Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.
This e-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s).
Fortis rules out any and every liability resulting from any electronic transmission.
We have a report where the user is prompted to give a listnumber, where the highest number will generate the most recent data. We want the same report to be processed by the BCA with the highest number available, without having to put in the highest number manually every day.
Is there a way to combine the user input for ad-hoc queries and the highest number available for the BCA in one prompt (thus one report).
In short we want one prompt where we can select either a number from the LOV or a value that will select the highest number available!
We tried to use the solution for the optional prompt mentioned inearlier discussion in this list, but we didn’t succeed.
DISCLAIMER******** Deze e-mail is uitsluitend bestemd voor de geadresseerde(n). Verstrekking aan en gebruik door anderen is niet toegestaan. Fortis sluit iedere aansprakelijkheid uit die voortvloeit uit electronische verzending.
This e-mail is intended exclusively for the addressee(s), and may not be passed on to, or made available for use by any person other than the addressee(s).
Fortis rules out any and every liability resulting from any electronic transmission.
Hi Robert,
I have a parameter table set-up that keeps track of the things that drive my reports. For example one of the fields is the maximum invoice date. This date is used in a subquery on my report to bring back the sales for the last day of billing.
Simon
I think you want to create a dynamic LOV. Search more on that. Then you can prompt for a date, but when they click on “LOV”, it will fetch the max dates and return that instead.
(BOB member since 2002-10-04)
(BOB member since 2002-08-15)