Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Split Columns In report.

Status
Not open for further replies.
mvnbalu23

mvnbalu23

Technical User
Jan 21, 2011
3
0
0
IN
I have a list report.My list report contains 20 rows.I want split the rows like







usingConditinal variables

if([Query1].[S.NO] between 1 and 5) then('A')

else if([Query1].[S.NO] between 6 and 10) then('B')

else if([Query1].[S.NO] between 11 and 15) then('C')

else if ([Query1].[S.NO] between 16 and 21) then('D')

else('E')
 
Status
Not open for further replies.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
72
tushargaurav
tushargaurav
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
60
deborahyr63
deborahyr63
wwconslt
  • Locked
  • Question
Wild Card for Nine Digit Zip Codes in Prompt
Replies
0
Views
52
wwconslt
wwconslt
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
57
Goutham3835
Goutham3835
sreevp2020
  • Locked
  • Question
dynamic deafult date in date prompt calandar
Replies
0
Views
62
sreevp2020
sreevp2020

Part and Inventory Search

Sponsor

Back
Top