Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

(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 .
Categories:
Development / Customization / SDK
  • 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 3,904 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 4,815 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,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 4,815 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 7,962 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 3,904 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 

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans