You’re offline. This is a read only version of the page.
Announcements
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?
#1
André Arnaud de Cal...
294,110
Super User 2025 Season 1
#2
Martin Dráb
232,866
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
