firstDataSet has a simple query which returns a data that should be passed in the where clause of the secondDataSet. There are 2 tables in the layout (tied to each dataset), independent of each other. Below are the steps that I did,

firstDataSet has a simple query which returns a data that should be passed in the where clause of the secondDataSet. There are 2 tables in the layout (tied to each dataset), independent of each other. Below are the steps that I did,

firstDataSet has a simple query which returns a data that should be passed in the where clause of the secondDataSet. There are 2 tables in the layout (tied to each dataset), independent of each other. Below are the steps that I did,

firstDataSet has a simple query which returns a data that should be passed in the where clause of the secondDataSet. There are 2 tables in the layout (tied to each dataset), independent of each other. Below are the steps that I did,

There is a query (simple select query in which we will pass the report parameters like userName, appname) which should be executed first and the output of that query should be passed as a parameter in the open method of a birt report. select id from project where projectname='ABC' and userid = (params["userName"].value).toUpperCase() and app = (params["appname"].value).toUpperCase()
This id should be passed as a parameter to the main query in the Open method. I’m not sure whether we can execute the query in beforeOpen or is there any other way to achieve it.

I have a details report that would run on multiple records and display output. For example I have 3 records and the report will display output of 3 pages ( 1 record per page). We have a logic to change the color of a row conditionally as follows,

We have 2 report parameters start date and end date. If user enters start date then the end date should be calculated based on the start date and vice versa. For example