Finance | Project Operations, Human Resources, ...

Add range to second dataset in query report

(0) Share

Report

Posted on by AI-26111618-0

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 ?

All responses (2)

Answers (0)

Sort by

Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

I think you must add this :

SRSReportHelper::addParameterValueRangeToQuery( reportQuery,tablenum(<<YourSecondTable>>), fieldnum(<<YourSecondTable>>, <<Field>>), <<YourValue>>);

Best Regards,

Mohamed Amine MAHMOUDI
Suggested answer

Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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