Eclipse Community Forums: BIRT » How to display table based on dynamic table name

Home » Archived » BIRT » How to display table based on dynamic table name

How to display table based on dynamic table name [message #893378]

Tue, 03 July 2012 14:47

Eclipse User

Hi,

I have created data warehouse documentation and I'm using BIRT (2.6) as a presentation layer. I would like to give the user the opportunity to preview some rows from each table. However, I need to make this dynamically, because there is a lot of tables. I do have name of the table stored in database (FullTableName).

Is there a way how to use this a parameter and show table content to the user?

Thank you for any ideas.

Tomas

Re: How to display table based on dynamic table name [message #893791 is a reply to message #893378]

Thu, 05 July 2012 09:43

Eclipse User

Tomas

Are you saying that the parameter FullTableName, is the name of a table
that contains a field with names of other tables you want to show?

Jason

On 7/3/2012 2:47 PM, Tomas Greif wrote:
> Hi,
>
> I have created data warehouse documentation and I'm using BIRT (2.6) as
> a presentation layer. I would like to give the user the opportunity to
> preview some rows from each table. However, I need to make this
> dynamically, because there is a lot of tables. I do have name of the
> table stored in database (FullTableName).
> Is there a way how to use this a parameter and show table content to the
> user?
>
> Thank you for any ideas.
>
> Tomas

Re: How to display table based on dynamic table name [message #894445 is a reply to message #893791]

Mon, 09 July 2012 05:26

Eclipse User

Jason,

I do have name of the table stored in table (dw_description_table) in the column named physical_table_name. I also do have list of columns in table dw_description_column. Im attaching:
- sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
- screenshot of current report - it might help you to understand my problem better.

Regards,

Tomas

Attachment: dw_description.PNG
(Size: 30.28KB, Downloaded 242 times)
Attachment: Dw_Description.xlsx
(Size: 20.49KB, Downloaded 170 times)

[Updated on: Mon, 09 July 2012 05:27] by Moderator

Re: How to display table based on dynamic table name [message #895108 is a reply to message #894445]

Wed, 11 July 2012 13:16

Eclipse User

In the tables that you are looking up do they all have the same column
metadata?

Jason

On 7/9/12 5:26 AM, Tomas Greif wrote:
> Jason,
>
> I do have name of the table stored in table (dw_description_table) in the column named physical_column_name. I also do have list of columns in table dw_description_column. Im attaching:
> - sample data (Note that there is foreign key in dw_description_column (table_description_key) that links to table in dw_description_table)
> - screenshot of current report - it might help you to understand my problem better.
>
> Regards,
>
> Tomas
>

Re: How to display table based on dynamic table name [message #895211 is a reply to message #895108]

Thu, 12 July 2012 02:44

Eclipse User

Not sure I understand your question - all the metadata are stored in two tables, the metadata columns are the same for every table. Of course, values are different for every table as tables have different number of columns, different names of columns and different data types too.

Re: How to display table based on dynamic table name [message #895390 is a reply to message #895211]

Thu, 12 July 2012 12:44

Eclipse User

I assume you want to create the inner table in the report dynamically.
The only way I know how to do this is to call the data engine api in the
beforeFactory to make design changes. The beforeFactory or onPrepares
are the only location where the design can be altered in that fashion.
Take a look at this thread.

http://www.eclipse.org/forums/index.php/m/892804/

Jason

On 7/12/12 2:44 AM, Tomas Greif wrote:
> Not sure I understand your question - all the metadata are stored in two
> tables, the metadata columns are the same for every table. Of course,
> values are different for every table as tables have different number of
> columns, different names of columns and different data types too.

Previous Topic:	How to pass a parameter with in the page??
Next Topic:	Return a byte[] array from Java extension function to JavaScript

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 12:53:45 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter