Hi, is it possible to embed or launch the report designer from within the application? Also - is it possible to dynamically add datasets available to the designer, e.g. pre-run results from stored procedures.
Hello and thank you for your support request!
Where would you like to embed the ReportPlus Desktop app?
How would these dynamically added data sources be used?
Looking forward to hearing from you,
Hi - we've got an existing .NET winForms app using Infragistics grids/charts/etc. What we want to do is to either launch the designer from the app or within the app (i.e. as an editor control within a form). The end-user would then be able to design their own reports
The one wrinkle is that we have a bunch of stored procedures that do some pretty heavy number crunching, and we need to use the SP output as a datasource. I don't see how this is possible in the ReportPlus designer, it only lets me select tables and views. Does the designer only support static data?
The way we currently handle this is we run all the calculations/generate a dataset in memory, and then point the datasource of the winforms controls to the results. The user can then pick and chose columns and design their report. In our app when a user runs a report, the are presented with a parameter screen that allows them to pick and choose parameters - then the database SP delivers processed data. Schema is constant, however it would be computationally impossible to pre-compute all of the data and store these as tables; parameters determine how calculations are made, and there are sometimes 20+ tables as a result of a calculation.
What we want to do is to take these 20+ dynamically calculated tables (in-memory dataset) AND the static tables (i.e. reference data) and allow the end-user to build an ad-hoc report based on this universe.
Does this make sense?
Let me check with my team on what would be the correct approach.