I have prompt date prompt (from and to), country and city,
how to get data from jan1/2012 to jan31-2012.

Answer Posted / nagendra

create a filter in the report Query with date from and date
to parameters.
eg: date>=paramdatefrom and date<=paramdateto
When you run the report Select date prompt from jan 1 to jan
31 2012

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of using cognos sql?

658


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

5972


What is the difference between a cascading report and drill through report?

650


How can create users and permissions in cognos?

559


Name the types of report?

550






New coloums are added in database, then how you know in report level

1155


What is cognos connection?

587


what are the errors faced while bursting the reports and how to solve those errors?

1565


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

1694


-----------With out using DrillThrough how to do Reports?

1601


How to apply securities for reports in cognos connection?

2112


How do you improve the performance of the Cognos Analytics report

533


Write various indexes used in cognos?

552


How do you Parametermap variables in Quiries?

1771


what is a prompt value in report studio and variables ?

2164