Split the table.
Each ticket is for one and only one passenger. A booking can be for one or more tickets.
Booking
Field Type Null Default Description
booking_no int(7) No Booking No.
t_no int(4) Yes NULL Train No.
t_name varchar(30) Yes NULL Train Name
s_frm varchar(30) Yes NULL Station From
s_to varchar(30) Yes NULL Station To
j_date date Yes NULL Journey Date
class varchar(10) Yes NULL Class
Ticket
Field Type Null Default Description
booking_no int(7) No Booking No.
pnr_no int(7) No PNR No.
p_name varchar(30) Yes NULL Passenger Name
p_age tinyint(2) Yes NULL Passenger Age
p_sex char(1) Yes NULL Passenger Sex
p_sc varchar(3) Yes NULL Passenger Senior Citizen
p_berth char(1) Yes NULL Passenger Berth
Your report then joins the two tables using the field
booking_no
.