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
Answer Posted / 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 |
Post New Answer View All Answers
Can you define pivot?
4. How many dimensions did you use in your reports?
What do you understand by the cognos?
WHAT ARE THE DISTNICT VARIABLES?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
How can we Maintain the Cube Security by Category level and Dimension level ?
What is model?
Explain the difference between native sql and cognos sql?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
How to do Performence Tunning in Cognos Reports?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What are the themes in a data warehouse?
What is Bitmap Index?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)