report - VB.NET 2 subreports based off of one dataset -
problem description: have iseries query in vb.net/vs 2008 need run 2 separate values of same parameter , present in report a/b comparison. in other words - want see report result of run parameter = value1 on left, same query parameter = value2 on right.
my initial idea use 2 tables on report each table based on result of each run dataset (xsd), seem able specify parameters on reportviewer level, means have 2 identical tables instead of a/b cases.
obvious second way create 2 separate reports, each own parameter value , them subreports onto main one. however, both subreports show "error: subreport cannot shown". there way catch error see why?
i did few other experiments, have problem fact it's not "neat" solution.
what best way (a.k.a. best practices, industry standard, whatever want call it) create kind of a/b report? sure there well-known method make work, surprise haven't found except multiple copies of msdn articles.
to use 2 reports same dataset, need add event handler code hook subreportprocessing event. when event fired set datasource dataset. other thing need @ report itself. if using remotemode.local reportviewer have have .rdlc extension of report never load. keep reports both extensions. 1 run reporting server , other running local in program.
i hope helps!
regards, willie
Comments
Post a Comment