Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Row numbers for crosstab in a table
Row numbers for crosstab in a table [message #986652] Wed, 21 November 2012 05:02 Go to next message
Prashant Jha is currently offline Prashant Jha
Messages: 18
Registered: September 2011
Junior Member
I have a cross tab inside a table. The table is grouped on a 'x'. The cross tab is filtered on 'x' being equal to cross tab y being equal to 'x'... More precisely...
dimension["grp_table"]["CLASSFN1"] = row._outer["TABLENAME"]...
This filters the cross tab data to only the ones for which table is grouped for.
Now I need to show a column in Cross tab giving the row numbers. I had a computed column in the data set of data cube fetching the group number. But due to filtering, the row numbers now shown is all non - serial. How can I get serial group numbers.
I tried reportContext.setGlobalData() in createCrossTab script, incrementing the variable in OnCreateCell, and showing the value i.e reportContext.getGlobalVariable("rowN") but it always shows zero.. Any solutions.

Report message to a moderator

Re: Row numbers for crosstab in a table [message #986854 is a reply to message #986652] Wed, 21 November 2012 23:14 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
You're wanting to have a running count on the rows in each crosstab, 1-n? Or a running count on the embedded crosstabs? Can you make an example with the sample database that shows the problem you're having? You should be able to simply increment a variable in a dynamic text box or something, but maybe I'm misunderstanding.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Row numbers for crosstab in a table [message #986860 is a reply to message #986854] Thu, 22 November 2012 01:48 Go to previous messageGo to next message
Prashant Jha is currently offline Prashant Jha
Messages: 18
Registered: September 2011
Junior Member
I want a running count on the rows of each crosstab 1-n.

Report message to a moderator

Re: Row numbers for crosstab in a table [message #987160 is a reply to message #986860] Fri, 23 November 2012 17:02 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
Try this: In the initialize event, put something like rCount=0; Then, in the onCreate of the outer table's row, where the crosstab is embedded, put the same. Finally, in a dynamic text box, in your crosstab dimension area, increment rCount and display it. This should cause the rCount variable to increment for each row, then to reset for each new outer table group. Let me know.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1000754 is a reply to message #987160] Tue, 15 January 2013 06:38 Go to previous messageGo to next message
Elena M is currently offline Elena M
Messages: 11
Registered: January 2013
Junior Member
it is not work

I need to number a rows too..

can you help?

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1000999 is a reply to message #1000754] Tue, 15 January 2013 15:53 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
Can you attach an example, showing what you've done, that uses the sample database? This way, I can see exactly what you're looking at and modify your example.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1001775 is a reply to message #1000999] Thu, 17 January 2013 06:00 Go to previous messageGo to next message
Elena M is currently offline Elena M
Messages: 11
Registered: January 2013
Junior Member
maybe there are a standart solution (any typical steps?) to insert number rows in cross tab?

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1004184 is a reply to message #1001775] Tue, 22 January 2013 13:53 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
I thought I had made a general example on a way to do this and posted it in the BIRT-Exchange devShare, but I can't seem to find it. I'll make a simple example and post it, then link it in here.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1004191 is a reply to message #1004184] Tue, 22 January 2013 14:13 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
Here it is:

BIRT Exchange DevShare - Crosstab Row Number Example

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1005855 is a reply to message #1004191] Tue, 29 January 2013 00:43 Go to previous messageGo to next message
Elena M is currently offline Elena M
Messages: 11
Registered: January 2013
Junior Member
Thank you very much for anser!!!!
it works good
Smile

Report message to a moderator

Re: Row numbers for crosstab in a table [message #1006033 is a reply to message #1005855] Tue, 29 January 2013 10:38 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 802
Registered: July 2009
Senior Member
You're welcome. Glad to help!

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

Report message to a moderator

Previous Topic:How allow QTP to investigate on a PDF report file generated by BIRT ?
Next Topic:Wrong page number with dynamic text field (Separate run/render task)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 18:13:05 EDT 2013

Powered by FUDForum. Page generated in 0.02578 seconds