How can we display Row Number (Serial) in CrossTab Report

Hi,

I have designed the cross tab reports successfully.But the problem is i need to display row number as a one field like serial number.

Can you Please help me to solve this problem.

Thanks,
Srinivas.T

Find more posts tagged with

Comments

mwilliams

Hi Srinivas.T,

Can you attach a small sample of what your data looks like in your dataSet and also how your crosstab is set up. Then I can work with your data to be sure whatever I come up with can be applied to your data. Thanks.

SrinivasaRao

Hi,

Thank you for your response.

PFA attached Cross tab report.

In that report i have 2 issues

1. The first column in report (Product Code) should be iterate for every row but its displaying once only for entire group

2.Need to be First column is Serial Number of the Row.But, i am unable to display Row number in cross tab.

Please help me out to solve these 2 issues ASAP.

Again Thanks for your time.

mwilliams

Srinivas.T,

Take a look at the design now. I made a change to the query, the dataSet, and the cube. The preview window didn't work for me, but if you use the web viewer, you should see everything correctly. Let me know if you have any questions.

SrinivasaRao

Hi mwilliams,

Thank you for your time.

The report looking awesome.

But the Problem is, in this case is the report have the dynamic growing columns(#16). I have given page break 4. firsr 4 is over then immediately next 4 have to come for the same products But, its coming on 76th page (next 4 columns for first page product codes.)

But we need the report first its displaying first 4 columns for all the product codes then its starting next 4 columns for the same product.

I mean to say 76th page content should be in 2nd page.

Please Help me out from this problem as soon as possible.

Thanks and waiting for your response.

mwilliams

Srinivas.T,

Alright. I used a table, an interval group on the table, and a filter on the crosstab to make this report. Take a look. Let me know if this is what you're looking for.

SrinivasaRao

Hi,

Thank you for your Help and time.

The report looking awesome and this is the report exactly what i need.

Thanks,
Srinivas.T

mwilliams

Srinivas.T,

Great! Let us know if you have any other questions!

SrinivasaRao

Hi,

Can we give row alternative colors for this report?

If yes, Can you give some idea on that. That will give more good look and feel for my report.

Thanks

mwilliams

Check out this example in the devShare. It should help you do this. Let me know if you have questions. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/825-crosstab-highlight-using-script/#description'>Crosstab highlight using script - Designs & Code - BIRT Exchange</a>

SrinivasaRao

Hi,

Thank you for your time.

I have gone through the example but, I need alternative colors for all the columns not only for the measures.

Ex:-In the above report we need to display alternative colors for RowNumber,ProductCode and orderNumber columns also.

I have tried but unable to find solution.Please help me.

Thanks,
Srinivas.T

mwilliams

Srinivas,

I have an example somewhere that I made highlighting dimension columns as well. I'll look for it. If I can't find it, I'll create another.

mwilliams

Srinivas,

Here's a quick example on highlighting a crosstab that I just created real quick. I highlighted the measures and the row dimension. If you have more than one row dimension, you can just use a different variable for each to alternate for highlighting. Let me know if you have questions.

This report was made in 2.5.1

srinivast

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="59385" data-time="1264087587" data-date="21 January 2010 - 08:26 AM">
Srinivas.T, 
 
 
Take a look at the design now. I made a change to the query, the dataSet, and the cube. The preview window didn't work for me, but if you use the web viewer, you should see everything correctly. Let me know if you have any questions. </blockquote>
 
 
Hi, 
 
I like your example.But, the problem here is using different query or modifying query is too complicated for me as my query contains morethan 150 lines of code. Is there of any chance to disply row number in layout level like how we will display row number for normal table(row[0]+1). 
 
Please help me ASAP on this issue. 
 
Any help is Greatly appreciated. 
 
Thanks, 
Srinivas

mwilliams

Hi Srinivas,

The attached report shows a way that you can display a row number for a crosstab without adding a computed column to your dataSet. A variable is initialized in the initialize script and then incremented in the onCreate of the text element placed in the dimension area. Let me know if you have questions. Hope this helps.

SrinivasaRao

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="59631" data-time="1264612817" data-date="27 January 2010 - 10:20 AM">
Check out this example in the devShare. It should help you do this. Let me know if you have questions. 
 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/825-crosstab-highlight-using-script/#description'>Crosstab highlight using script - Designs & Code - BIRT Exchange</a> </blockquote>
 
Hi, Actually i am looking for the Serial no should be the first column. and year should repeat for the quarters 
 
For example the above report should display result like 
1 2007 Q1 
2 2007 Q2 
3 2007 Q3 
4 2007 Q4 Like that. 
 
Can you please provide me any solution to achieve like that it will solve lot of other problems also for me like export in xls alignment problems. 
 
Actually we got strucked up here because of this problem. 
 
Any help would be greatly Appreciated. 
 
Thanks a lot in advance, 
Srinivas

mwilliams

Srinivas,

Sorry, I forgot to actually attach the report design that I had made, I think. Here it is. It has the row number first. Let me know if you have any questions.

SrinivasaRao

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="65697" data-time="1276806286" data-date="17 June 2010 - 01:24 PM">
Srinivas, 
 
Sorry, I forgot to actually attach the report design that I had made, I think. Here it is. It has the row number first. Let me know if you have any questions. </blockquote>
 
Hi Mwilliams, 
 
Thanks for helping us. your report is looking Good! 
 
But it won't fulfill our requirements. We need to display the report like 
SL NO year Quarter

1 | 2003 | 1 
2 | 2003 | 2 
3 | 2003 | 3 
4 | 2003 | 4 
5 | 2004 | 1 
6 | 2004 | 2 
7 | 2004 | 3 
8 | 2004 | 4 
9 | 2005 | 1 
10 | 2005 | 2. 
 
Please help us to get the report done in this format. 
 
Thanks in Advance, 
Srinivas.T

mwilliams

Srinivas,

Just a minor modification to get that. Take a look.

srinivast

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="65738" data-time="1276888783" data-date="18 June 2010 - 12:19 PM">
Srinivas, 
 
Just a minor modification to get that. Take a look. </blockquote>
 
Thank mwilliams, Your support and help most appreciated! 
 
I have tried a lot to put the datagrid in the place of "Drop Datafields to define the rows here " Part. But, i was unable to do. Please give me some idea on this part How you have pasted the Grid in that part. 
 
I guess we can paste only data cube groups here. 
 
Please give me some idea on this.FYI i am using birt 2.5.1 and Please find attachment of screen shot. 
 
Thanks in Advance 
Srinivas.T

mwilliams

Srinivas.T,

Sorry for not explaining that part. You must drop a group in from your dataCube, then, when the crosstab cell is actually created, you can then drop a grid in there with the data element and then move the data element inside the grid. Let me know if you have any other questions.

Preethisha

Hi Williams,

I just need to display the serial number foir each row fetched from the DB. Its a normal list report. How to do that. Earliest reply is more helpful for me.

Thanks,
Preethisha

mwilliams

Preethisha,

Oh, if you're just doing a normal list report, you would just need to add a computed column to your dataSet and use an aggregation of "runningcount".

Raghuvj

Hi Williams,
I need some clarification regarding serial no
I have a column which is integer type and this column has duplicate values,
My requirement is like i dont need to display serial no for the duplicate values.

S.No. column
1.

Raghuvj

mwilliams

So, you want all the duplicate values of the integer field to be displayed separately? Why not just use a table? Or am I misunderstanding? Can you show a sample of dataSet data and what you want the output of your report to look like?

msingh

Hi Michael, I am unable to find the report files which you have attached in this post for displaying serial number in crosstab report.Can you please give me those files? I want to add serial number for each row of my crosstab.

Serene_Pang

I would like to have that sample too. Would appreciate if anyone can help. Thanks a lot.

jfranken

Could you please post an example of what you want? For example, a spreadsheet or screenshot showing the desired output. Please indicate which data is retrieved from the database and which data is computed in the report. Also, what version of the designer are you running?