Eclipse Community Forums: BIRT

Home » Archived » BIRT » Cross-tab issues

Tue, 13 December 2011 04:22

Eclipse User

I am using eclipse 3.4.2 and BIRT 2.3.2. In a report, I have one dataSet. I have to display a table, a chart and a crosstab. In the fetch(), of the dataSet I have to insert the values of the query in a table in the database. So I am inserting the data in the database and displaying the report.

The problem is when I am adding the crosstab the insert query is not executing. When I remove the crosstab the insertion works fine. I am doing nothing with crosstab script. I am stuck with this for so long.

Please help me solve this problem. I am attaching the design file also.

Attachment: new_report.rptdesign
(Size: 230.51KB, Downloaded 308 times)

Re: Cross-tab issues [message #765256 is a reply to message #765020]

Tue, 13 December 2011 12:47

Eclipse User

When it does work (without crosstab) are you tying the data set to a
table? If so can you put the same table above the crosstab and hide it
using visibility?

Jason

On 12/13/2011 4:22 AM, Angel28 wrote:
> I am using eclipse 3.4.2 and BIRT 2.3.2. In a report, I have one dataSet. I have to display a table, a chart and a crosstab. In the fetch(), of the dataSet I have to insert the values of the query in a table in the database. So I am inserting the data in the database and displaying the report.
>
> The problem is when I am adding the crosstab the insert query is not executing. When I remove the crosstab the insertion works fine. I am doing nothing with crosstab script. I am stuck with this for so long.
>
> Please help me solve this problem. I am attaching the design file also.

Re: Cross-tab issues [message #767526 is a reply to message #765020]

Sun, 18 December 2011 03:03

Eclipse User

I tried to reply several times. But there was problem with my login. Now I am back Smile

I have tried putting the cross-tab with and without the table. Same result. But for my report, I want the cross-tab, in the table, below a chart.

Hoping to get my problem fixed.

Re: Cross-tab issues [message #768127 is a reply to message #767526]

Mon, 19 December 2011 11:10

Eclipse User

Can you move the insert to a different script event. My guess is with
2.3.2 the fetch is being fired earlier do to pre-calculations for the cube.

Jason

On 12/18/2011 3:04 AM, Angel28 wrote:
> I tried to reply several times. But there was problem with my login. Now
> I am back :)
> I have tried putting the cross-tab with and without the table. Same
> result. But for my report, I want the cross-tab, in the table, below a
> chart.
> Hoping to get my problem fixed.

Re: Cross-tab issues [message #768432 is a reply to message #768127]

Tue, 20 December 2011 01:17

Eclipse User

No Message Body

Re: Cross-tab issues [message #768434 is a reply to message #765020]

Tue, 20 December 2011 01:19

Eclipse User

I am inserting the rows which are just fetched from open(). Can I use these row values in other script event? Is the row values accessible in another script event other than fetch()?

Re: Cross-tab issues [message #768694 is a reply to message #768434]

Tue, 20 December 2011 11:08

Eclipse User

If you tie the data set to a table (The table can be hidden) you can use
the onCreate script of the table row. Use:

this.getRowData().getColumnValue("columnname");

Jason

On 12/20/2011 1:19 AM, Angel28 wrote:
> I am inserting the rows which are just fetched from open(). Can I use
> these row values in other script event? Is the row values accessible in
> another script event other than fetch()?

Previous Topic:	Drag and Drop function for Bird
Next Topic:	BIRT Report Designer And JDBC Drivers

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 20:49:38 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter