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
- 4341 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 |
Why we take so long time to display date prompt before displaying a report? How can we reduce the time?
how to hide a particular pages at time if you get blank pages
How to hide value prompt box and list when run report?
What is power prompts?Can somebody explain me.
What is the enterprise class platform architecture of cognos 8?
write a query to display the third record from the employee table?
How to upgrade drivers in Cognos 8?
Can you define folder?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what are the names of the reports that you prepared?
How can I change reports to another package???
hai frndz....... in a product name QUERY ITEM column we have some products like..soap, mobile, laptop, nd so on..... when i report run for the US client with the product name,, langauge is requird only ENGLISH.... IF client as a chaina .or, japan .or, spanish.. they want to run report using by product name QUERY ITEM as thier region language like chaina/japan/spanish... how to i convert product name column as default as english, to chaina/japan/spanish..........in the framework manager/ cognos connction Could u pls give me problm solution.....thnx in advnce........
Teradata 
