Category
Data Sources
Product Version
7.3
Tabular report Issue
Resolved
Dear Sir
My name is Zia (Dept. ISD) . My organization is using Yellowfin 7.3.
I am facing problem while creating report. Report column data are showing 'Download'
I can not see any actual data in any column. Please find the attached file herewith.
Data source : AS/400 IBM DB2
Could you please help me in this regard ?
Best Regards
Zia
Thailand
Files:
Problem_Report.xlsx
The same problem 
Is there any solution ?
Is there any solution ?
Hi Zia,
Apologies for the delay it was our weekend. It is a little difficult to tell what is going on here from the screen-shot alone, but to me it looks like there is an HTML link applied as the default formatting to each of these columns:
What happens when you switch this to "Raw Data" or "Text"?
Regards,
Nathan
Hi Zia,
Apologies for the delay it was our weekend. It is a little difficult to tell what is going on here from the screen-shot alone, but to me it looks like there is an HTML link applied as the default formatting to each of these columns:
What happens when you switch this to "Raw Data" or "Text"?
Regards,
Nathan
Hi Nathan,
I changed the source driver from AS400 DB2 to Generic JDBC Data Source and use connection string to jdbc:as400://server IP;translate binary=true;package ccsid=838 then it works. Now I can see the data . Do you know why ?
Database Type : Generic JDBC Data Source
Include Schema in SQL : Yes
JDBC Driver : jdbc.driver=com.ibm.as400.access.AS400JDBCDriver
Connection String : jdbc:as400://server IP;translate binary=true;package ccsid=838
Hi Nathan,
I changed the source driver from AS400 DB2 to Generic JDBC Data Source and use connection string to jdbc:as400://server IP;translate binary=true;package ccsid=838 then it works. Now I can see the data . Do you know why ?
Database Type : Generic JDBC Data Source
Include Schema in SQL : Yes
JDBC Driver : jdbc.driver=com.ibm.as400.access.AS400JDBCDriver
Connection String : jdbc:as400://server IP;translate binary=true;package ccsid=838
Hi Zia,
That is a bit strange, and I am not sure what the difference here is, though I would imagine it has something to do with your translate binary clause.
Glad you got it figured out though!
Regards,
Nathan
Hi Zia,
That is a bit strange, and I am not sure what the difference here is, though I would imagine it has something to do with your translate binary clause.
Glad you got it figured out though!
Regards,
Nathan
Replies have been locked on this page!