Home » Archived » BIRT » problem in binding data source to a table from BIRT library
problem in binding data source to a table from BIRT library [message #899729] |
Thu, 02 August 2012 02:49  |
Eclipse User |
|
|
|
My requirement is to standardise look for table elements to be used in report.
To achieve it, I created a table named newTable in library with header, footer and detail rows with pre-defined background colour and font. There is no datasource and data set attached to it.
The next step is to use newTable in report. So I drag it from library into the reports.The table displays the symbol "table + sign of chain". I have defined data source and data set in the report which I want to bind to newTable from library. I added dataset name in "Binding" tab.
When I try to add dataset element to table its not getting displayed; also symbol changes "table + sign of chain + yellow pencil". What is the meaning of this?
Also all the elements (data, crosstab,table) from "Insert" option are also disabled.
Any suggestions to achieve the requirement.
|
|
| | |
Re: problem in binding data source to a table from BIRT library [message #900094 is a reply to message #900056] |
Fri, 03 August 2012 17:48   |
Eclipse User |
|
|
|
I am not to fond of how we have this implemented today, but once you add
the table from the library, bind the data set in the binding tab. Next
right click on your data items in the table and select "Change Data
Column" to specify one of your bound data set columns. See attached image.
Jason
On 8/3/2012 1:34 PM, g g wrote:
> Thanks Jason.
>
> I created TableTheme with NewStyle1,NewStyle1 in the library. These
> styles are available on right click (Style->edit style) of header,
> footer or detail row of library table. I edited footer and detail row
> styles. These library tables have 6 column(fixed by design)
>
> Now I created new report with one datasource and dataset. Then dragged
> table from ResourceExplorer-> Report Item -> table. It appears with
> cross (x) sign with message "The table "NewTable" must be able to access
> one dataset.
>
> So I selected dataset in Binding tab. But I am not able to map the
> columns from dataset to table. Can we bind the dataset to library table
> from report?
>
> [The concept is to give standard look to required report items - charts,
> tables, list using library. The developers will then use standard
> library items and bind required data. e.g. I have created library with
> report items as PieChart 2D with slice and line chart 2DDepth. I defined
> look part for the chart in library. Then I create report and define
> datasource, dataset in it. I bind chart data using "select data" option
> of chart. I was trying to repeat the same behaviour for tables as well,
> but was not successful as I can't bind the data outside library.]
>
>
|
|
| | | | | | | | |
Re: problem in binding data source to a table from BIRT library [message #905952 is a reply to message #901125] |
Fri, 31 August 2012 07:06   |
Eclipse User |
|
|
|
Hi Jason,
I started working on table library by putting table of vaious sizes (ie no. of columns) in it.
Also I have tested __document part u have mentioned and its working for our requirement.
If I have to create tables of choice for either 1/2/3 headers, then I have observed that since grouped column inputs are mandatory, I have to create 3 separate tables with no. of headers as 1/2/3 headers and 4th table for group of users who do not require the headers at all.
So I have to create 4 tables for a given table size in library. Is their any other way to achieve this requirement in library?
Also if I create 3 tables say with size 10,20,30 columns in library (each with have 1-header/2-header/3-header/no-header version).
If I use column-10 table with 2 headers to create the report with 7 columns , I face following 2 problems.
1. Once I do data binding for a column, I can change the binding; but can't delete it.
2. If I hide the column instead as I do not have permission to delete it, it still gives "value expression" errors for columns not used/hidden and report works fine.
Is there any way, by which I can atleast I can delete binding to the library-table once its done?
Is it correct to use the library table of 10 columns when table of 7 columns is required in report and .rptdesign gives errors for "value expression"?
|
|
|
Re: problem in binding data source to a table from BIRT library [message #906121 is a reply to message #905952] |
Fri, 31 August 2012 12:50   |
Eclipse User |
|
|
|
I am not certain what you mean by this:
> If I have to create tables of choice for either 1/2/3 headers, then I
> have observed that since grouped column inputs are mandatory, I have to
> create 3 separate tables with no. of headers as 1/2/3
I do know of a way to delete the bindings. If you can change them why
not just put in something like "" for the expression?
Jason
On 8/31/2012 7:06 AM, g g wrote:
> Hi Jason,
>
> I started working on table library by putting table of vaious sizes (ie
> no. of columns) in it.
> Also I have tested __document part u have mentioned and its working for
> our requirement.
>
> If I have to create tables of choice for either 1/2/3 headers, then I
> have observed that since grouped column inputs are mandatory, I have to
> create 3 separate tables with no. of headers as 1/2/3 headers and 4th
> table for group of users who do not require the headers at all. So I
> have to create 4 tables for a given table size in library. Is their any
> other way to achieve this requirement in library?
>
> Also if I create 3 tables say with size 10,20,30 columns in library
> (each with have 1-header/2-header/3-header/no-header version). If I use
> column-10 table with 2 headers to create the report with 7 columns , I
> face following 2 problems.
> 1. Once I do data binding for a column, I can change the binding; but
> can't delete it.
> 2. If I hide the column instead as I do not have permission to delete
> it, it still gives "value expression" errors for columns not used/hidden
> and report works fine.
>
> Is there any way, by which I can atleast I can delete binding to the
> library-table once its done?
>
> Is it correct to use the library table of 10 columns when table of 7
> columns is required in report and .rptdesign gives errors for "value
> expression"?
>
>
>
|
|
|
Re: problem in binding data source to a table from BIRT library [message #906271 is a reply to message #906121] |
Fri, 31 August 2012 21:33   |
Eclipse User |
|
|
|
Hi,
Sorry for the confusion.
What I meant by
> If I have to create tables of choice for either 1/2/3 headers, then I
> have observed that since grouped column inputs are mandatory, I have to
> create 3 separate tables with no. of headers as 1/2/3
is
If I want to create table of 10 columns, I have to create 4 tables in library as follows:
table with 10 columns, no header - no footer (plain table)
table with 10 columns, one group header - one group footer
table with 10 columns, two group headers - two group footers
table with 10 columns, three group headers - three group footers
Then users can use the table as per their requirement of no. of headers.
Since I have to create tables of 3-4 different column sizes and for each column size I have to create 4 tables in library (the mentioned above plain + 3 with various no. of group headers ), it will increase no. of tables in library 4-times. so is their any way to achieve this requirement differently?
|
|
|
Re: problem in binding data source to a table from BIRT library [message #908002 is a reply to message #906271] |
Tue, 04 September 2012 10:32  |
Eclipse User |
|
|
|
I do not know of a better way. The only thing I can think of is to use
the de api in script to add columns, but this can not be done to a table
from a library unless you modify the library too.
Jason
On 8/31/2012 9:33 PM, g g wrote:
> Hi, Sorry for the confusion.
>
> What I meant by
>> If I have to create tables of choice for either 1/2/3 headers, then I
> > have observed that since grouped column inputs are mandatory, I have to
> > create 3 separate tables with no. of headers as 1/2/3
> is If I want to create table of 10 columns, I have to create 4 tables in
> library as follows:
> table with 10 columns, no header - no footer (plain table)
> table with 10 columns, one group header - one group footer table with 10
> columns, two group headers - two group footers table with 10 columns,
> three group headers - three group footers
> Then users can use the table as per their requirement of no. of headers.
>
> Since I have to create tables of 3-4 different column sizes and for each
> column size I have to create 4 tables in library (the mentioned above
> plain + 3 with various no. of group headers ), it will increase no. of
> tables in library 4-times. so is their any way to achieve this
> requirement differently?
>
>
|
|
|
Goto Forum:
Current Time: Wed Jul 23 15:05:47 EDT 2025
Powered by FUDForum. Page generated in 0.07570 seconds
|