Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Add range to second da...
Finance forum
Suggested answer

Add range to second dataset in query report

Posted on by
Hello 
I created a report with two datasets based on query report, not RDP 
I added range to the first query through 
        SrsReportHelper::addParameterValueRangeToQuery(this.getFirstQuery(),            tableNum(RetailTransactionTableView),fieldNum(RetailTransactionTableView, receiptId),            SysQuery::value(dataTable.receiptId));
How to add range to the sencod query(second dataSet) , how to get the second query ?
 
 
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 5,169 Super User 2024 Season 2 on at
    Add range to second dataset in query report
    Hi,
     
    I think it is the same Query some you should use the same code but changing the table to your second DataSource table. Give it a try and tell me if it's working or not.
     
     
    Thanks
    Waed Ayyad
    If this helped, please mark it as "Verified" for others facing the same issue
     
  • Suggested answer
    Mohamed Amine Mahmoudi Profile Picture
    Mohamed Amine Mahmoudi 8,966 Super User 2024 Season 2 on at
    Add range to second dataset in query report
    Hi,
     
    I think you must add this : 
     
    SRSReportHelper::addParameterValueRangeToQuery(
    reportQuery,tablenum(<<YourSecondTable>>),
    fieldnum(<<YourSecondTable>>, <<Field>>),
    <<YourValue>>);
    Best Regards,
    Mohamed Amine MAHMOUDI

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans