Finance | Project Operations, Human Resources, ...

How to add validation on form data, to date and query value

(1) Share

Report

Posted on by CU21091228-0

230

Hi Team,

I am creating SSRS report.

In dialog i am having From data, To date and query with main account.

I have to add validation if Main account is not blank, and from date and to date is exceeds 1 years show the warning if click Ok button in dialog.

Please let me know how to show the validation warning.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at

Like (0)

Report

Assuming you have written your own controller class for the report, you should implement the 'preRunValidate' method on SrsReportRunController.
See InventJournalTransTransferController.preRunValidate() for an example of implementation.

In the method, you can open a dialog to prompt the user, and based on their response, you can modify the return container.

Edit: Try to do what Martin suggested, it's way prettier. Didn't think that you might have a contract class 😀

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,990 Most Valuable Professional on at

Like (1)

Report

From date and To date are dialog fields, most likely coming from a data contract. You can easily add the validation directly to the data contract by implementing SysOperationValidatable interface and validate() method. There you'll compare the values and show a warning and return false if requirements aren't met.

Main account is a query range, therefore you'll need to get the QueryBuildRange object from the query, call its value() method and check if it's empty.

(Moved from Dynamics AX forum.)

Was this reply helpful? Yes No
CU21091228-0 230 on at

Like (0)

Report
Below code i am using in controller class, validate method.

protected boolean validate() { boolean isValid = true; ABC_GeneralLedgerReportContract contract; contract = this.getDataContractObject(); Query query = this.getFirstQuery(); QueryBuildDataSource queryBuildDataSource = query.dataSourceTable(tableNum(MainAccount)); QueryBuildRange queryBuildRange = queryBuildDataSource.findRange(fieldNum(MainAccount, MainAccountId)); if (!queryBuildRange) { isValid = warning(""); } return isValid; }

In case i am not passing any value in MainAccountId, i am not able to get the warning.

Was this reply helpful? Yes No
Suggested answer

Layan Jwei 8,124 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

Since you have a contract class, then you can add the validation there in the validate method. And you also have query in your contract so you can access MainAccount

Check those links:

https://learn.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/how-to-add-validation-to-a-data-contract-class#adding-validation-to-rdp-data-contracts

https://msdaxerp.wordpress.com/2013/12/19/how-to-add-a-validate-method-in-ax-2012-ssrs-report/

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Layan Jwei 8,124 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your question answered? If yes, then please verify the answers that helped.

Was this reply helpful? Yes No