Is it possible to display the input of a Query?

For example, we want to summarize transaction amounts up to a specific date. We use QueryDate to Prompt the user to select the Date.

The user is likely to either print this View, or send it over to Excel.

It would be very helpful if the Date that they selected could be displayed as part of their results. (For example, if this were done in Crystal Reports, I would have a title something like: “Transactions as at xx/xx/xx”.)

Any suggestions?

Hi Samuel,

Place the QUERYDATE() in a calculated column and display the column. The Filter can refer to the calculated column.

Andrew:
I create a Calculated Column as you suggested, as follows: QUERYDATE("Enter the As-Of Date")

As well, I am using the following Filter: {Trx Date} <= QUERYDATE("Enter the Last Date")

The column appears with my As-Of Date, but when I run my View, GV prompts me twice to select a Date (i.e. "Enter the As-Of Date", and then again "Enter the Last Date").

How can I have GV only prompt once for the run date?

Remove the QUERYDATE() from the Filter and replace it with the Calculated Column. As in:

Andrew:

This is working nicely – thank you. (I am right-clicking on the calculated column and displaying it using one of the date formats, so that it displays the correct date.)

But I still have a problem (sorry!).

I run the View and then I summarize it. I hide most of the columns (since they are not relevant for the summary). But I would like to display the As-Of Date.

The problem is that the As-Of Date column is out-to-lunch when I use Summarize. What appears to be happening is that the Summarize feature is treating this column as a numeric and therefore is summing all the values in the column.

Edited response – I just discovered if I right-click on the calculated column title and select Display Minimum, my Dates are maintained when I summarize!

Glad to hear it's all working for you now!