Month and Year (Pro)

[seancadie]

Hi All,

I have a bit of challenge to bring only Month and Year from the transaction date to show in the prompt.

Eg. Transaction date between '01-Jun-2012' and '30-Jun-2012'

I want to show only 6 and 2012 in the prompt, using two text prompts where user can enter the month and year.

Can you guys please assist me?

Thanks
Sean

[tjohnson3050]

First create a query for the prompt to use.  Create a separate data item for year and month.  In the data item expression box, use the 'EXTRACT' function to return just the year from the date.  Do the same for the month.

Create a value prompt, finish at the first wizard step, then set the query property to the query you created and set the field to the year data item you created.

Create a second prompt for month using the same method.

In the query for the report, create month and year fields the same as before, then use those to create filters using these data items and the parameter from the prompts.

[seancadie]

Thank you so much, I exactly followed the instruction and gave the result that I wanted.

Thanks.