vb.net - Crystal Reports only shows the last column -
since new crystal report have search 3 hours still couldn't find right answer problem. please check code.
dim rptsumrep crystaldecisions.crystalreports.engine.reportdocument dim sda new mysqldataadapter dim bsource new bindingsource dim dtincom new datatable dtincom.clear() conn.open() dim queryincom string = "select *from tblbilling date_conduct between '" & dtfrom.value.date.tostring("yyyy-mm-dd") & "' , '" & dtto.value.date.tostring("yyyy-mm-dd") & "'" sda = new mysqldataadapter(queryincom, conn) sda.fill(dtincom) bsource.datasource = dtincom sda.update(dtincom) grid.datasource = bsource rptsumrep = new crystalreport1 rptsumrep.setdatasource(dtincom) frmcrystalreport.crystalreportviewer1.reportsource = rptsumrep frmcrystalreport.crystalreportviewer1.refresh() frmcrystalreport.showdialog() frmcrystalreport.dispose()
questions:
- do have name rpt field same datagridview column title?
- why last column title same database rename "status" on run time shows "status"
the column titles in database , dataset has same.
also, using select column1, column2, columnn ...
better way writing select *
in query.
titles should/can edited in report file
, change showing title of column, of course name of column should stay original in details section of report.
Comments
Post a Comment