Skip to main content

Notifications

Announcements

Forum Structure Changes Complete – Update Your Subscriptions!
News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / to make the report to ...
Finance | Project Operations, Human Resources, ...
Answered

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

(2) ShareShare
ReportReport
Posted on by Dineshkarlekar 1,457
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 .
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,457 on at
    to make the report to open all the records without contract class
    hi every one ,
    Thanks for reply ,
    I have the report , with query but i am having issue with getting the vendor account number from ledger journal trans as i have to bring the account number value from ledger dimension , can you please suggest me how can i get the vendor account number and name  from the ledger journal trans in my report .
  • Verified answer
    Ali Zaidi Profile Picture
    Ali Zaidi 4,657 on at
    to make the report to open all the records without contract class

    It depends on the need. You can build a comprehensive AOT query.

     

    This AOT query needs to be defined as an attribute at the top of the Data Provider class.

     

    SRSReportQueryAttribute  [SRSReportQueryAttribute(queryStr(YourQueryName))]

     

    On run time, this AOT query results in the Select button. Where you can apply different filters.

     

     

     

    In this case, parameter selection makes it easier for end users to define parameters in data contract classes.

     

    It depends on the need.

     

    For your question: With the help of AOT queries, we can apply filters to reports without defining data contract-based parameters. 

     

    Regards

    Ali Raza Zaidi

  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 5,955 Super User 2024 Season 2 on at
    to make the report to open all the records without contract class
    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
  • Layan Jwei Profile Picture
    Layan Jwei 7,204 Super User 2024 Season 2 on at
    to make the report to open all the records without contract class
    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
     
    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.
     
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,457 on at
    to make the report to open all the records without contract class
    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
     
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,457 on at
    to make the report to open all the records without contract class
    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
  • Layan Jwei Profile Picture
    Layan Jwei 7,204 Super User 2024 Season 2 on at
    to make the report to open all the records without contract class
    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
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 9,413 Super User 2024 Season 2 on at
    to make the report to open all the records without contract class
    Hi,
     
    In this case i think you can use the report Query based.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 5,955 Super User 2024 Season 2 on at
    to make the report to open all the records without contract class
    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
     
  • Dineshkarlekar Profile Picture
    Dineshkarlekar 1,457 on at
    to make the report to open all the records without contract class
    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Forum Structure Changes Complete – Update Your Subscriptions!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,900 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,275 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans