How can we display Row Number (Serial) in CrossTab Report
Options
Comments
-
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.Warning No formatter is installed for the format ipb0 -
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.0 -
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.Warning No formatter is installed for the format ipb0 -
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.0 -
Hi,
Thank you for your Help and time.
The report looking awesome and this is the report exactly what i need.
Thanks,
Srinivas.T0 -
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.
Thanks0 -
Check out this example in the devShare. It should help you do this. Let me know if you have questions.<br />
<br />
<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>Warning No formatter is installed for the format ipb0 -
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.T0 -
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.1Warning No formatter is installed for the format ipb0 -
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="59385" data-time="1264087587" data-date="21 January 2010 - 08:26 AM"><p>
Srinivas.T,<br />
<br />
<br />
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.<br /></p></blockquote>
<br />
<br />
Hi,<br />
<br />
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).<br />
<br />
Please help me ASAP on this issue.<br />
<br />
Any help is Greatly appreciated.<br />
<br />
Thanks,<br />
Srinivas0 -
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.Warning No formatter is installed for the format ipb0 -
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="59631" data-time="1264612817" data-date="27 January 2010 - 10:20 AM"><p>
Check out this example in the devShare. It should help you do this. Let me know if you have questions.<br />
<br />
<br />
<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><br /></p></blockquote>
<br />
Hi, Actually i am looking for the Serial no should be the first column. and year should repeat for the quarters<br />
<br />
For example the above report should display result like<br />
1 2007 Q1<br />
2 2007 Q2<br />
3 2007 Q3<br />
4 2007 Q4 Like that.<br />
<br />
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.<br />
<br />
Actually we got strucked up here because of this problem.<br />
<br />
Any help would be greatly Appreciated.<br />
<br />
Thanks a lot in advance,<br />
Srinivas0 -
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="65697" data-time="1276806286" data-date="17 June 2010 - 01:24 PM"><p>
Srinivas,<br />
<br />
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.<br /></p></blockquote>
<br />
Hi Mwilliams,<br />
<br />
Thanks for helping us. your report is looking Good!<br />
<br />
But it won't fulfill our requirements. We need to display the report like <br />
SL NO year Quarter<br />
<br />
1 | 2003 | 1<br />
2 | 2003 | 2<br />
3 | 2003 | 3<br />
4 | 2003 | 4<br />
5 | 2004 | 1<br />
6 | 2004 | 2<br />
7 | 2004 | 3<br />
8 | 2004 | 4<br />
9 | 2005 | 1 <br />
10 | 2005 | 2.<br />
<br />
Please help us to get the report done in this format.<br />
<br />
Thanks in Advance,<br />
Srinivas.T0 -
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="65738" data-time="1276888783" data-date="18 June 2010 - 12:19 PM"><p>
Srinivas,<br />
<br />
Just a minor modification to get that. Take a look.<br /></p></blockquote>
<br />
Thank mwilliams, Your support and help most appreciated!<br />
<br />
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.<br />
<br />
I guess we can paste only data cube groups here.<br />
<br />
Please give me some idea on this.FYI i am using birt 2.5.1 and Please find attachment of screen shot.<br />
<br />
Thanks in Advance<br />
Srinivas.T0 -
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.Warning No formatter is installed for the format ipb0 -
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,
PreethishaWarning No formatter is installed for the format ipb0 -
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. 21
21
21
2. 32
I want to display like this.
Please help me for this issue.
Thanks,
J.Raghu0 -
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?Warning No formatter is installed for the format ipb0
-
I would like to have that sample too. Would appreciate if anyone can help. Thanks a lot.
0 -
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?
Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 109 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 122 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management