Wrong report source being shown on crystalreportviewer VB.net -
i'm trying dynamically data source database using query shows wrong report source though query , data source correct.
public da new sqldataadapter public ds dataset public function executeviasql(byval sqlquery string) dataset ds = new dataset da = new sqldataadapter(sqlquery, conn) da.fill(ds, 0) return ds end function private sub formload dim rs new rptdaily ds = new dataset ds = executeviasql(query) 'query public , has stored query rs.load() rs.setdatasource(ds.tables(0)) crystalreportviewer1.reportsource = rs end sub
the report showing default report source though i've set report source dataset database.
additional information, rptdaily.rpt properties:
build action: embedded resource
copy output directory: not copy
custom tool: crystaldecisions.vsdesigner.codegen.reportcodegenerator
custom namespace: blank
i think problem reportsource pulling data database instead of dataset. still don't know how resolve problem.
Comments
Post a Comment