SSRS Reports With parameters

(0) Share

Report

Posted on by AliViretechnologies

1,210

hi,

I have a report with parameters, I want to add a new parameter of type checkbox, and i also want to add date criteria i.e start date and end date, what i explore i find contract class for this purpose for adding parameters, but my question is that from where I'm relating a column name of sql with local variable. following is my function

//Declaration Method

#define.ParameterInclReversed('IncludeReversed')
NoYes includeReversed;

//===========================

Contract Class:

[
    DataMemberAttribute('IncludeReversed'),
    SysOperationLabelAttribute(literalstr("@SYS78625")),
    SysOperationHelpTextAttribute(literalstr("@SYS78627"))
]
public boolean parmIncludeReversed(boolean _includeReversed = includeReversed)
{
    includeReversed = _includeReversed;
    return includeReversed;
}

//================================

DP class:(where report is processing)

if (contract.parmIncludeReversed())
    {
        includeReversed = NoYes::Yes;
    }

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

dolee 11,279 on at

Like (0)

Report

Hi,

Base on my understanding of your question, you need to declare the table buffer/variable in your class.

For example, in the DP class you'd want to do:

-----------------------------

DP class:

MyTable myTable; // Declare the table record buffer/variable

ttsbegin;

// You'd want to get the table buffer you want to update first.

select firstonly forupdate myTable

where myTable.recId == <recId of the target table>;

if (contract.parmIncludeReversed())

{

myTable.includeReversed = NoYes::yes;

myTable.update();

}

ttscommit;

-----------------------------

You might also want to add a try/catch blog as well, but it's another topic.

Regards

Was this reply helpful? Yes No
Rachit 4,015 User Group Leader on at

Like (0)

Report

Why would you like to relate a data contract parameter with an SQL column name?

A data contract variables acts as an input/filters to drive your report. You might consider using a query in your data contract if you want to apply the filters on some table/field.

Thanks,

Rachit Garg

Was this reply helpful? Yes No
Ali Zaidi 4,657 on at

Like (0)

Report

Extended data Type rendered as check boxes, combo boxes or radio buttons. You can find these properties when you right click on extended data type of enum type, even enum also have these properties. based on these properties you can render these extended data Types/ enum as check boxes, combo or radio button. For date time, you can use TransDate Extended data Type. Like as

public class InventABCContract implements SysOperationValidatable

{

// TransDate while used as

TransDate fromDate;

TransDate toDate;

InterestPct interest;

// AbCModel Rendered as drop down on Report dialog

ABCModel abcModel;

}

Inside Data Provider class you can get these parameter with reference of Data Contract Class and then query on Dynamics Ax tables like.

InventABCContract contract;

SalesLine _salesLine;

contract = this.parmDataContract() as InventABCContract;

inventABCUpdate.parmFromDate(contract.parmFromDate());

inventABCUpdate.parmToDate(contract.parmToDate());

SalesLine _salesLine;

while select * from _salesLine

where _salesLine.createdTransactionId >= parmToDate()

&& _salesLine.createdTransactionId <<=contract.parmFromDate();

{

// populate temp table

}

Was this reply helpful? Yes No
AliViretechnologies 1,210 on at

Like (0)

Report

thankx, everybody its very helpful now I want to ask that I want drop down list for the financial dimension set Fund_Dept-MainAccount Beginning 101.20010.61010 Ending 101.20010.99999 what should i need to do.

for testing purpose i was using in class declaration.

//====Financial dimension fields.

String30 bfinancialdim;

String30 efinancialdim;

Was this reply helpful? Yes No
dolee 11,279 on at

Like (0)

Report

Hi,

- For Financial Dimension Set, you can refer to General Ledger -> Common -> Trial balance Listpage. On the List page there is a "Financial dimension set" combobox which filter financial dimension set for selection only.

- I think 101.20010.xxxxx are main accounts? Then you just add two parameters, one for the minimum/starting main account and another one for maximum/ending main account?

Regards

Was this reply helpful? Yes No

Community site session details

SSRS Reports With parameters

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

SSRS Reports With parameters

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates