Multiple datasets are used in the birt report ., Birt report multiple data
This problem has been plagued for a few days and has not been found. Due to work needs, two datasets and two tables have been created. There is no problem between the first dataset and the table. However, if the second dataset is dragged to the table, it will be unavailable unless it is dragged out of the table. A friend said to drag a grid and then drag several tables into the grid, so that multiple datasets can be used. This greatly reduces the difficulty of writing an SQL statement, because you can write several brief SQL statements.
Write SQL in birt. If case when then end SQL is used in SQL statements, it is very easy to report errors, especially for statements with group by, be sure to pay attention to the field of case when.
At present, we have encountered a very strange problem, that is, the results queried in the database are different from those previewed in the birt, not only how many results are different, even data is different. After restarting the report tool several times and checking several SQL statements, no problem is found. The same SQL statement produces different results, which is unexpected.
I hope this short paragraph can help people who need help, and I also hope that the birt, the big God of mine, can help me solve this problem. Thank you!