Can you use web2py for a reporting site - sure, a lot of what I do with it is reporting. I've been using DataTables.net which can provide pagination, sorting, search, aggregation and even basic export (via TableTools) for almost free. While it can enhance regular old HTML tables, with large numbers of rows I'd definitely pass it JSON datasets instead because it'll perform much better. You could also do all sorts of client side manipulation with AngularJS, React, Ractive, etc. too. Depends on your skills and needs. As for graphing, sure you can - there are plenty of good graphing libraries out there. Lately I've been using http://www.amcharts.com/javascript-charts/
You'll need to use executesql() <http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#executesql> to run your stored procedures since the normal DAL doesn't do them itself. One thing that concerns me is your mention of needing to display thousands of rows. I can't imagine such a large report being very user friendly. Even if it is paginated there is no way anybody can scan through that much stuff and come up with much for useful/actionable conclusions. You probably need to be looking at far better filtering and/or aggregation so that you're providing quality over raw quantity. Like Alex said though - it might be worth while to look into a dedicated reports generator. You're on MSSQL so why not investigate Microsoft SQL Server Reporting Services? You can build nice interfaces in that too that'd let your users fill out simple forms. Just because it's a reports generator doesn't mean that your users have to be computer savvy enough to be able to build the reports from scratch - that's were you come in and setup the types of reports they need so that they're easy for the user to access in a way that's easy for them. ~Brian On Wednesday, November 30, 2016 at 3:43:03 PM UTC-6, Gabor Nyul wrote: > > Well, my users have as good as no computer literary, so the reports > (lists) must be predefined for them. > Theyhave just to enter some parameters (like date from, date to) Nd run > the reports. > That's why I'm looking for an easy way to present those lists to them. And > of course, all the normal security staff (only specifically user groups van > see specific reports, where, I think web2py gives a correct solution) > should be provided. > > 2016. nov. 30. 22:23 ezt írta ("Alex Glaros" <alexg...@gmail.com > <javascript:>>): > >> with so many reports, why not just put them in a reports generator? >> >> this way, clients could tweak or create new simple reports themselves >> without programmer >> >> >> http://blog.capterra.com/5-awesome-free-and-open-source-reporting-software-packages/ >> >> Alex Glaros >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >> - http://github.com/web2py/web2py (Source code) >> - https://code.google.com/p/web2py/issues/list (Report Issues) >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/Re4SUDrq1HQ/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
