I have a value prompt that lists week end dates in desc order like 8/20/05, 8/13/05, 8/6/05, ..... This list is generated dynamically depending on what the current week is. How do I default to the topmost first entry (8/20/05 in this case) as reportnet does not allow for dynamic default values? Thanks.
I guess we can achieve this...
The current Query you associate would be returning a value which you might be using it as both use value and Display value...
I suggest you to put the Row Number in the prompt Query as one of the fields and give "1" as the Default selection for your prompt... This will make the first row get selected...
This way, your query result might look something like below...
Row Number Weekend Date
1 8/20/05
2 8/13/05
3 8/6/05
Now, Use the Row Number as Use value and Weekend Date as Display value...
I guess this should work... I didn't try but let us know if this works...
Regards,
Sri
I am kinda new to this. How do I add the Row Number to my prompt query?
Actually, I got the row number to work. But if the Use value is the row number, how do I pass the date to a query to filter the results?
Can u send us how the current date filter looks like?
Here is the scenario. I have a prompt coming from a Query say Q1 that has RowNum, WeekID, WeeEndDate. I have another query Q2 that I need to filter against and it has the WeekID too. The prompt uses RowNum as its Use Value and Date as Display value. Now I want to be able to filter Q2 based on the WeekID corresponding to the RowNum selected in the prompt(actually date selected). How do I accomplish that.
sorry for very late reply...
i thought that your filter would be on some date field. then, you could calculate the dates you want by using the functions and the row id value...
if there is anyway to calculate your week id from the row id, then you can do that and use it in your filter... like as below...
_week_of_year(_add_days(current_date, rowid))
hope this helps you in someway...
Regards,
Sri