|
Hi,
I am working with Cognos8 Report Studio. In my report there are two date prompts, (1) START date, (2) END date. Users can select two different dates or two same dates. But the report has valid data only for last business date of each month. For example...
Answer Snippets (Read the full thread at stackoverflow):
So it could be start:29-JAN-2008 and end:30-MAR-2008 or same date a month/year ....
The standard calendar date prompt in Cognos in the way that you are describing, and quick search of the Cognos be the last business day of any month.
|
|
Hi everyone
- I created report, I use two Date value prompts (?Fromdate? , ?Todate?) .
- I want, when I run the report will run straight to the main page, does not appear promt page. I tried delete prompt page and select required = no.
- How to make ?...
Started by ChauTu on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at ittoolbox):
Make sure the prompt filters are changed to optional in queries..
|
|
Make sure the prompt filters are changed to optional in queries.
Started by Vijay Kumar Chavva on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at ittoolbox):
- How to make ?
Thanks all.
- I want prompt page and select required = no.
Hi everyone
- I created report, I use two Date value prompts (?Fromdate? , ?Todate?) .
|
Ask your Facebook Friends
|
Hi,
I'm a newbie to WEBI XI and have a simple date range question. I have a Dateprompt in my Query Filter section and I want to show that date range in the header section.
Ex. "From 4/1/12 to 4/30/12"
I have used the following formula after searching ...
Started by highnndry on
, 13 posts
by 4 people.
Answer Snippets (Read the full thread at forumtopics):
By digpen above, just replace DATE_FROM and DATE_TO in the formula with the real prompt texts, i.e.Hi,
What are the results of these 2 functions?
UserResponse("DATE_FROM")
UserResponse("DATE my promptSummary looks like....
|
|
I am using cognos8.4 and there is a report which has date range prompt based on which data gets filtered.
There are two date prompts (FromDate and ToDate). I have used JavaScript for date validation it is working fine but when by keeping the system date...
, 1 posts
Answer Snippets (Read the full thread at ittoolbox):
|
|
Need some help please.
I have a requirement where date prompt will be based on PAID_DATE field and from that I need to check if that Prompt date falls between Effective date and Cancellation date.
This is my current prompt looks like
Code: Table\PAID_...
Started by aapkaun on
, 8 posts
by 3 people.
Answer Snippets (Read the full thread at forumtopics):
Code: @Prompt('Paid Date','D',,mono,free) Between Table.EffectiveDate.
Hi aapkaun,
Try below code.
|
|
Is is possible to force a date prompt to have a default value of NULL? If so, how? Thanx in advance for any help.
Started by John Bolduc on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at oracle):
Specify the SQL result as :
SELECT
case....
In your prompt settings, default the prompt to 'SQL Results'.
Askjohnobiee.blogspot.com/2012/05/how-to-default-date-prompt-to-null-in.html
Edited by: askjohnobieeYes it is possible.
|
|
I am having a hard time calculating the number of months between 2 dates. I am trying to use the datediff function in a peoplesoft query with one date being an input parm. I continue to get the error 'the datadiff function requires 3 arguments'. Can someone...
Started by Justin Clement on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at ittoolbox):
|
|
This is a crude korn shell script that someone else wrote. I don't know much about using shell syntax and I'm not even sure if this is possible.
Is there any way for me to run this file and be prompted for the date so that I don't have to manually go ...
Started by CheeseConQueso on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Will continue to prompt for the date until the user enters something (anything) other than a simple
So you could replace the hardcoded date like:
./room_xls.pl $1
And run it like
./myscript 1/12/09
If you want to be prompted....
|
|
How to add the date rage that was put in when prompt into the report header?
I'm useing web intellagents and infoview to create the report. What I want to do is put the date range that the end user puts in when they are prompt when running the report....
Started by cdb424ttm1 on
, 2 posts
by 2 people.
Answer Snippets (Read the full thread at ittoolbox):
Is it really in the prompt message.
In your example, you have a space char before and after the prompt text.
One character difference and BO does not find it.
For the prompt syntax as it is very sensitive.
|
