Hi All,
I am trying to create an electronic report, but I am struggling with filtering and grouping on multiple tables.
My ultimate goal is have something like this:
User input: DateTimeUserInput
Filtering on: GeneralJournalEntry.AccountingDate = DateTimeFromUserInput
Grouped on: DimensionAttributeValueCombination.MainAccountValue, DimensionAttributeValueCombination.Dimension1Value, DimensionAttributeValueCombination.Dimension2Value, ...
Aggregated Field: Sum(GeneralJournalAccountEntry.AccountingCurrencyAmount)
I added a table records data source type (GeneralJournalEntry), a calculated field to filter, a user input parameter and a grouped by. In the calculated field i filter on a value from GeneralJournalEntry and in my Group by i group of fields from the tables GeneralJournalAccountEntry and DimensionAttributeValueCombination, which I select from the relations of my table records.
I can't seem to get it to work, I allways get the amount of results from the table GeneralJournalEntry and not my entire result. I am guessing that I should add all tables I want to use, but I can't figure out how to use the 'join' data source type.
I also tried to get results with only the calculated field which filters, and bind fields from lower laying tables via relations, but the same result.
And a last thing i tried, is to start from another table, but no succes either.
Any ideas?
