I am using XAF and XPO, 12.2.8 and am wondering if functionality exists to do the following:
Feed a stored procedure into a nonpersistent XPO object then feed that nonpersistent object into the XAF report designer. I know functionality exists for the first as evidenced in the support ticket: http://www.devexpress.com/Support/Center/Question/Details/Q419290
However the only thing I could find regarding feeding a NPO into the report designer was from 2 years ago saying that functionality is "coming."
Is there a way to do this? I tried duplicating the functionality of the stored procedure in the report designers filter, but the report was so slow and so memory intensive that this is simply not feasible. Thanks in advance.
Currently we do not provide an out-of-the-box way to display either non-persistent objects or the result returned by a stored procedure in an XAF report. You can easily implement this by creating a native XtraReport in Visual Studio and then displaying it when an action is clicked via the PrintTool.ShowPreview method. Such a report can be bound to any datasource, including a collection of non-persistent objects.
XAF reports, in their turn, can be bound only to a particular persistent type. They load objects to their datasource internally based on the data type and filter. However, there is a way to suppress this behavior and pass a custom collection to the report's datasource. Please refer to similar tickets to learn how to do this:
Note that since this solution overrides the default XAF functionality, we cannot guarantee that Reports Module will properly work with such a report in all scenarios.