Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Cross-tab issues
Cross-tab issues [message #765020] Tue, 13 December 2011 09:22 Go to next message
Angel28  is currently offline 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.
Re: Cross-tab issues [message #765256 is a reply to message #765020] Tue, 13 December 2011 17:47 Go to previous messageGo to next message
Jason Weathersby is currently offline 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.
Re: Cross-tab issues [message #767526 is a reply to message #765020] Sun, 18 December 2011 08:03 Go to previous messageGo to next message
Angel28  is currently offline 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.
Re: Cross-tab issues [message #768127 is a reply to message #767526] Mon, 19 December 2011 16:10 Go to previous messageGo to next message
Jason Weathersby is currently offline 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.
Re: Cross-tab issues [message #768432 is a reply to message #768127] Tue, 20 December 2011 06:17 Go to previous messageGo to next message
Angel28  is currently offline Angel28
Messages: 4
Registered: December 2011
Junior Member
No Message Body
Re: Cross-tab issues [message #768434 is a reply to message #765020] Tue, 20 December 2011 06:19 Go to previous messageGo to next message
Angel28  is currently offline 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()?
Re: Cross-tab issues [message #768694 is a reply to message #768434] Tue, 20 December 2011 16:08 Go to previous message
Jason Weathersby is currently offline 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()?
Previous Topic:Drag and Drop function for Bird
Next Topic:BIRT Report Designer And JDBC Drivers
Goto Forum:
  


Current Time: Wed Sep 03 04:47:23 GMT 2014

Powered by FUDForum. Page generated in 0.01877 seconds