Answer / sowji

Using Head function u can get first record ,Using tail
function u can get last record.

Answer / rashmi

First Record : head(FieldName,1)
Last REcord : tail(FieldName,1)

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

1 Answers   Cognizant, Niteo, SacSoft,

---

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

1 Answers   HCL,

---

how can i provide security to my reports in report studio?

3 Answers   TCS,

---

can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

0 Answers  

---

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  

---

what is differences between the group span and levelspan

1 Answers  

---

1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?

0 Answers   TCS,

---

-----------------What is Direct and Conventional loading?

0 Answers  

---

difference between stored procedure and function?

4 Answers   Syntel,

---

If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

0 Answers   Wipro,

---

Column level security in report

4 Answers  

---

Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

1 Answers   Wipro,

---