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 |
What is difference between drill through and drill down?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
Tell me about Schemas?
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls
Why cognos scenario is used?
What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,
hi, while opening the cognos8 in ie,the home page is coming,while clicking the report studio the blank page will come after it will showing the home page.But by clicking the cognos connection,Query studio in the same page it's open successfully. only for the report,analysis,event studio is not working properly.i didnot understanding the problem.Iam using the cognos8.1 and sql server 2005.and also checking the cognos connection by clicking the run and its success. Any one Knows pls tel me in detail,becoz its very important iam working in report studio...
what do you mean by parallel execution of query?
How to Create users in cognos Access Manager from 1) front end 2) back end
When we use consume in cognos?
how you create security to reports?