Disable the export to excel button in form

Finance and Operations/AX Technical Forum
1

hi,

How to disable the export to excel icon in the form in ax 2009.

Regards,

sandesh

2

Hi,

Right click the control option and click on set up. you will get one tab…click on info tab…You will get the form name…To go to the form, click on edit tab nearby in that dialog…You will get the exact tab. Now, go to the exxact control, go to properties and now disable it in properties or make it visible == No

3

Hi Enrique,

There is no property for disabling/enabling the Export to excel in form.

Regards,

sandesh

4

EnriqueKevin06 - hopefully you have noticed that the “Export to Excel” button is not a user defined button, but a standard coming from kernel ? You are not going to find that button in form design mode.

But regarding the actual problem, well… I never needed to achieve this, but some people advise that one thing you can do, is that you catch that button pressing event and stop it from executing, in this case the button is still present, but it just does not do anything. Override the task() method on your form, try it out if there is a specific task number coming along with the button ID (or something) from the event of clicking that button.

You can also try and catch the even in SysGridExportToExcel class which is responsible for excel exporting stuff. If you catch the callers ID then you could add exclusion there to prevent the class from doing anything if the call was coming from your selected form.

5

Hi Janis,

Thank You…its working perfectly fine…

Regrards,

sandesh

6

Hi Sandesh -oh, well… so what did you do in the end?

7

Hi janis,

I Override the task method…there i passed Task id…

Regards,

sandesh

8

hi janis,

I written code in Task method…

public int task(int _taskId)

{

#task

int ret;

if (!( _taskid == #taskCtrlE))

ret = super(_taskId);

return ret;

}