nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Avoid cells merged because of repeating value using Crosstab

viky4frnds

Hi,
 
 
I have a requirement in Cross tab BIRT Report. Need to repeat the columns in Cross tab.For example, I am getting the report in attached format(result1.JPG).
 
But I want to display the report in attached format(Expected_Format.JPG):
 
In the above example, student id is repeating. How can i make the column repeated in BIRT using Cross tab.I have generated report in xlsx format.
 
I have attached the csv sample data and layout. Kindly help me to solve this issue.

Find more posts tagged with

Comments

pricher

Hi,
 
You can create in your data set a computed column that concatenates the 3 fields Student_ID, Student_Name and Grade, such as:
<pre class="_prettyXprint _lang-">
row["Student_ID"] + "|" + row["Student_Name"] + "|" + row["GRADE"]
</pre>
Then in the data cube you create a new group based on that column. This will become the column you group on in the crosstab.
 
To show the Student ID, Student Name and Grade in their respective column in the crosstab, add 3 data bindings to the crosstab that are based on the new group column. For example, to get Student ID, you can use the following expression in the data binding:
<pre class="_prettyXprint _lang-">
var a = data["GroupColumn"].split("|")
a[0]
</pre>
Student Name and Grade will be the 2nd and 3rd element of the array.
 
Add a 3-column grid in the crosstab below the group column. In each cell, add a data item for Student ID, Student name and Grade. Finally, hide the group column by setting its Visibility property to false.
 
I have attached a sample report based on your original report.
 
Hope this helps,
 
P.