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 Report unable to do automatic data set binding

engineero73

<div> </div>
Hello everyone,
 
I have a BIRT report that I've attached called OR14.rptdesign.
 
It's a very basic report in which I've created one data source with two data sets. 
 
I'm having a problem with dragging and dropping one field (called SHIP_DATE) from a data set (called PW_OEOO2_L1) into a table detail row cell for a column called Ship-Date. 
 
What I'm seeing is...when I try to drag and drop the SHIP_DATE field into the Ship-Date table detail row cell, I get a circle with a diagonal line through it, indicating that I can't do that.
 
However, all fields in the other data set (PW_C_WHSE_L1), I have no problems with dragging and dropping any of the five fields that are in that data set.

Find more posts tagged with

Comments

Shweta Parihar

The reason you are not able to add column "SHIP_DATE" from PW_OEOO2_L1 is because the table binding is set to dataset
PW_C_WHSE_L1 and you can only bind single dataset to a table.
What you can do is, create a joined data set joining the dataset from which you want to pull values to the table and then bind that dataset to your table.

engineero73

I will have a need to use data from more than two tables and I'm not sure if I will be able to join all of these tables with a SQL join. 
 
I'm thinking of binding the table to a stored procedure and then dragging and dropping data from that stored procedure as well as other SQL queries. Would that work?

Shweta Parihar

Yes, that will be even better, as if required you can even use the same stored procedure for other reports too.

engineero73

Thanks Shweta