June 24, 2017 at 10:58 am #10319
The Adhoc library has served us well over the years, but it getting kind old and clunky.
We’re looking a new way to allow our users to write custom reports.
Does anyone have any solutions they’ve integrated into Omnis Studio?June 26, 2017 at 10:53 am #10567Andreas PfeifferParticipant
How about using a number of template reports copied into an additional library. You could then use the modify report field in order to allow access to those libraries so that the customer would be able to modify his own reports.
Does this help?
AndreasJune 26, 2017 at 5:26 pm #10574
Thanks Andreas, yes that’s possible. I was really looking for a way to allow users with less technical skills to be able to able to put together a report in a more simplistic manner so that less training is required. I’d also like to take advantage of some more modern looking graphics if possible. If I have to, I can rewrite it from scratch, but I’d like to avoid this.June 27, 2017 at 10:32 am #10576Stefano ManzoliParticipant
you could take in consideration the oWrite component from BrainyData, it’s a fantastic tool for build template and reports easily customizable from the final user.
Take a look here : http://www.brainydata.co.uk/products/owrite.htm
And look the examples.
StefanoJuly 6, 2017 at 7:03 pm #10680
Sorry I missed your reply. Yes we do use oWrite. It’s great tool for somethings. I’ve noticed some issues in our version of Omnis 18.104.22.168 rendering the rich text data. I’m curious if you have any examples of how the owrite tool can be used for this type of custom report writing.July 8, 2017 at 1:11 pm #10685Stefano ManzoliParticipant
we do an extensive use of owrite in several applications, we use it to produce documents that merge data from database and that generally needs to be edited from final user, but we use it also for more standard document like invoices or orders.
You could see an example here: https://youtu.be/1mtGknQzluE
it’s short demo video, but you can see a quick sample of how we use it.October 4, 2019 at 8:26 pm #22351
Sorry missed this interesting tutorial, however I don’t speak Italian. Do you have one in English?August 6, 2020 at 10:26 am #28211Rainer GreimParticipant
Hi and best regards from sunny Germany,
I don’t know if it is the best solutions for a 100 % Omnis solution, but have changed my solutions to a web approach, means output is pure html done by a cron job. Benefit, now its possible to archive the static files or load them in a browser to export them to pdf or whatever.
And as the templates are pure text u can edit them with standard methods and have some classes to fill them with lives.
Another option i have tried : Valentina dB and Valentina reports.
I was looking for a tool to edit SQLite dB, but I was amazed that it is much more…
Btw: every year they have a Omega bundle, where u can save a lot of money, even if you need only Valentina studio for SQLite DBs and more.
But still today I use the static html generation as I don’t have much data to handle. Important is, the output can be archived…
And for this method I don’t need to install a real web infrastructure.
You must be logged in to reply to this topic.