In cognos report studio to hide the column in a crosstab you have to follow a few steps.
In a list report if you select any column and set the "Box Type" Property to "None" then the column will be hidden without any problem. Whereas in crosstab if you do the same then the column will be hidden but the column headings on the right hand side of the hidden column will shift to left. To avoid this please follow the simple steps given below.
1. Open Cognos report studio and design the crosstab as per your requirement.
2. Unlock the report - Click on the lock icon on the top.
3. Click on the text which you want to hide (click only on the text not on the entire column). As shown below.
4. Cut the text.
5. Now if you run the report to check, the data will not be visible but the empty column is visible. To hide this, Select the same column and :-
Set the border to none.
Set Left and Right padding to 0px.
Thanks....!
In a list report if you select any column and set the "Box Type" Property to "None" then the column will be hidden without any problem. Whereas in crosstab if you do the same then the column will be hidden but the column headings on the right hand side of the hidden column will shift to left. To avoid this please follow the simple steps given below.
1. Open Cognos report studio and design the crosstab as per your requirement.
2. Unlock the report - Click on the lock icon on the top.
3. Click on the text which you want to hide (click only on the text not on the entire column). As shown below.
5. Now if you run the report to check, the data will not be visible but the empty column is visible. To hide this, Select the same column and :-
Set the border to none.
Set Left and Right padding to 0px.
Thanks....!
No comments:
Post a Comment