Eclipse Community Forums: BIRT

Help

Home

Home » Eclipse Projects » BIRT » Cross-tab issues

Show: Today's Messages :: Show Polls :: Message Navigator

Cross-tab issues [message #765020]

Tue, 13 December 2011 04:22

Angel28
Messages: 4
Registered: December 2011

Junior Member

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 83 times)

Report message to a moderator

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

Tue, 13 December 2011 12:47

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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.

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Sun, 18 December 2011 03:03

Angel28
Messages: 4
Registered: December 2011

Junior Member

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.

Report message to a moderator

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

Mon, 19 December 2011 11:10

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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.

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Tue, 20 December 2011 01:17

Angel28
Messages: 4
Registered: December 2011

Junior Member

No Message Body

Report message to a moderator

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

Tue, 20 December 2011 01:19

Angel28
Messages: 4
Registered: December 2011

Junior Member

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()?

Report message to a moderator

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

Tue, 20 December 2011 11:08

Jason Weathersby
Messages: 9167
Registered: July 2009

Senior Member

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()?

Jason Weathersby

BIRT Exchange

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:24:39 EST 2013