Is there a way to store\save user prompt values?

Hi Abhay,

Thanks for reaching out. This is indeed possible.

To set this up, bring in your user prompt date filter with the less than equal to operand:

Next, create a Calculated Field > Pre-Defined > Month, SQL Server and select your Date filter field:

This will default to a Numeric value:

But if you click the arrow next to the new Calculated Field > Edit > Format, you can change to these values:

You don't have to keep in the original filter as a field either, it can just be in the filter list:

I just left it in to demonstrate the Month values are correct.

If you're not using SQL Server then instead of a Pre-Defined function, you'll have to script a Freehand SQL statement that breaks apart the Month from the field in question. You can find how to accomplish this in your corresponding RDBMS' documentation or other online resources. Here's my report's SQL statement that's generated though so there's something additional to go off of:

Hopefully this helps! Please let me know how goes.

Regards,

Mike

Hi Abhay,

I just wanted to check in and see how things are going with this.

Regards,

Mike

Hello Mike,

Thanks for the inputs. However, I haven't yet tried this due to some busy schedule.

But I will check this next week.

Regards,

Abhay

Hi Abhay,

Sounds good. Thanks for the update.

Regards,

Mike

Hi Abhay,

I just wanted to check in and see how things are going with this.

Regards,

Mike

Hi Abhay,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike