Here's what I need to do:
- I have a main report, with several subreports, mostly text.
- I want the user to enter a single date prompt (as a date)
- I want to then use the date prompts in the subreports, either directly as displayed data (or manipulated as a string, maybe), or as a filter.
I've created the Date (not datetime) prompt on the main report, and named it.
I've tried using it as a filter in some of my subreports, but it doesn't appear to like it, as my results are NULL, whereas if I replace the prompt name (?dateprompt?) with the function NOW(), it brings back the correct data set.
Also, I cannot seem to get a text frame subreport to simply display the date in the prompt, except as a 'prompt display', which I can't use since I can't manipulate it...(I need just the Month name and the year)
Anyone got any ideas?
Sam Stengler
- I have a main report, with several subreports, mostly text.
- I want the user to enter a single date prompt (as a date)
- I want to then use the date prompts in the subreports, either directly as displayed data (or manipulated as a string, maybe), or as a filter.
I've created the Date (not datetime) prompt on the main report, and named it.
I've tried using it as a filter in some of my subreports, but it doesn't appear to like it, as my results are NULL, whereas if I replace the prompt name (?dateprompt?) with the function NOW(), it brings back the correct data set.
Also, I cannot seem to get a text frame subreport to simply display the date in the prompt, except as a 'prompt display', which I can't use since I can't manipulate it...(I need just the Month name and the year)
Anyone got any ideas?
Sam Stengler