I want to get a single row from multiple rows after 2 tables are joined. I have a condition based on date.
If date1 = date 2 then date1 else null.
This is giving multiple rows and these are required in the report.
Is there any way to get the data in a single row.
E.g
100
200
Result:
100 200
I have tried various aggregations, that didn't helped.
Any workarounds?
Have you tried to use a repeater?
If you create the query subject in Framework Manager based on your requirement, you can change the Options on SQL from 'Minimized SQL' to 'As a View'. This would put everything on one row.
What aggregations did you try? I'd think a maximum on the date item and total for the measures would have done the trick.
Or try a query reference so that your base query with the multiple rows is feeding into another query, then set the aggregation on the query items in the new query. This would introduce local processing so beware of performance implications.