![]() Please find below a quick demo of how I successfully integrated the viewer and the designer into my APEX Apps. ![]() You can have a look at the Stimulsoft demo on their website: įor any report, you can also click on the "Edit" button on the top right corner to access the report designer But I don't see any interest in it, APEX is doing this job perfectly. With Stimulsoft, you can also build interactive dashboards, reports & forms. The user can then choose to print it or save it in any format. When you run a Stimulsoft report, you can open it directly on your APEX Page with the built-in "report viewer". The report template produced by the report designer is a JSON that you can easily store in a CLOB column in your database and easily manage the different versions as you wish. (There is also a standalone desktop designer that you can install locally but I'm not interested in it) Yes, you don't need to install anything to design your report templates, Stimulsoft has a web-based report designer and yes, you can easily add it to an APEX Page and build your reports directly within your APEX App. Stimulsoft has a proper "report template designer", like Oracle Reports, with all the standard options, like Groups / Sub Reports / Cross-Tab (matrix) / Summary Function / Print on All Pages / Reset Page Number etc.etc. You just send the dataset in json and a "report template" in json to the javascript engine and it does the job. For me, it's the way to go because you don't need to worry about any compatibility issues, JDBC drivers, DB Versions etc. Stimulsoft is compatible with most common databases but like AOP, you can pass the data dynamically in JSON format. Yes, the engine can run in JavaScript on the client, so you don't need to install and maintain anything on the server side. It seems that there are various ways to install or embed it, but for APEX, I think that the best option is the Stimulsoft Embedded Reports.JS I must say that I was completely impressed by it and felt like I had finally found the perfect reporting solution for my needs. ![]() I recently came across this solution by chance on the net and I decided to give it a try. Maybe one day? A Stunning Alternative Solution: Stimulsoft Several nights in a row I dreamed that the APEX team had created a proper " Report Template Designer" within APEX, with components, repeating groups, properties pallet, page break options, cross-tab (matrix) etc.Īnd in my apps, I could just point to a specific "report template" and "dataset" and boom, I get a pixel-perfect PDF (or spreadsheet). You need a proper "report template designer" !!! Dreaming Solution It's like trying to eat soup using chopsticks. ![]() You always hit some limitations at some point, simply because Word is not a report designer! The different teams will try to add all kinds of "dirty options" to get around these limitations but for me, it is simply not the right way. To be honest, I'm not a big fan of the "word template" and tags replacement model. and I have never been entirely satisfied with any of them. ![]() I've tried several solutions, BI Publisher, Jasper, AOP & much more. I still can't understand Oracle's decision to kill such a wonderful tool.įor years, I've been desperately looking for a reporting solution that could replace it. We need an external solution for this.įor me, Oracle Reports was (by far) the best reporting tool for "oracle developers". This is a requirement in most projects and today, this can't be done using APEX only. For me, the feature that APEX misses the most is a "proper PDF reporting solution", to be able to produce pixel-perfect PDFs for quotations, invoices etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |