What does a Filter do in Report Model

Hot Topic

Can Data Partitions be used with associative tables?
upgrading from SqlExpress2005 to SQLEXP2005Advanced
Merge Replication Conflict Problem
Can I get a Query from a Fetch_cursor in SQL2000
set default print margins in sql server management studio
NewID
Data Mining Wizard (Not Responding)
Microsoft Sql Server Embedded Edition Service
How to assign roles to a user on reporting server through Web Service MEthod
problem with custom conflict resolution

SQL Server

Clusters and Log Shipping
Timeout on successive messages
Stop spell check of Outlook 2003 signature
putting dbo explicitly in select staetement
Msg 8621: The query processor ran out of stack space during query optimization
Restoring SQL2000 Transaction Logs to SQL2005
SQL Mobile 2005 NVarChar Truncation Problem?
Limiting the Records in SELECT Statement
OLE DB Destination fails with illegal instruction
how to write input param SqlInt32[] in CLR store procedure

What does a Filter do in Report Model

In a Model designer when you select and Entity you have list of Attributes on the right side. There you have the option to add new "Folder", "Source Field", "Expression", "Role" and "Filter".

Can anyone explain in a bit detail what this filter can be used for. Can it be used to filter data from underlying entity (I am not looking for SecurityFilter)

I am working on Microsoft SQL Server 2005 - 9.00.3027.00

Thanks,
Rahul

Answer this question

What does a Filter do in Report Model

  • a.d.m

    thanks for the reply.
    What you explained was not confusing. I knew you could use the filters in model in reports. The way I understand these filters is that they are optional in your report, I don't want it optional. I want to present filtered data.

  • S_Parikh

    Yes you can create a filter that is associated with that entity and can be later used in the report.

  • RobC2k6

    sorry for the confusion, I meant to say you can filter data based on date for example.

  • xion.truth

    That's a little unfortunate. I was hoping to find a way to filter data from entity. Not based on security but say based on date. Is there a way filter data in a model
  • What does a Filter do in Report Model
Answer this question