public partial class repRegisterConfirmMaster : Telerik.Reporting.Report |
{ |
private int iBenutzerId = -1; |
public int PARAMETER_BenutzerId |
{ |
get { return iBenutzerId; } |
set { iBenutzerId = value; } |
} |
private int iOrderId = -1; |
public int PARAMETER_OrderId |
{ |
get { return iOrderId; } |
set { iOrderId = value; } |
} |
private sbyte iSpracheId = -1; |
public sbyte PARAMETER_SpracheId |
{ |
get { return iSpracheId; } |
set { iSpracheId = value; } |
} |
public repRegisterConfirmMaster() |
{ |
InitializeComponent(); |
} |
public void loadReportData() |
{ |
this.dsBenutzerKundeAdresseKontaktTableAdapter1.Fill(this.dsBenutzerKundeAdresseKontakt.dsBenutzerKundeAdresseKontaktTable, iBenutzerId); |
} |
public partial class subRegisterConfirmModul : Telerik.Reporting.Report |
{ |
private int iOrderId = -1; |
public int PARAMETER_OrderId |
{ |
get { return iOrderId; } |
set { iOrderId = value; } |
} |
private sbyte iSpracheId = -1; |
public sbyte PARAMETER_SpracheId |
{ |
get { return iSpracheId; } |
set { iSpracheId = value; } |
} |
public subRegisterConfirmModul() |
{ |
InitializeComponent(); |
} |
public void loadReportData() |
{ |
this.dsKundenModulByOrderIdTableAdapter1.Fill(this.dsKundenModulByOrderId.dsKundenModulByOrderIdTable, (byte) iSpracheId, iOrderId); |
} |
... ReportViewer1.Report = new repRegisterConfirmMaster(); |
(ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_BenutzerId = 77; |
(ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_OrderId = 94; |
(ReportViewer1.Report as repRegisterConfirmMaster).PARAMETER_SpracheId = S.SpracheId; |
(ReportViewer1.Report as repRegisterConfirmMaster).loadReportData(); |
3. OS : xp pro service pack 3
Tools/product : Telerik reporting version 2009.2 701 (Jul 1, 2009)
Web Viewer version : 3.0.9.430
i would to know how to call user defined function from mssql to be displayed in a report. Pls provide me an example/documentation regarding this issue. One more thing, im using automatic ui parameterized feature to filter data ( which prompt user input ), i want to use more than one parameter to filter data. When i just tried to add more parameter it failed to work but working well with one parameter. How to address this problem? Since im working with web application, when i want run the project thru localhost, the page is empty (no data displayed) but i could preview the report. How to solve this portion.
Thank You
Your guidance is much appreciated
Regards
Pat
Telerik.Reporting.SubReport subRep; |
Unit unitX = Unit.Cm(0.1); |
Unit unitY = Unit.Cm(0.1); |
SizeU size = new SizeU(Unit.Cm(0.5), Unit.Cm(0.5)); |
foreach (string wo in woArray) |
{ |
//create subreport |
subRep = new SubReport(); |
subRep.Size = size; |
subRep.Location = new PointU(unitX, unitY); |
subRep.ReportSource = new Report(wo); |
unitY = unitY.Add(Unit.Cm(2)); |
detail.Items.Add(subRep); |
} |