Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


SSRS Date filters

Posted on 2010-09-10
Medium Priority
Last Modified: 2012-05-10
Hello Experts,
I have created a hierarchy on my DimDate dimension. And how can I apply
WeekOfYear hierarchy attribute to my SSRS report?

When I try to apply it then I get message such as:
"aggregate functions cannot be used in dataset filters or data region filters"

Any idea?
Question by:innocent1973
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Author Comment

ID: 33651129
I have tried to create a report parameter. But there is still someting that I missed.
I have attached two screenshots.

Please help

Author Comment

ID: 33651137
Is there anything wrong about dimDate hierarchy?
LVL 10

Expert Comment

ID: 33653109

"how can I apply WeekOfYear hierarchy attribute to my SSRS report?"

Could you clarify what you are trying to achieve? Do you want to create parameter which will show week of the year?

Have you created the parameter during data set creation (parameter text box) or manually?



Author Comment

ID: 33654812
I have tried to create a parameter.And also tried to create a report filter.But when I choose the parameter value format as Date/Time then nothing happens.

I have to create a report parameter that consists my date hierarchy.
LVL 10

Accepted Solution

itcouple earned 2000 total points
ID: 33659931

If you want date hierarchy (tree filter) then I don't think you need to select date/time format when working with OLAP. I think Date/Time would only be used when you want user to pick the date from the calendar.

Let me know if changing data type resolves the issue.


Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question