please solve the query

[esanray]

DATABASE CONTAIN the following type of data

Arrive STATION      Depart STATION
BBS      Cal
BBS      CAL
CAL        BBS
CAL       BBS
MAD       BOM
MAD      BOM
BOM      MAD

I WANT TO SHOW THE REPORT

ROUT      NO OF TRAIN
BBS-CAL-BBS   4
MAD-BOM-MAD   3

CAN YOU PLEASE EXPLAIN THE STEPS  IN fm or report studio

[cognostechie]

Hi -

I have seen your other posts too. Have you considered attending a Cognos class or getting a book before starting on the job ? There are some books available on the internet that will give you some understanding of how to do things. Check out amazon.com

[esanray]

can you please ref me any book to solve these kind of things

[cognostechie]

Sure. Try this -

http://www.amazon.com/IBM-Cognos-Business-Intelligence-Official/dp/0071498524

You can also start with the PDFs that come with Cognos software. They are
located in Program Files/<cognos installation folder>/webcontent/documentation/en

Look for:

ug_fm.pdf (Framework Manager Guide)
ug_rptstd.pdf (Report Studio)