Compare a report to an atom feed about nbi HOT 3 OPEN

This would really be a very cool and powerful feature!

Some thoughts about it:
perhaps the system-under-test part of a test would need to point a the atom feed xml-file or be directly included as CDATA-text?
In addition probably which report item is referenced if one has multiple tables.
The assert could then use the same approach (if it's compared against other report instances) or fixed reference data from a CSV or database table, whatever it might be.

from nbi.

The key question is to tranform a hierarchical result (XML/JSON) into a table result (SQL query result/CSV/...). It sounds trivial but it is not. If you've some ideas they are welcome.

from nbi.

@Seddryck , I see your point!
I have two ideas in mind:

1. Could it be possible that the result of the OData-Feed of a reporting services report is always is the same pattern and therefore has a static hierarchy? Then it would be way easier to implement a SSRS-specific solution. How would you approach this? Perhaps I can check some questions.

The flattening behaviour and much more is described here:
https://docs.microsoft.com/en-us/sql/reporting-services/report-builder/generating-data-feeds-from-reports-report-builder-and-ssrs

2. As a backup or an easier-to-achieve-approach, NBi could compare the result-XML directly. Meaning that just the pure text (maybe without header information) is compared and if the content changes NBi returns an error. I know, this is very plain and doesn't meet exactly what we want, but maybe it could be a start?

from nbi.