I like Python too but heck if you're that well versed in .NET I'd just do ASP.NET and use a nice grid: https://www.devexpress.com/Products/NET/Controls/ASP/Grid/
Done and done. On Thursday, December 1, 2016 at 2:08:18 PM UTC-5, Gabor Nyul wrote: > > First of all thanks for the hints. > So it means that the web2py's integrated grid will not be suitable for my > needs. Bad luck. :-( > Then here is a stupid and somehow provocative ( :-) ) question: What is > the value add of web2py (compared for example to flask or bottle) if in > every case I have to use an external javascript library like Datatable, or > slickgrid, or Tabulator? > > Now regarding your concern (normally I am saying exactly like you, nobody > is able to check some thousands rows, but in fact... well, yes. They are > doing it. Actually in Excel) about the number of rows, here are some > explanations: > Those reports are about our activity and each department is analyzing > their activities for the past, as well as for the coming several weeks. > So the initial reports are extracted from a huge database of hundreds of > millions of records. So the size of the reports are from some hundred to at > most, let's say 25000 records. > After that the users are starting "working" on the data. They are sorting > and filtering them for after that do what they have to do with the > information they have got. > There is always a sentence I hate: "Can I export it to Excel?" :-) I'm > teaching them to use a central too and database and do not export it into a > tool like Excel to manipulate the data to see "exactly" how they want them. > > That's why I'm looking for a user friendly table (grid) solution where I > an able to format (color) the data based on some rules, sort and filter > them. > > As a background information: I'm coming from a windows desktop development > world (.NET, Delphi), where all this is not an issue, everything is > performing well and fast. But.. It is not web based so the deployment of > the updates are a kind of headache. And I like Python. :-) > > 2016. november 30., szerda 23:46:39 UTC+1 időpontban Brian M a következőt > írta: >> >> 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>): >>> >>>> 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. >>>> 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.
