45
Hi Team,
I want to create a single report from different module (Sales Quotation and Project Items Trans). the query filter also should come as per the parameter value. Is it possible to have dynamic query as per the parameter value.
Kindly see the below sample.
Hi Bibin,
As per my understanding ye you can create dynamic query via code, you can create two separate methods for Sales quotation and Project Item trans with the respective dynamic query logic.
On the process report you can call the respective methods based on the parameter selection.
Thanks,
Girish S.
My key objective was to set different query as per the parameter selection on the SysQueryForm. Kindly see the below example.
Example
Parameter 1 : Sales Quotation(Sales and Marketing)
Parameter 2 : Material Issue(Project)
Query filter should change as per the parameter selection. If Parameter 1 is selected, the query should use the table Sales Quotation otherwise Project Item Transaction table.
As per your explanation, I understand that, I have to use the same query and assign different data source. Is there any example you can give for the quick understanding??
Thank you.
Hi Bibin,
Can you explain what exactly you want to achieve? A report has one query. A query can have multiple data sources (tables). Is your report requirement about querying data to be summarized in one report? Or do you try to get two different reports in one?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (