| 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); |
| } |