to get data from 2 qbds queries in report

(1) Share

Report

Posted on by Dineshkarlekar

1,836

I have 2 qbds queries in report i need to the transaction both queries , how can i get the data in report and merge them together

please anyone guide me on this , below are my two queries .

i want to fetch data from both queries .

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Dineshkarlekar 1,836 on at

Like
a
(0)

Report
Copy link

Link copied!
SELECT VendPackingSlipTrans.PackingSlipId, PurchLine.PurchId, PurchLine.ItemId, PurchLine.InventTransId, VendPackingSlipTrans.Ordered, VendPackingSlipTrans.Qty FROM PurchLine JOIN VendPackingSlipTrans ON PurchLine.InventTransId = VendPackingSlipTrans.InventTransId AND ((VendPackingSlipTrans.DeliveryDate>={ts '2024-02-01 00:00:00.000'} AND VendPackingSlipTrans.DeliveryDate<={ts '2024-02-29 00:00:00.000'})) WHERE PurchLine.DATAAREAID = 'SA01' GROUP BY VendPackingSlipTrans.PackingSlipId, PurchLine.PurchId, PurchLine.ItemId, PurchLine.InventTransId, VendPackingSlipTrans.Ordered, VendPackingSlipTrans.Qty SELECT PurchLine.PurchId, PurchLine.ItemId, PurchLine.InventTransId,SUM(VendInvoiceTrans.Qty), SUM(VendInvoiceTrans.LineAmount), SUM(VendInvoiceTrans.LineAmountTax) FROM PurchLine JOIN VendInvoiceInfoLine ON PurchLine.PurchId = VendInvoiceInfoLine.OrigPurchId JOIN VendInvoiceJour ON VendInvoiceInfoLine.ParmId = VendInvoiceJour.ParmId JOIN VendInvoiceTrans ON VendInvoiceJour.InvoiceId = VendInvoiceTrans.InvoiceId AND VendInvoiceJour.numberSequenceGroup = VendInvoiceTrans.numberSequenceGroup and VendInvoiceTrans.PURCHASELINELINENUMBER = PurchLine.LINENUMBER and VendInvoiceTrans.ITEMID = PurchLine.ITEMID --and VendInvoiceTrans.Qty > 0 AND ((VendInvoiceTrans.INVOICEDATE>={ts '2024-02-01 00:00:00.000'} AND VendInvoiceTrans.INVOICEDATE<={ts '2024-02-29 00:00:00.000'})) WHERE PurchLine.DATAAREAID = 'SA01' GROUP BY PurchLine.PurchId, PurchLine.ItemId, PurchLine.InventTransId,VendInvoiceTrans.PURCHASELINELINENUMBER

Was this reply helpful? Yes No
Martin Dráb 240,002 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Please tell us more about what you mean by "I have 2 qbds queries in report".

Was this reply helpful? Yes No
Layan Jwei 8,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

I'm not sure I understood you correctly. Do you mean your query has two datasources and you are trying to get data from those datasources in the report?
if this is the case, then you can do this in the RDP class:
while (queryRun.next()) { CustTrans custTrans = queryRun.get(tablenum(CustTrans)) as CustTrans ; //1st datasrouce table CustTable custTable = queryRun.get(tableNum(CustTable)) as CustTable ; //2nd datasource table //add your logic }

if that's not the case, then please explain more.

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Waed Ayyad 9,212 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

What do you mean by 2 qbds? Do you have 2 DataSources on your query?

Thanks,
Waed Ayyad

Was this reply helpful? Yes No
Layan Jwei 8,271 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Is your question answered? If yes, then please verify the answers that helped.

Was this reply helpful? Yes No