Skip to main content

Notifications

Dynamics 365 Community / Forums / Finance forum / to make the report to ...
Finance forum
Answered

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

Posted on by 1,429
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,429 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,651 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 2,586 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 3,191 Super User 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,429 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,429 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 3,191 Super User 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 4,429 User Group Leader 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 2,586 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,429 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 

Helpful resources

Quick Links

Upcoming TechTalk: Copilot Capabilities…

Review the Copilot features that are currently available in Dynamics 365 Finance…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,414 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,394 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans