Hi,
In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me
- 2 Answers
- 4550 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swamy
Hi,
from gosales&retailers,
1.drag first name, workphone,email data items into list report,
2.double click on first name data item,
type as ||' ||
3.in expresin windw left side drag last name,
clik validate,ok.
[gosales_goretailers].[Sales reps].[First name] ||' '|| [gosales_goretailers].[Sales reps].[Last name]
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / suresh
Hi,
Its just simple. Create 2 data items and name it
first_name & last_name. write a code like
substr(fullname,postion,end).
| Is This Answer Correct ? | 1 Yes | 1 No |
what are the enhancements in cognos reportnet ?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
HI,can one suggest best institute for cognos Training in Hyderabad
What is the difference between macro & Parameter
where you can save the report net documentation in our local system?
what is #prompt and #promptmany, runningtotal in report studio
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated
Can any one give the example for slicing and dicing of data ?(with simple query)
what is the procedure for scheduling conditional rendering?
What is stitched Query?
Define catalog in cognos and write its various types?
Teradata 
