İçereği Atla
Bu soru işaretlendi
xlsxreportnameodoo11community
4 Cevaplar
9531 Görünümler
Avatar
Muhammed Nishad

Hi All,

I'm working on module that generates salary report based on a criteria.I have Created a wizard namely my_module_name.wizard, It's of 'models.TransientModel'.My Wizard has a field named file_name i want this field as my xlsx file's name.

I have already tried this , It doesn't work , it always prints the file attribute's value as file name

<report
    id="mymodule_xlsx"
    model="mymodule.wizard"
    string="SIF Report"
    report_type="xlsx"
    name="mymodule_xlsx.xlsx"    
    file="mymodule_xlsx"    
    print_report_name="(object.file_name)"
    menu="False"
    attachment_use="0"/>

Please Tell me how do we do this?

Avatar
Vazgeç
Avatar
Gustavo Hinojosa
En İyi Yanıt

modifying the object from python.

@ api.multi

def print_xlsx(self):

    report = self.env ['ir.actions.report'] ._ get_report_from_name ('module.ng_hemployee_xlsx')

     # en v11 ##################

    report.report_file = "new name"

    return self.env.ref ('module.ng_hemployee_xlsx'). report_action (self)

    # en v9 
    report.name = "new name"

    return self.env ['reporte']. get_action (self, 'module.ng_hemployee_xlsx')

Avatar
Vazgeç
Avatar
Reydi Hernandez
En İyi Yanıt

Hi guys, I solved the problem as follows:
#V12

@api.multi
​def action_print(self): 
    self.env.ref(report_template_xlsx).report_file = "New_name.xlsx"

    return self.env.ref(report_template_xlsx).report_action(self)

Avatar
Vazgeç
Avatar
Krupesh Laiya
En İyi Yanıt

for above you have to override odoo's report method from report  module

Avatar
Vazgeç
Muhammed Nishad
Üretici

The report is printing fine.The Problem is with the file Name.

Avatar
Arif
En İyi Yanıt

I have solved it by the following way. Hope it helps

# in your wizard model's action method
report_obj = self.env.ref('module.your_report_id')
report_obj.name = f"your_file_prefix_{self.read()[0].get('your_input_filename')}_postfix.xlsx"

return report_obj.report_action(self, data=data)


Avatar
Vazgeç
İlgili Gönderiler Cevaplar Görünümler Aktivite
How can remove decimal number ".00" in print receipt? Çözüldü
odoo11community
Avatar
Avatar
Avatar
Avatar
Avatar
9
Haz 23
12984
Export liste devis en xlsx
xlsx
Avatar
1
Şub 23
1716
Export time wrong with data in field on odoo 11
odoo11community
Avatar
Avatar
Avatar
2
Oca 22
3791
How to add “add an item” behavior of odoo one2many fields to main model tree? Çözüldü
odoo11community
Avatar
Avatar
Avatar
2
Ara 21
7781
synchronisation account move and move_line
odoo11community
Avatar
0
Haz 21
1854