Kinamu reports: How to remove "text-align:right" and "</div>"

[raulisea]

Hi everybody!

Everytime I export a "Opportunities" kinamu report to the .CSV file, it shows some extra info in the "Ammount" and/or "Opportunity ammount" column "<div style="text-align:right;">Bs.25.000</div>"

After I set my "Comma separated text in columns" in Excel I end out with a report like this:


Please help me out with the removal of "<div style="text-align:right;"> and </div>" from this report

Sugar Community Edition
Versión 6.2.4 (Build 6735)
KinamuBasePackage_V_1_0
KReporterBasic_V_2_6_1


Thanks in advance.

[christianknoll]

edit modules/KReports/KReport.php and find the line:

case 'currency':
// 2010-12-16 right align the field if it is a currency field
$fieldValue = '<div style="text-align:right;">' . currency_format_number($fieldValue, array('currency_id' => $fieldArray[$fieldID . '_curid'], 'currency_symbol' => true)) . '</div>';
break;

and take the formatting way.

The issue is fixed with proper div and text alignment as well as proper UTF8 Currency Symbol in the current release but requires some additional parameters that are getting passed through the chain. For a quick fix that should be sufficient.

christian.

Hi everybody!

Everytime I export a "Opportunities" kinamu report to the .CSV file, it shows some extra info in the "Ammount" and/or "Opportunity ammount" column "<div style="text-align:right;">Bs.25.000</div>"

After I set my "Comma separated text in columns" in Excel I end out with a report like this:


Please help me out with the removal of "<div style="text-align:right;"> and </div>" from this report

Sugar Community Edition
Versión 6.2.4 (Build 6735)
KinamuBasePackage_V_1_0
KReporterBasic_V_2_6_1


Thanks in advance.

[raulisea]

Mr. Christian:

Thanks a lot for your helpful response.

Could you please detail the meaning of "take the formatting way". I found the spcefic line you reffered me to, but I'm not quite sure what to do and I am affraid of mess something up which could affect the performance of the Kinamu Reporter.

Thank you so much once again.

Raúl.

[beschaeftigt.de]

Hello Christian,
I encountered the same problem. Could you please give me a hint when to expect a new Version of your really great reporting tool.

I also saw that it is now possible to add custom functions. But I did not succeed in using them. Could you please explain how to access values and what syntax to use in this field?
Kind regards and many thanks,
Paul

[christianknoll]

$fieldValue =currency_format_number($fieldValue, array('currency_id' => $fieldArray[$fieldID . '_curid'], 'currency_symbol' => true)) ;

Mr. Christian:

Thanks a lot for your helpful response.

Could you please detail the meaning of "take the formatting way". I found the spcefic line you reffered me to, but I'm not quite sure what to do and I am affraid of mess something up which could affect the performance of the Kinamu Reporter.

Thank you so much once again.

Raúl.

[christianknoll]

Just write sql code. Use $ for the field you are looking at. if you e.g. have a date field and you write the custom function 'QUARTER($)' this will return the quarter for that date.

christian

Hello Christian,
I encountered the same problem. Could you please give me a hint when to expect a new Version of your really great reporting tool.

I also saw that it is now possible to add custom functions. But I did not succeed in using them. Could you please explain how to access values and what syntax to use in this field?
Kind regards and many thanks,
Paul

[beschaeftigt.de]

Thanks a lot for your help.

[chris.marsden]

Revived thread

I have this same problem but can not find how to remove the <div style="text-align:right;">Â i have.

[beschaeftigt.de]

you mean you don't find it at: modules/KReports/KReport.php ?

search for the code starting with:

 case 'currency': 
  

replace:

 $fieldValue = '<div style="text-align:right;">' .  currency_format_number($fieldValue, array('currency_id' =>  $fieldArray[$fieldID . '_curid'], 'currency_symbol' => true)) .  '</div>'; 
  

by:

 $fieldValue = currency_format_number($fieldValue, array('currency_id' =>  $fieldArray[$fieldID . '_curid'], 'currency_symbol' => true)); 
  

Kind regards,
Paul

[chris.marsden]

I have just realized I have made a very silly mistake.

this only appears when i export to excel.