What is the difference between filter & Condition?
Answers were Sorted based on User's Feedback
Answer / m m naidu
Filter: A filter is a condition which restricts the amount
of data displayed in the report.
Condition:An expression that yields a boolean value.
Conditions are used in query expressions, query filters,
and boolean report variables that can be used for
conditional formatting, styles, data sources, layouts and
blocks.
| Is This Answer Correct ? | 19 Yes | 6 No |
Answer / satya/gunu(satyabadi)
-> A filter is a restriction that reduces the amount of data
returned from data base.
-> A condition is created with the three components
1.Query item
2.Operator
3.Operand
=> In addition, The model filters are reusable which can be used for a multiple reports.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / deep kumar
Filters : Its Condition on What type of Data to be
displayed. [Data Driven]
Condition: Its Condition on what to Show depending upon
the expression /formatting /styles/layouts .
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / sridhar
Filters : Its Condition on What type of Data to be
displayed. [Data Driven]
Condition: Its Condition on what to Show depending upon
the expression /formatting /styles/layouts .
| Is This Answer Correct ? | 3 Yes | 11 No |
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
-------------What is a Conformed Dimension?
Create 12 columns for months by writing single case statement?
What is power prompts?Can somebody explain me.
After installation of Cognos Reportnet how do i know how much of entire Cognos server is being utilised at any instatnt of time?
What are all the components of Report Studio?
What are the different ways of adding data in Transformer?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
I want to display popup menu or alter message in my report? How to you solve this problem? Give me the answer with example?
what is a prompt value in report studio and variables ?
What are the different types of OLAP. Which one is Cognos Powercube?
How we check the errors before running the report,plz let me know the answer