nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Birt - Dataset picks wrong Database from Datasource

vex4vex

When using the All-In-One Birt;
Basically I've setup 2 databases (named a1 & a2) with the same table name ("t_1") in both DB's but with differing field names.
The "data sets" seem to only show the fields from the first database (i.e. "a1") with the named table even though the connection is set to the second database (i.e. "a2").

Also trying to use the database name as a precix isn't accepted by the parser.
I really believe this could be a bug but perhaps somebody has experienced this and has an answer?? This is an example where in real life I don't have the possibility to change the database structures.

Find more posts tagged with

Comments

kclark

Can you post the rptdesign?

vex4vex

Hi Thanks for looking into this.I've created a 'clean' report with just the 1 data source and a data set in which the issue occurs.Commented in the dataset is the WHERE clause where I try to use a column called POLPMID but the parser won't let me. If I 'just' look into the table that column will show up in both the preview and the collumns section of the data set.