I got it . I have to read the record from the report_request table and do a json.load before the Report(definition, mydata) also in the designer i have to create paramenters...
Thank you 2017-11-22 14:55 GMT+00:00 António Ramos <ramstei...@gmail.com>: > Great. Will investigate further... > > Also another question > > the reportbro logo at the bottom of the pdf is there to stay? > > I´m doing a private app for my business. Do i need to pay any licence? > How do i remove that logo in the bottom of the page? > > Regards > António > > 2017-11-22 13:31 GMT+00:00 Alex <a...@jobsta.at>: > >> On Wednesday, November 22, 2017 at 1:46:06 PM UTC+1, Ramos wrote: >>> >>> Some questions ... >>> >>> 1 - i see that you have already a report_request table with the reports. >>> Are you talking about this table to save reports? Looks to me that this >>> table is to save the "templates" of the pdf reports >>> >> >> this is a different table to temporarily store report definition and >> data. It is used as a workaround for the plugin. The data for pdf preview >> in MS Edge browser cannot be set directly and needs a url instead. Further >> this is also needed for xls preview, because there is no simple preview >> plugin for xls. Therefor the url for xls preview is opened in a new tab and >> handled by the browser. >> >> >>> 2 - How do i merge data from my db with your templates and generate a >>> live pdf with live data? so users can save it in their desktop ? >>> >> >> in your web2py controller (where you generate the final pdf file) create >> a Report instance: >> report = Report(report_definition, data) >> >> where report_definition is the report template (the one you uploaded to >> your save controller), and data is a dict containing the actual data to >> fill in. the keys must match with your parameters of the report. E.g. if >> you have a parameter "first_name" then data must contain a key >> "first_name". You should check afterwards if there were any errors during >> report initialization (report.errors) >> >> the report itself (pdf file) is created with >> report_file = report.generate_pdf() >> >> >>> regards >>> António >>> >>> 2017-11-22 12:35 GMT+00:00 Alex <al...@jobsta.at>: >>> >>>> On Wednesday, November 22, 2017 at 12:07:56 PM UTC+1, Ramos wrote: >>>>> >>>>> Not that easy :) >>>>> >>>>> i´m reading your links and also this link >>>>> https://github.com/jobsta/reportbro-designer/blob/master/dem >>>>> os/custom_save.html >>>>> >>>>> where i´m stuck in the save part >>>>> >>>>> what url do i put in the save url ? >>>>> >>>> >>>> that's up to you. e.g. >>>> '{{=URL('report', 'save')}}' >>>> so you would need a controller file report.py with a function save in >>>> your application. There you have to save the report (available as data >>>> parameter) yourself wherever you want to. E.g. you could save it in your db >>>> or as a file. >>>> >>>> In your case you don't have the controller you specified in the url, >>>> therefor the ajax call fails. >>>> >>>> >>>>> [image: Imagem inline 1] >>>>> >>>>> i moved the run function from the reportbro_web2py.py to a controller >>>>> and i use it in the above "your save controller url" but i get a bad >>>>> request in the browser when i do in the console >>>>> $('#reportbro').reportBro('save') >>>>> >>>>> Thank you >>>>> >>>>> -- >>>> 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+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. >> > > -- 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.
