c# - Chinese character cannot be read export to pdf from crystal report (parameter) -
i using crystal report viewer print , export report pdf file. realized when printing chinese character, show box instead of word self.
the code how assign data parameter in crystal report.
reportdocument reportdata = new reportdocument(); string reportpath = server.mappath("incidentreport.rpt"); reportdata.load(reportpath); //get data database string sqlcommand = "select ticketno, to_char(reportdate,'dd-mm-yyyy hh:mm') reportdate, status, severity,category,assignee,incidentdesc,incidentdetail,incidenttype,analysis,solution,attachment,to_char(createdate,'dd-mm-yyyy') createdate,createuserid,to_char(updatedate,'dd-mm-yyyy') updatedate, updateuserid ticket ticketno = '" + session["ticketnor"] + "' "; dataset ds = new dataset(); readdata.selectdata(ds, sqlcommand); //set parameter reportdata.setparametervalue("ticketno", (string)session["ticketnor"]); reportdata.setparametervalue("reporteddate", ds.tables[0].rows[0]["reportdate"].tostring()); reportdata.setparametervalue("status", ds.tables[0].rows[0]["status"].tostring()); reportdata.setparametervalue("severity", ds.tables[0].rows[0]["severity"].tostring()); reportdata.setparametervalue("category", ds.tables[0].rows[0]["category"].tostring()); reportdata.setparametervalue("assignee", ds.tables[0].rows[0]["assignee"].tostring()); reportdata.setparametervalue("attachment", ds.tables[0].rows[0]["attachment"].tostring()); reportdata.setparametervalue("type", ds.tables[0].rows[0]["incidenttype"].tostring()); reportdata.setparametervalue("incidentdesc", ds.tables[0].rows[0]["incidentdesc"].tostring()); reportdata.setparametervalue("incidentdetail", ds.tables[0].rows[0]["incidentdetails"].tostring()); reportdata.setparametervalue("analysis", ds.tables[0].rows[0]["analysis"].tostring()); reportdata.setparametervalue("solution", ds.tables[0].rows[0]["solution"].tostring());
i using oracle 11g database , asp.net c# coding.
everything looks in browser when export pdf file become none-readable character already. ( parameter use c# pass value cannot show chinese. text object shown pretty good.
english characters display chinese character not working. have idea on this? comment , suggestion appreciated!
Comments
Post a Comment