report_creator does not handle identical field names correctly

[Ferdinand]

using c2c_budget - this will happen everywhere - I just wanted to create a report based on this data

this query
 select
     min(c2c_budget_version.id) as id,
c2c_budget.name as field0,
c2c_budget_version.name as field1,
c2c_budget_item.name as field2
     from
     c2c_budget,
 c2c_budget_item,
 c2c_budget_version
  where
 c2c_budget.budget_item_id=c2c_budget_item.id and
 c2c_budget_version.budget_id=c2c_budget.id
                 group by
c2c_budget.name, c2c_budget_version.name, c2c_budget_item.name

returns
a report "Name","Version Name", "Name"
whereas the content of the second "Name" column is identical with the first "Name"
because the c2c_budget and c2c_budget_item both have a python "Name" label whereas c2c_budget_version has "Version Name"

this is probably a limit of the XML engine which obviously can not handle duplicate names

Possible workaround ?
use field0 string="Name", field1 string="Version Name", field2 string="Name" to construct the XML

[Ferdinand (office-chricar)]

or allow custom labels

[Mantavya Gajjar (Open ERP) (mga)]

Hello,

Well this is not that much complex task, and can be provide this feature easily

by adding a new column in model "base_report_creator.report.fields"

[Mantavya Gajjar (Open ERP) (mga)]

hello,

probably i will do this fix in trunk

[Mantavya Gajjar (Open ERP) (mga)]

hello,
its working now, can any one check and reply
thanks

[Mantavya Gajjar (Open ERP) (mga)]

released in 5.2

[Mantavya Gajjar (Open ERP) (mga)]

release in 5.2

[Mantavya Gajjar (Open ERP) (mga)]

Hello,

as this feature goes to Trunk branch so, Here is a patch for the users of the 5.0.4

check that and reply
thanks