This question has been flagged
1 Reply
7442 Views

I added two fields in my account_invoice.py for the date range i.e date_from and date_to to select a few number records falling into the range and i want to use the value of these fields in my report also as date_from: value to date_to:value. I tried using these fields in my report but it gives a blank array or [] in place of its value. Please help anyone who knows.

my fields:

'date_from':fields.function(lambda *a,k:{}, method=True, type='date',string="Date from"), 'date_to':fields.function(lambda *a,k:{}, method=True, type='date',string="Date to"),

and in search_view:

<field name="date_from" filter_domain="[('date_invoice','&gt;=',self)]"/>
<field name="date_to" filter_domain="[('date_invoice','&lt;=',self)]"/>
Avatar
Discard
Author

Anyone please! Still struggling for the same.

Author Best Answer

C:\fakepath\screenshot.png

Avatar
Discard
Author

I don't know how to attach a file so i did this way! please check the above link before answering as i want the data in date from and date to fields in search view in my report.

Hi Evon. Based on the above screenshot you got some records based on the dates you've specified in the list view. So when you tick checkbox on the left side of the record, you'll have a report menu on the right side. By clicking on the report you'll have a selected records report. You can find similar functionality in Sale Orders object(Quatation / Order).

Author

my question is that i want to print the date entered in the date from and date to fields in the report. I figured that the fields are functional and use lambda which can never return a value.

Author

As you can see in the above screenshot, i want to print the dates selected on top of the report for eg: 01/09/2013 to 30/09/2013 and the rest report is just copy of the tree view. Please help if you can.

Author

Can Anyone help?