How to show Grid as a Empty When form will open but after filter Data ,Grid should display Data

(1) Share

Report

Posted on by Community Member

Hi,

I am new in this field. so i am getting confused. Requirement is that , there are two textboxes on form ,1 grid & 1 View button.

Now i want that When i will open my form ,grid should be empty. but if i set some daterange in that two textboxes, after clicking on View button,Respective data should be display. please help me.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Rohin 4,624 on at

Like (2)

Report
Copy link

Link copied!

Hi,

You have to set range by default (for example "Blank" like when form open) and then call it in exceuteQuery() datasource method.

However, you have to set range in executeQuery() method and call it on your View button clicked method for filtering data. There are lot of stuff over internet for filtering data on form.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sir, i have already filter the data. My concern is that whenever i will open my form ,Grid should be empty.

Was this reply helpful? Yes No
Suggested answer

Satish kakileti 185 on at

Like (0)

Report
Copy link

Link copied!

Hi Rashmi,

Try this,

form declaration:

declare fromdateGlobal, todateGlobal with dateNull;

Datasource execute query method: this.query().datassource(XXX).addrange(datefield).value(daterange with global variables declared in form declaration);

In View button clicked method:

Assign entered dates to global variables;

call datasource execute query method.

Hope this helps.

Thanks and regards,

Satish Kakileti.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

RashmiAx,

You can achieve empty grid by adding any dummy range in ExecuteQuery() against what no data appears. Now on button clicked event add actual range and get your desired data in grid.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

You can use a temporary table, and after that you want to do with the data, you can insert this values into a regular table.

Like this: community.dynamics.com/.../ax-2012-using-temporary-table-as-form-s-datasource

you need to create the method in the table or in the form to pull the data you need, then insert the data into the temporary table, and call this method in the button you want to use in the form, every time they open the form the grid will be empty until the user click the button.

Was this reply helpful? Yes No
Suggested answer

Rohin 4,624 on at

Like (0)

Report
Copy link

Link copied!

Hello RashmiAxm

That what i suggested you before, you can acheive it by passing null date range by default in executeQuery() method of datasource .

And this exceuteQuery() method is called when form opens so it will set range on your form automatically which cause your grid empty on form.

Was this reply helpful? Yes No