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.
Thank you for your patience!
We don't currently have an editor in the SDK viewer component. I'm checking if this is something that will be available anytime soon.
In regards to in-memory data sets we already have started working on in-memory data provider feature which will allow the end users (developers) to provide at run-time a mapping between the data source written in dashboard’s model they load and their in-memory data – so when they create their dashboard they will be able to use any data source as a template but later in their application they can load whatever in-memory data they like.We’re now in the design phase and have an estimate for that feature to be ready be the end of this sprint and we expect to become available with next Update.
I'll post you back as soon as I have further news.
I think an SDK based designer will be really important with the in-memory dataset feature. It would be difficult/kludgy to manage the schema without being able to create it for use in the designer. At a minimum, even if it would be possible to just launch the designer app with additional in-memory schemas specified somehow, this would be huge.