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
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 |
How can we create a dynamic column name in cognos?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
how to do page breaks in cognos 8 Report studio pls give the navigation
what does my folder and public folder contains? difference between the my folder and public folder?
how can you set the image in the report
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
How do we run stored procedure?
how many types of formats you can run a report using cognos?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
What is the use of Cognos scenario?
what is the difference between count and running-count functions?