to make the report to open all the records without contract class

(1) Share

Report

Posted on by Dineshkarlekar

1,836

How can i make the report without contract class but i want the records to filter in report .can u guys please guide me on this .

I have the same question (0)

All responses (12)

Answers (1)

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

Like (0)

Report

Hi Dinesh,

Can you please explain more? Are you talking about reports?

What is the exact filtering you would want to do?

Do you want for example query filter instead of contract filter? Or you want the filter to be inside the original class?

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (0)

Report

hi , thanks for reply ,the dialog should open like this and filter by purchase order and my report will bring all the records based on query .i mean the report should only have records to filter .

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (1)

Report
below is my sql query ,

SELECT EH_POAdvPayment,PURCHIDRANGE,PURCHTABLE.ORDERACCOUNT,sum(purchline.LineAmount), PURCHTABLE.CURRENCYCODE,LedgerJournalTrans.EXCHRATE,LedgerJournalTrans.TRANSDATE FROM LedgerJournalTrans join PURCHTABLE on PURCHTABLE.PURCHID = LedgerJournalTrans.PURCHIDRANGE join purchline on purchline.PURCHID = PURCHTABLE.PURCHID --join VendPackingSlipTrans on VendPackingSlipTrans.INVENTTRANSID = purchline.INVENTTRANSID Where EH_POAdvPayment = 1 group by EH_POAdvPayment,PURCHIDRANGE,PURCHTABLE.ORDERACCOUNT ,PURCHTABLE.CURRENCYCODE,LedgerJournalTrans.EXCHRATE,LedgerJournalTrans.TRANSDATE

i also want to join the vendpackingsliptrans to get the sum of amount mst against purch id

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (2)

Report
Hi Dinesh,

In SSRS report you can create Data Provider SSRS report without using Contract class (you'll not have parameters on your report), and also you can add Query to your report by defining the Query on your DP class as the following:

[ SRSReportQueryAttribute(queryStr(YourQuery)) ] Public class YourDPClass extends SrsReportDataProviderBase

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,396 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

In this case i think you can use the report Query based.

https://d365ffo.com/2022/08/06/ax-d365fo-create-a-simple-ssrs-report-based-on-a-query-step-by-step/

Best regards,

Mohamed Amine MAHMOUDI

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

Like (1)

Report

Hi Dinesh,

The picture is not appearing, can you send it it again?

but if u need to use query filter (Record to include), then you need to do the following;
1. set dynamics filter to true in the parameters node
2. decorrate your class with SRSReportQueryAttribute [SRSReportQueryAttribute(queryStr(YourQueryName))]

Thanks,
Layan Jweihan

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (1)

Report

hi , yes i want records to include but do i have to use controller class for this or i only need dp class for this , please guide me on this , thanks for reply ,

thanks ,

Regards,

Dinesh

Was this reply helpful? Yes No
Dineshkarlekar 1,836 on at

Like (1)

Report
hi ,

everyone

can you please help me out to convert this query into qbds query .
SELECT EH_POAdvPayment,PURCHIDRANGE,PURCHTABLE.ORDERACCOUNT,sum(purchline.LineAmount), PURCHTABLE.CURRENCYCODE,LedgerJournalTrans.EXCHRATE,LedgerJournalTrans.TRANSDATE FROM LedgerJournalTrans join PURCHTABLE on PURCHTABLE.PURCHID = LedgerJournalTrans.PURCHIDRANGE join purchline on purchline.PURCHID = PURCHTABLE.PURCHID Where EH_POAdvPayment = 1 group by EH_POAdvPayment,PURCHIDRANGE,PURCHTABLE.ORDERACCOUNT ,PURCHTABLE.CURRENCYCODE,LedgerJournalTrans.EXCHRATE,LedgerJournalTrans.TRANSDATE

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

Like (0)

Report

Hi Dinesh,

If you already have the controller why do u want to delete it? u can leave it. I explained in the previous reply what do you need to.

You also asked this question a while ago

https://community.dynamics.com/forums/thread/details/?threadid=41bba432-0da6-ee11-be37-00224827ed84

Also what do u mean convert it to qbds query? Do u mean AOT query?

Just create an AOT query with your desired result and add it to the attribute.

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (1)

Report
i Dinesh,

For your question " do i have to use controller class for this or i only need dp class for this , please guide me on this , thanks for reply ,"

Are you working on report? if you're working in SSRS report and you are using DP class so as I answered you:

In SSRS report you can create Data Provider SSRS report without using Contract class (you'll not have parameters on your report), and also you can add Query to your report by defining the Query on your DP class as the following:

[ SRSReportQueryAttribute(queryStr(YourQuery)) ] Public class YourDPClass extends SrsReportDataProviderBase

Was this reply helpful? Yes No