Hi , First I'm very new with JSON . I'd like to ask : as I understood from JSON documentation that the output data in JSON format must look like something like to this : [ { "Name" : "Alfreds Futterkiste", "City" : "Berlin", "Country" : "Germany" }, { "Name" : "Berglunds snabbköp", "City" : "Luleå", "Country" : "Sweden" }, { "Name" : "Centro comercial Moctezuma", "City" : "México D.F.", "Country" : "Mexico" }, { "Name" : "Ernst Handel", "City" : "Graz", "Country" : "Austria" } ] but in Koha the output for Public reports is like this : [["23-12-2014","maisara","6"],["23-12-2014","nadia","10"],["22-12-2014","hakkar","17"],["22-12-2014","nadia","3"],["22-12-2014","abdramaneg","21"]] the field names is not in the output , and I realized ( & maybe I'm wrong) that to handle JSON text you must have id for each field ) to handle it with your script . so is this a correct output from Koha ? and can be handled in some advanced methods with JSON ? or do I have to write my SQL report in a way to CONCAT the field name with the field data in every data cell ? thanks :) . -- *Karam Qubsi <https://www.linkedin.com/in/kqubsi>* *Shah Alam , Malaysia . *