Microsoft Dynamics AX (Archived)

Add specific value to Query range

(0) Share

Report

Posted on by Oush Mi Ta

190

Hello,

I have created a query and added some fields as range (to appear as 'Records to include' on my FormDialogue).

How can I set a specif default value for the range without using a DataContract?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Community Member on at

Like (1)

Report
Copy link

Link copied!

Hi Oush,

What range or data you want to include?

Can you give more specific information?

Regards,

Sci

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report
Copy link

Link copied!

Just put your data in range fields and allow user to change it

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report
Copy link

Link copied!

Hi Oush Mi Ta,

What types of Query ranges you want. E.g: Enumeration, Expressions or you just want to display string/value from Query? So we can figure it and help you. Regards

Was this reply helpful? Yes No
Pradeep_Prakash 717 on at

Like (0)

Report
Copy link

Link copied!

Hi,

This means you are using a query based report. In the SSRS report design, under parameters for the range field. you can set the default value, to Yes or No.

Hope this answers to your question.

Regards,

Pradeep

Was this reply helpful? Yes No
Oush Mi Ta 190 on at

Like (0)

Report
Copy link

Link copied!

Actually I have created a query and used field quotationId as range. I am using a DP to run my report and before it is run I have the QuotationId in the 'Records to include' section. Currently when I am running the report I have to manually insert the quotationId for which I want to run the report . How can I get the value of the selected quotationId to be displayed by default in the textbox when running report for quotation '0001' for example?

Was this reply helpful? Yes No
Verified answer

Pradeep_Prakash 717 on at

Like (0)

Report
Copy link

Link copied!
Hi,

This would help you.

public void prePromptModifyContract() { //add a range in the report query SrsReportHelper::addParameterValueRangeToQuery(this.getFirstQuery(),tableNum(SSRSRepo
rtDemo),fieldNum(SSRSReportDemo, RecId),SysQuery::value(this.parmArgs().record().RecId)); }

Reagrds,
Pradeep

Was this reply helpful? Yes No
Oush Mi Ta 190 on at

Like (0)

Report
Copy link

Link copied!

Thanks. I actually wanted a specif value to be displayed in the textbox without the user selecting a value. This worked.

Was this reply helpful? Yes No