Change a field to be Reportable

[BMGOffice]

I have created a custom module and forgot to make the field Reportable.
How can i change it to show up in available fields when creating reports?

Is there any way to change created fields for Required, Reportable, Importable or Audit after creating them?
Is this possible somewhere in the database?

[salesagility]

goto admin>studio>custom module>fields>field name and check the audit box ... save and deploy and you're in business

[roblaus]

Since fields in modules created by the module builder are treated as if they were system generated fields this won't work.
Go to custom/Extension/modules/yourmodule/Ext/Vardefs and create a file (e.g. reportable.php) with the following content:
<?php
$dictionary["Yourmodule"]["fields"]["thefield"]["reportable"] = "true";
?>

Rebuild extensions. Hope it works then.

[salesagility]

Rob ... you're correct ... perhaps if I had read the bit that said "custom module" I'd have given a more accurate response

[BMGOffice]

Thank you. Is there any other way? Possibly to do it in the database?

[BMGOffice]

Would this be correct?
I have never done this before. Does " " always mean replace with something and delete the " "? Or is sometimes is it a general/all include term?

<?php
$dictionary[Dist_Distribution]["fields"][distribution_zone]["reportable"] = "true";
?>

[roblaus]

No, it means that you should be using double quotes also for Dist_Distribution and for distribution_zone
<?php
$dictionary["Dist_Distribution"]["fields"]["distribution_zone"]["reportable"] = "true";
?>

[christianknoll]

O)r you can try another reporting module ... this making some fields reportable and others not is also a concept I never understood ... ;-)

http://www.sugarforge.org/projects/kinamureporter/

christian.

No, it means that you should be using double quotes also for Dist_Distribution and for distribution_zone
<?php
$dictionary["Dist_Distribution"]["fields"]["distribution_zone"]["reportable"] = "true";
?>