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
You need two tables Outward Journeys and Return Journeys then join From station of the Return to the To station of the Outward table.
i dont get your point can you please elaborate it.
Okay,
Given your example in your first post, you need to have two tables both containing the same data. Then create a join from the first table (OUTWARD JOURNEYS) to the second table (RETURN JOURNEYS) and the join needs to be from the TO station on the OUTWARD JOURNEYS table to the FROM station on the RETURN JOURNEYS station.