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:

  1. do have name rpt field same datagridview column title?
  2. 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

Popular posts from this blog

facebook - android ACTION_SEND to share with specific application only -

python - Creating a new virtualenv gives a permissions error -

javascript - cocos2d-js draw circle not instantly -