Dynamic Report Issue
I'm having a small issue with a relationship filter.
What i am trying to accomplish is a dynamic report being published when my user chooses a date. The point of the report is to sum the hours on an Attendence table based on a month. For this i have a relationship created with a userID and a calculation field. I have this already working with another instance showing the hours based on a calculation returning the current month. The problem is, i get blocked when i add global fields in the calculation.
My calculation that works is this:
Case( Month(Activity_Date)=Month(Get(CurrentDate)) and Year(Activity_Date)=Year(Get(CurrentDate)); 968 ; 0)
The relationship instance is based off of a field holding the userID and a field holding 968. This works. Then i have a calculation on the user table summing total hours based on this relationship instance.
My problem calculation is one that has global fields holding a month value instead of the current month. This is where the relationship goes sour. The calculation is returning proper results, but i get a little "Stop Sign" block on the relationship.
So why would it not like my calculation then? and Is there another way around this?