hello, is it possible to have grid export data with left join and groupby output same like on the screen? e.g. def report_do(): table_header = db.do_header table_detail_0 = db.do_product_detail table_detail_1 = db.do_stock_detail
groupby = table_detail_1.stock left = [table_detail_0.on(table_header.id == table_detail_0.do_no), table_detail_1.on(table_header.id == table_detail_1.do_no) ] grid = SQLFORM.grid(table_header, left = left, groupby = groupby, csv = csv) return locals() output on screen let say it have 2 records, but the exported csv have 4 records, because the detail table that related to table is have multiple product or stock. (no error occured but the result is not expected) i've check on gluon/sqlhtml.py but don't know how to modified ExporterCSV, is there any hints for that? thanks and best regards, stifan -- 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.
