Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I have created a form and when I check the select all box it only selects 20 records or the ones that are loaded in the grid. Can someone direct me to how i can have it select all records in the datasource instead of the loaded records.
I have tried changing the DS Delay Active = No
I have also tried this dynamicsuser.net/.../311603.aspx
Use the windows shortcut CTRL+A to select all, which on an AX grid will select all records. It will actually force all records to be loaded.
Dynamics AX MVP | My Blog | Sikich | Twitter @JorisdG
Thanks for the reply. Unfortunately it is still only selecting 20 records. Perhaps its something in the code i wrote that is limiting the records.
Once I select all by using CTR+A or the select all check box i am pressing a button which creates an array of the selected records using this line of code. Unfortunately it is only returning 20 records.
myArray = FormDataSource_ds.recordsMarked();
Then looping though the records using
However if i scroll the grid it will increase depending on how much I scroll.
Is there a better way to do this? This is my first time using forms/grids and their datasources and based on what i have read so far this is what i have come up with.
Thanks for the help
Try this: daxmusings.codecrib.com/.../multi-select-on-form-datasource-grid.html
Building on Joris's suggestion of pressing Ctrl+A, I have used a workaround a few times of pressing Ctrl+A then Ctrl+C to copy the grid contents to the clipboard -- the copying is what will actually load the whole data set. Unfortunately, this puts the burden on the user each time instead of a development fix.
Thanks for the response. I think i will just add a new button that will update datasource using select forUpdate at the table and if the user wants to select specific records they can use the existing button which works fine. This is a small part of the project so i can always circle back and by that time i will have more experience and have read 2 million more docs.
I took a quick stab at the link mentioned above. I didnt have any luck. I am using a staging table and not a system table so i wasnt able to translate the mentioned sample directly to my needs. That probably due to my lack of experience. I didnt want to spend a ton of time on this nor continue to bother you with the issues. I have a good work around and will circle back to this so i get a good understanding of how the helper works.
You can use the key combination Ctrl + Shift + End on a grid. Then AX will ask you to load and select every single record of the datasource.
André Arnaud de Calavon
thanks for the response. My goal is to do this in code and not having the user do anything but click the check box. At this point its my opinion that the check box doesn't function like one would assume and will work around it until i have a better understanding on how the grid/datasource and the select all(select all that is currently displayed) checkbox works
I ended up switching out my code to mimic this example and now everything is good.
Thanks everyone for all the help and responses.
A good solution for the purpose you want is to simulate a key press in the code.
Where element is the callerform.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics