Hi, For single criteria, i am able to get the PV value as 2016. But for union report .. there is no result. Regards, Ram.

Hi, I found the solution. Thank you. Regards, Ram.

Please let me know how to do this. regards, Ram

Hi, I have asked to describe the formula because of 1. In dashboard prompt, my selection is in MM/DD/YYYY format, and if i use PV in my report column it is giving correct result i.e in MM/DD/YYYY format. When i use same presentation variable in the filter of the report it is giving YYYY-MM-DD format. How did this formula…

Hi asim, Request you please describe the above formula how it functions with Date function.. It solved my problem. Regards, Ram.

Hi, I have entered date 01/03/2017 in the calender and presentation variable defined as day_pv. In my report i have written in the column like this year(cast('@{day_pv}' as date) It's giving the following error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.…

Hi, Yes Fomin, year drop down is not required. I need a year presentation variable (year_pv) which holds year from calendar (for example if i select 01/03/2017 from calendar then presentation variable should hold 2017). How to store year value in a presentation variable without year filter. I need this year pv for my…

HI, The report runs on a day and month which it belong to. If my report runs today (31 Dec) then month belongs to December (Current Month). Current year it will take from (JAN-DEC) similarly for the previous year it should take (Jan-Dec). regards, ram.

Hi, In this requirement user selects year only, there is no month filter to use. Any other way to achieve this. Regards, Ram.