If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Regarding date Prompt in propmt page

Started by kvchow, 15 Oct 2014 06:10:55 AM

Previous topic - Next topic

kvchow

Hi ,

I have a Date Propmt in Prompt page,here date range is showing like Jun 1,2012,Jun 1,2012,ihave the same date column in report page.

My query is if my user select date range in prompt page ,the parameter i am passing to report page,there my user wants format like.. from 2012-Jun-01 to 2012-jun-05(Pass parameter value) like this

I changed in report page and data is coming as expected format,Please find the attached doc

any Idea?
Thanks,
Kvchow

BigChris

So have you got two prompts, one for the start date and one for the end date? If you have then it sounds like you'd just need layout calculation that looks something like:

'Date:  ' + ParamDisplayValue(?pStartDate?) + ' To ' + ParamDisplayValue(?pEndDate?)

kvchow

Hi Bigchris,

Thank you for your reply

I will try your solution and i will let you know

Great thanks to u...

Thanks,
Kvchow

kvchow

Hi Bigchris,

i did the same what you mentioned ,but i am not getting the required format

I tried to create to lists and i taken the date column into the queries and i taken the data item in that i put the required format and now dates are coming as expected,here my problem is if there is no date  in prompt page for my selected date then that time it is showing s no data available,but my requirement is i need to display that date if there is no data also for that date

Any Help?
Thanks,
kvchow

Joker

#4
Quote from: kvchow on 15 Oct 2014 06:10:55 AM
Hi ,

I have a Date Propmt in Prompt page,here date range is showing like Jun 1,2012,Jun 1,2012,ihave the same date column in report page.

My query is if my user select date range in prompt page ,the parameter i am passing to report page,there my user wants format like.. from 2012-Jun-01 to 2012-jun-05(Pass parameter value) like this

I changed in report page and data is coming as expected format,Please find the attached doc

any Idea?
Thanks,
Kvchow

Hi Kvchow,

-Add a query calculation to the Report and define the expression as the Date Parameter.
- Drag a singleton on the report page and associate it with main query.
-Drop the data item created to the singleton.
-click on the date data item.
-In Properties go to data format.
-select Format as Date.
-In Properties go to  Pattern and type yyyy-MMM-dd
-save it and run the report.

I believe You want to do this only.

Regards,
Joker

kvchow

Hi Joker,

I tried singleton,Layout calculation and run time calculation,But i didn't get the expected format

Thanks for youe replies

Thanks,
Kvchow

sunny bachan prasad

I think jockey method should work.Can you send the screenshot of the report output.

Joker

Quote from: kvchow on 17 Oct 2014 04:27:12 AM
Hi Joker,

I tried singleton,Layout calculation and run time calculation,But i didn't get the expected format

Thanks for youe replies

Thanks,
Kvchow

Hi,

These steps worked for me and will work for you also.
Please try once again.

Regards,
Joker

kvchow

Hi Joker,

Thanks for your replies

It is working

Thanks,
Kvchow