Simple Script report

from future import unicode_literals
import frappe
def execute(filters=None):
    columns, data = [], []
    columns = [ ("ID") + ":Link/Patient Details:140", "Patient Name:Data:140", "Address:Small Text:140", "City:Data:100", "Date of Birth:Data:100", "Gender:Data:50", "Height:Int:50", "Blood Group:Data:10", "Phone No:Data:100", "Marital Status:Data:100", "Guardians Name:Data:140", "Relationship With Patient:Data:100",
    "Age:Data:50", "Mob No:Data:100", "Total Weight:Data:0"]
    data = frappe.db.sql("""Select name, patient_name, address, city, date_of_birth, gender, height, blood_group, phone_no, marital_status, guardian_name, defender, guardian_age, mob_no, total_weight 
     from `tabPatient Information` """ , as_list=1)

    return columns, data