Requirement:

Often, we are required to construct table view dynamically based on the reporting parameter entered at runtime.  One approach is writing procedure to create view from parameter passed from AD_PInstance table.

[metaslider id=”292″]

 

Alternatively, a window can be built consisting of all the required parameter which in turn is joined to the table views for reporting.

In Practical terms:

1. Create a window(ParameterTable) containing Client, Organisation and all required Parameters

Selection_066

 

2. The reporting Print Format should be based on view(s) with table join to the window table.

For example, the view maybe something like:

CREATE OR REPLACE VIEW Dynamic_View AS 
 ( SELECT * FROM Fact_Acct f, ParameterTable p WHERE f.dateacct = p.dateacct)

 

How to report on dynamic View using parameter in ADempiere window