Hi, i have a list report in Cognos, among the columns, i have one column which is of XML data. we are to get a part of that XML code in to the column. we used substr and instr functions to get this value. and report runs fine with all other columns but when i add this field to the list, report just runs and gives a blank white page (not empty list) just a blank empty page. can you guys please help me in this.
by the way, my report is an SQL driven not a package or cube based one.
Quote from: PradeepKumarP on 01 Dec 2016 09:36:49 AM
by the way, my report is an SQL driven not a package or cube based one.
Why do people do this? Anyway...
If you run the SQL on the query tool for whatever database you are using, does it work there? How long is this XML fragment?
This is such an odd use case, I would probably consider putting it in a stored procedure. Something I would not normally recommend, but then you are also using SQL so...