Hi,
I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...



Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me.....

Answer / kumar

Hi Friends,

in Prompt page add a filter like

Treat Ship Date as a Date Column,

ANS: day_of_week(Ship Date,0) not in (5,6)

Here 0-Monday
1- Tues Day
..................


Thank You
Kumar

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Cognos Interview Questions

What are the advantages of shortcuts?

0 Answers  


What is meant by report studio short cut?

2 Answers  


wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers  


can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..

2 Answers  


how can you create a project creation

0 Answers   HSBC,






There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?

2 Answers   BitWise,


hi How Can we create rank in our report?i feel difficulty pls expain me with ex,pls pls........

2 Answers  


WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?

2 Answers   ABC Infotech, Virtusa,


What is Local Cache and how does it help in performance tuning

1 Answers  


what is the diff b/w excel 2000 and excel 2002 sheets if any body know this answer plz tell me

4 Answers   IBM,


how to convert crosstab into list?

4 Answers   TCS,


How to schedule the report twice in a day?

2 Answers   Cognizant,


Categories