Hello Please help, how to generate sql reports if there is repeatable field having 2 or more data and get the report under two different rows for the repeatable field? Example: If there are more than two URL is given and i wish to get report in two columns and rest of the data in one column only: Tag 245a Tag 100a Tag856u Tag856y Tag8563 Tag856u Tag856y Tag8563 Tag856u Tag856y Tag8563 <datafield tag="856" ind1="4" ind2="0"> <subfield code="3">ScienceDirect</subfield> <subfield code="u"> http://www.sciencedirect.com/science/book/9780123694157</subfield> <subfield code="y">testing link</subfield> </datafield> <datafield tag="856" ind1="4" ind2="0"> <subfield code="3">test</subfield> <subfield code="u"> http://www.sciencedirect.com/science/book/9780123694157</subfield> <subfield code="y">ok test</subfield> </datafield> With Regards, Vinod Kumar Mishra, Assistant Librarian, Biju Patnaik Central Library (BPCL), NIT Rourkela, Sundergadh-769008, Odisha, India. Mob:91+9439420860 ORCID ID: http://orcid.org/0000-0003-4666-7874 *"Spiritual relationship is far more precious than physical. Physical relationship divorced from spiritual is body without soul" -- Mahatma Gandhi*