Relation

[NiccoloBigolin]

Good morning to all
I am trying to relate two of my tables through date rows, I created a date table.
Once I relate them by date (they have the same date format) the visual objects don't talk, specifically the Filters I use in the report don't filter the visual objects fed by data from the other table.
How can I do this?

[cursed]

Morning,

I'm not sure if this will help within your context, but I had a similar issue before, to solve it I made a concated coulm in my datasets, which was the account name (it needs to be somthing distinc) and the Fiscal quarter (The date), I then mirrored this in my other dataset, then I set this as my active realtionship in the model view.

Let me know if you have any further question, or if you want any additonal help
Hope this solves your problem 🙂

Many Thanks
Ben