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

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

OK, thanks for the help.
Verified answer

Martin Dráb 233,529 Most Valuable Professional on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

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.
Community Member on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

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);

}

}
Martin Dráb 233,529 Most Valuable Professional on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

Is your RDP class associated with any query?
Community Member on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

Yes, DynamicFilters set to yes.

Using RDP.

I just want to see parameters and cannot.
Martin Dráb 233,529 Most Valuable Professional on at

Like (0)

Report

RE: SSRS Report Parameters Hidden

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?