or
public MasterReport()
{
InitializeComponent();
AddSubreports(111);
}
private void AddSubreports(int headerId)
{
ReportDataSource c = new ReportDataSource(headerId);
dss = c.GetSources();
foreach (ParameterValuesReportDataSource ds in dss)
{
IndividualParameterReport subreport = new IndividualParameterReport(ds);
SubReport subReport = new SubReport();
subReport.Size = new SizeU(Telerik.Reporting.Drawing.Unit.Cm(8), Telerik.Reporting.Drawing.Unit.Cm(1));
subReport.Dock = DockStyle.Top;
subReport.ReportSource = subreport;
detail.Items.Insert(0, subReport);
}
}
public MasterReport()
{InitializeComponent();
DataSource = null;
NeedDataSource += new EventHandler(MasterReport_NeedDataSource);
}void MasterReport_NeedDataSource(object sender, EventArgs e)
{headerId = Int32.Parse(ReportParameters["ParameterHeaderId"].Value.ToString());
AddSubreports(headerId);
}<
telerik:RadWindow
x:Class
=
"SilverFinancials.WindowsReport.CheckReport"
xmlns:telerik
=
"http://schemas.telerik.com/2008/xaml/presentation"
xmlns:telerikReport
=
"clr-namespace:Telerik.ReportViewer.Silverlight;assembly=Telerik.ReportViewer.Silverlight"
mc:Ignorable
=
"d"
Closed
=
"Check_Print_Closed"
Header
=
"Check Print"
d:DesignHeight
=
"300"
d:DesignWidth
=
"400"
Width
=
"970"
Height
=
"600"
>
<
Grid
x:Name
=
"LayoutRoot"
Background
=
"White"
>
<
telerikReport:ReportViewer
Name
=
"checkReport"
Width
=
"970"
Height
=
"600"
>
</
telerikReport:ReportViewer
>
</
Grid
>
</
telerik:RadWindow
>
using
SilverFinancials.Windows.Accounts_Payable.Posting;
using
Telerik.Windows.Controls;
namespace
SilverFinancials.WindowsReport
{
public
partial
class
CheckReport : RadWindow
{
public
CheckReport(
)
{
InitializeComponent();
}
}
}
declare
@
date
smalldatetime
select
@
date
= GETDATE()
select
@
date
=
CONVERT
(
varchar
(12),getdate(),101)
SELECT
PEERS.COMPANY_NAME, PEERS.ASN, EXCHANGES.EXCHANGE_NAME, PEERINGS.CREATED
FROM
EXCHANGES
INNER
JOIN
PEERINGS
ON
EXCHANGES.EXCHANGE_ID = PEERINGS.EXCHANGE_ID
INNER
JOIN
PEERS
ON
PEERINGS.PEER_ID = PEERS.PEER_ID
WHERE
PEERINGS.CREATED
BETWEEN
@
date
+
'00:00'
AND
@
date
+
'23:59'