Microsoft Dynamics AX (Archived)

SSRS Report Parameters Hidden

(0) Share

Report

Posted on by Community Member

SSRS Report Parameters Hidden

Still not visible after

public boolean showQueryValues(str parameterName)
{
return true;
}

added to controller class

How can I get the parameters from my query to be visible?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

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

Like (0)

Report

A wild guess - do you have DynamicFilters set to yes (on your report datasource)?

Otherwise please explain what kind of report are you talking about (query-based, RDP-based) and what's the problem. Do you miss some particular fields (which ones?), or don't you even have the query selection button?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, DynamicFilters set to yes.

Using RDP.

I just want to see parameters and cannot.

Was this reply helpful? Yes No
Martin Dráb 237,959 Most Valuable Professional on at

Like (0)

Report

Is your RDP class associated with any query?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes

[

SRSReportParameterAttribute(classStr(AMPHMaterialShortageContract)),

SRSReportQueryAttribute(queryStr(AMPHMaterialShortageReport))

]

class AMPHMaterialShortageDP extends SRSReportDataProviderBase

{

AMPHMaterialShortageContract contract;

AMPHMaterialShortageReportTmp materialShortageReportTmp;

BOM BOM;

BOMVersion BOMVersion;

InventSum inventSum;

InventDim inventDim;

InventItemInventSetup inventItemInventSetup;

InventItemPurchSetup inventItemPurchSetup;

InventLocation inventLocation;

ProdTable prodTable;

ReqItemTable reqItemTable;

ReqPO reqPO;

ReqTrans reqTrans, reqTransReceipt;

ReqTransCov reqTransCov;

InventSiteId inventSiteId;

LeadTime leadTime;

Qty onhand, onhandRec;

RecId maxRecId, lastRecId;

boolean onHandRecord;

}

[SysEntryPointAttribute]

public void processReport()

{

Query q;

    QueryRun qr;

    QueryBuildRange qbr;

QueryBuildDataSource qbdsReqPlanVersion;

QueryBuildDataSource qbdsReqPO;

QueryBuildDataSource qbdsReqTrans;

QueryBuildDataSource qbdsProdTable;

contract = this.parmDataContract() as AMPHMaterialShortageContract;

q = new Query(queryStr(AMPHMaterialShortageReport));

qbdsReqPlanVersion = q.dataSourceTable(tableNum(ReqPlanVersion));

qbdsReqPlanVersion.addRange(fieldnum(ReqPlanVersion, ReqPlanId)).value(contract.parmPlanId());

qbdsReqTrans = q.dataSourceTable(tableNum(ReqTrans));

qbdsReqTrans.addRange(fieldnum(ReqTrans, ReqDate)).value(strFmt('<%1', Date2Str(contract.parmCutoffDate()+1,213,

DateDay::Digits2,DateSeparator::Hyphen,DateMonth::Digits2,DateSeparator::Hyphen,DateYear::Digits4)));

qr = new QueryRun(q);

while(qr.next())

    {

    reqTrans = qr.get(tableNum(ReqTrans));

reqTransCov = qr.get(tableNum(ReqTransCov));

this.populateTmpTable(reqTrans, reqTransCov);

}

}

Was this reply helpful? Yes No
Verified answer

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

Like (0)

Report

If you played with the report before adding the query, try refreshing the dataset. You might also see an old, cached version of the dialog.

By the way, are you aware of the fact that your RDP class don't even try to use the query object? If users were able to add filters, it wouldn't have any effect anyway.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

OK, thanks for the help.

Was this reply helpful? Yes No