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)

Suggested answer

Waed Ayyad 6,493 Super User 2024 Season 2 on at

Like (0)

Report

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 10,169 Super User 2024 Season 2 on at

Like (0)

Report
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