Hello ,
I am creating an invoicing report which consist of two sub report . The first sub report will display the master entries while second sub report displays detail entries.Invoice consist of predefined format as per client's need.
When i put first sub report on a main report ,Over all report works fine but it gives me following kinds of errors when i add second sub report.
An error has occurred while processing TextBox 'txtGrandTotal':
Aggregate node 'Sum(BinaryOp + (BinaryOp * (Fields(Const(PricePerAmount)),
Fields(Const(Amount))), BinaryOp * (IsNull(Fields(Const(PricePerAmount2)),
Const(0)), IsNull(Fields(Const(Amount2)), Const(0)))))' not found.
The second report work perfectly as an individual report.
Here i am specifying the code with Stored procedure which will return the data.Here i have returned sample data for your easiness.Please provide me the solution.
Following is a code for DefaultReport.designer.cs which will host two subreport
First Sub Report (InvoicePart.Designer.cs)
Second SubReport (InvoiceSupplementPartDesigner.cs)
CREATE PROCEDURE [dbo].[USP_GetCustomerDetailsForInvoice]
(
@CustomerID BIGINT = NULL
)
AS
BEGIN
SET @CustomerID = 30
select 'TestCompany' as CompanyName,
'1100' as PostCode,'15' as HouseNo,
'121' as Street,
'Zootermeer' as City,
'NetherLands' as CountryName,
NULL as TransportCompanyLogo,
' - ' as RelationNumber,
' - ' as VATNumber,
19.00 as VAT,
'Yet to set ' as DeafultInvoiceText,
'Yet to set ' as InvoicePaymentTerms
END
CREATE PROCEDURE [dbo].[USP_InvoiceDetailForInvoiceReport]
(
@InvoiceID BIGINT =NULL
)
AS
BEGIN
Select 28 as InvoiceID,
51 as OrderID,
'Hour' as Description,
20.00 as PricePerAmount,
15.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
2 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
52 as OrderID,
'KM' as Description,
20.00 as PricePerAmount,
25.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
3 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
57 as OrderID,
'Freight' as Description,
200.00 as PricePerAmount,
1.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
4 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
127 as OrderID,
'Hour & KM' as Description,
17.00 as PricePerAmount,
10.00 as Amount,
16.00 as PricePerAmount2,
15.00 as Amount2,
'€' as CurrencySymbol,
8 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
59 as OrderID,
'SCC' as Description,
23.00 as PricePerAmount,
50.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
1 as TariffTypeID
END
CREATE PROCEDURE [dbo].[USP_InvoiceMasterForInvoiceReport]
(
@InvoiceId BIGINT = NULL
)
AS
BEGIN
select 51 as OrderID,
'X0010' as OrderNumber,
'Hour' as TariffName,
'€' as CurrencySymbol,
330.0000 as OrderPrice,
1 as Mode
UNION ALL
select 52 as OrderID,
'X0011' as OrderNumber,
'KM' as TariffName,
'€' as CurrencySymbol,
550.0000 as OrderPrice,
1 as Mode
UNION ALL
select 57 as OrderID,
'X0014' as OrderNumber,
'Freight' as TariffName,
'€' as CurrencySymbol,
220.0000 as OrderPrice,
1 as Mode
UNION ALL
select 59 as OrderID,
'X0015' as OrderNumber,
'Amount' as TariffName,
'€' as CurrencySymbol,
1265.0000 as OrderPrice,
1 as Mode
UNION ALL
select 127 as OrderID,
'X0025' as OrderNumber,
'Hour & KM' as TariffName,
'€' as CurrencySymbol,
451.0000 as OrderPrice,
1 as Mode
UNION ALL
select NULL as OrderID,
'' as OrderNumber,
'Discount' as TariffName,
'€' as CurrencySymbol,
100.0000 as OrderPrice,
-1 as Mode
END
I am creating an invoicing report which consist of two sub report . The first sub report will display the master entries while second sub report displays detail entries.Invoice consist of predefined format as per client's need.
When i put first sub report on a main report ,Over all report works fine but it gives me following kinds of errors when i add second sub report.
An error has occurred while processing TextBox 'txtGrandTotal':
Aggregate node 'Sum(BinaryOp + (BinaryOp * (Fields(Const(PricePerAmount)),
Fields(Const(Amount))), BinaryOp * (IsNull(Fields(Const(PricePerAmount2)),
Const(0)), IsNull(Fields(Const(Amount2)), Const(0)))))' not found.
The second report work perfectly as an individual report.
Here i am specifying the code with Stored procedure which will return the data.Here i have returned sample data for your easiness.Please provide me the solution.
Following is a code for DefaultReport.designer.cs which will host two subreport
namespace Reporting.Reports.Invoicing{ partial class DefaultInvoice { #region Component Designer generated code /// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); this.CustomerDataSource = new Telerik.Reporting.SqlDataSource(); this.pageFooter = new Telerik.Reporting.PageFooterSection(); this.pageInfoTextBox = new Telerik.Reporting.TextBox(); this.reportHeader = new Telerik.Reporting.ReportHeaderSection(); this.textBox1 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.textBox4 = new Telerik.Reporting.TextBox(); this.textBox2 = new Telerik.Reporting.TextBox(); this.detail = new Telerik.Reporting.DetailSection(); this.textBox15 = new Telerik.Reporting.TextBox(); this.textBox16 = new Telerik.Reporting.TextBox(); this.textBox17 = new Telerik.Reporting.TextBox(); this.pageHeader = new Telerik.Reporting.PageHeaderSection(); this.panel1 = new Telerik.Reporting.Panel(); this.textBox6 = new Telerik.Reporting.TextBox(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.textBox13 = new Telerik.Reporting.TextBox(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox14 = new Telerik.Reporting.TextBox(); this.pictureBox2 = new Telerik.Reporting.PictureBox(); this.panel2 = new Telerik.Reporting.Panel(); this.subReport1 = new Telerik.Reporting.SubReport(); this.invoicePart1 = new Reporting.Reports.Invoicing.InvoicePart(); this.subReport2 = new Telerik.Reporting.SubReport(); this.invoiceSupplementPart1 = new Reporting.Reports.Invoicing.InvoiceSupplementPart(); ((System.ComponentModel.ISupportInitialize)(this.invoicePart1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.invoiceSupplementPart1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // CustomerDataSource // this.CustomerDataSource.CalculatedFields.AddRange(new Telerik.Reporting.CalculatedField[] { new Telerik.Reporting.CalculatedField("PostCodeCity", typeof(string), "=Fields.PostCode + \' \' + Fields.City"), new Telerik.Reporting.CalculatedField("HouseNoStree", typeof(string), "=Fields.HouseNo + \' \' +Fields.Street")}); this.CustomerDataSource.ConnectionString = "ReportingConnection"; this.CustomerDataSource.Name = "CustomerDataSource"; this.CustomerDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@CustomerID", System.Data.DbType.Int64, "=textBox14.Value")}); this.CustomerDataSource.SelectCommand = "USP_GetCustomerDetailsForInvoice"; this.CustomerDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; // // pageFooter // this.pageFooter.Height = new Telerik.Reporting.Drawing.Unit(0.28125D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.pageInfoTextBox}); this.pageFooter.Name = "pageFooter"; // // pageInfoTextBox // this.pageInfoTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.8000001907348633D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.02083333395421505D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pageInfoTextBox.Name = "pageInfoTextBox"; this.pageInfoTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(3.1979167461395264D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pageInfoTextBox.Style.Font.Name = "Arial"; this.pageInfoTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.pageInfoTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.pageInfoTextBox.StyleName = "PageInfo"; this.pageInfoTextBox.Value = "=PageNumber"; // // reportHeader // this.reportHeader.Height = new Telerik.Reporting.Drawing.Unit(0.99992161989212036D, Telerik.Reporting.Drawing.UnitType.Inch); this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox1, this.textBox3, this.textBox4, this.textBox2}); this.reportHeader.Name = "reportHeader"; // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.1000000610947609D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Style.Font.Bold = true; this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox1.Style.Visible = true; this.textBox1.Value = "=Fields.CompanyName"; // // textBox3 // this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Style.Font.Bold = true; this.textBox3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox3.Value = "=Fields.PostCodeCity"; // // textBox4 // this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.69999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000028610229492D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox4.Style.Font.Bold = true; this.textBox4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox4.Value = "=Fields.CountryName"; // // textBox2 // this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.299999862909317D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Style.Font.Bold = true; this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(12D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox2.Value = "=Fields.HouseNoStree"; // // detail // this.detail.Height = new Telerik.Reporting.Drawing.Unit(1.80007803440094D, Telerik.Reporting.Drawing.UnitType.Inch); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel2, this.subReport2}); this.detail.Name = "detail"; this.detail.PageBreak = Telerik.Reporting.PageBreak.None; // // textBox15 // this.textBox15.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.0999990701675415D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.70015782117843628D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox15.Name = "textBox15"; this.textBox15.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(5.600001335144043D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox15.Style.Font.Name = "Arial"; this.textBox15.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox15.Value = "=Fields.InvoicePaymentTerms"; // // textBox16 // this.textBox16.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.50007885694503784D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox16.Name = "textBox16"; this.textBox16.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox16.Style.Font.Name = "Arial"; this.textBox16.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox16.Value = "=Fields.DeafultInvoiceText"; // // textBox17 // this.textBox17.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.70015782117843628D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox17.Name = "textBox17"; this.textBox17.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.1000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox17.Style.Font.Name = "Arial"; this.textBox17.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox17.Value = "Payment terms."; // // pageHeader // this.pageHeader.Height = new Telerik.Reporting.Drawing.Unit(2.4000003337860107D, Telerik.Reporting.Drawing.UnitType.Inch); this.pageHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.panel1, this.pictureBox2}); this.pageHeader.Name = "pageHeader"; // // panel1 // this.panel1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox6, this.textBox7, this.textBox8, this.textBox9, this.textBox10, this.textBox11, this.textBox12, this.textBox13, this.textBox5, this.textBox14}); this.panel1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch)); this.panel1.Name = "panel1"; this.panel1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(3.9375002384185791D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.6999607086181641D, Telerik.Reporting.Drawing.UnitType.Inch)); this.panel1.Style.BorderStyle.Default = Telerik.Reporting.Drawing.BorderType.Solid; // // textBox6 // this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999748170375824D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.1000000610947609D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.8000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Style.Font.Name = "Arial"; this.textBox6.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox6.Value = "Invoice number :"; // // textBox7 // this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999748170375824D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.3999999463558197D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.8000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Style.Font.Name = "Arial"; this.textBox7.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox7.Value = "Relation number :"; // // textBox8 // this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999748170375824D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.699999988079071D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.8000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Style.Font.Name = "Arial"; this.textBox8.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox8.Value = "BTW number relation :"; // // textBox9 // this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999748170375824D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.8000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Style.Font.Name = "Arial"; this.textBox9.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox9.Value = "Date of invoice :"; // // textBox10 // this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999748170375824D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.8000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Style.Font.Name = "Arial"; this.textBox10.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox10.Value = "Paget number :"; // // textBox11 // this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.8999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.3999999463558197D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Style.Font.Name = "Arial"; this.textBox11.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox11.Value = "=Fields.RelationNumber"; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.8999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.70000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Style.Font.Name = "Arial"; this.textBox12.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox12.Value = "=Fields.VATNumber"; // // textBox13 // this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.9000005722045898D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox13.Name = "textBox13"; this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox13.Style.Font.Name = "Arial"; this.textBox13.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox13.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Left; this.textBox13.StyleName = "PageInfo"; this.textBox13.Value = "=PageNumber"; // // textBox5 // this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Style.Font.Name = "Arial"; this.textBox5.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox5.Value = "28"; // // textBox14 // this.textBox14.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox14.Name = "textBox14"; this.textBox14.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7999998927116394D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox14.Style.Font.Name = "Arial"; this.textBox14.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox14.Value = "30"; // // pictureBox2 // this.pictureBox2.Bindings.Add(new Telerik.Reporting.Binding("Value", "=Fields.TransportCompanyLogo")); this.pictureBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pictureBox2.Name = "pictureBox2"; this.pictureBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(170D, Telerik.Reporting.Drawing.UnitType.Pixel), new Telerik.Reporting.Drawing.Unit(40D, Telerik.Reporting.Drawing.UnitType.Pixel)); // // panel2 // this.panel2.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.subReport1, this.textBox16, this.textBox17, this.textBox15}); this.panel2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.10007794946432114D, Telerik.Reporting.Drawing.UnitType.Inch)); this.panel2.Name = "panel2"; this.panel2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.90015792846679688D, Telerik.Reporting.Drawing.UnitType.Inch)); // // subReport1 // this.subReport1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.subReport1.Name = "subReport1"; this.subReport1.Parameters.Add(new Telerik.Reporting.Parameter("InvoiceId", "28")); this.subReport1.Parameters.Add(new Telerik.Reporting.Parameter("VAT", "=Fields.VAT")); this.subReport1.ReportSource = this.invoicePart1; this.subReport1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch)); // // subReport2 // this.subReport2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(1.1000782251358032D, Telerik.Reporting.Drawing.UnitType.Inch)); this.subReport2.Name = "subReport2"; this.subReport2.ReportSource = this.invoiceSupplementPart1; this.subReport2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.7000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.69999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch)); // // DefaultInvoice // this.DataSource = this.CustomerDataSource; this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.pageHeader, this.pageFooter, this.reportHeader, this.detail}); this.PageNumberingStyle = Telerik.Reporting.PageNumberingStyle.ResetNumbering; this.PageSettings.Landscape = false; this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(0.5D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Title")}); styleRule1.Style.Color = System.Drawing.Color.Black; styleRule1.Style.Font.Bold = true; styleRule1.Style.Font.Italic = false; styleRule1.Style.Font.Name = "Tahoma"; styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(20D, Telerik.Reporting.Drawing.UnitType.Point); styleRule1.Style.Font.Strikeout = false; styleRule1.Style.Font.Underline = false; styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Caption")}); styleRule2.Style.Color = System.Drawing.Color.Black; styleRule2.Style.Font.Name = "Tahoma"; styleRule2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Data")}); styleRule3.Style.Font.Name = "Tahoma"; styleRule3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("PageInfo")}); styleRule4.Style.Font.Name = "Tahoma"; styleRule4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4}); this.Width = new Telerik.Reporting.Drawing.Unit(7.0000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch); ((System.ComponentModel.ISupportInitialize)(this.invoicePart1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.invoiceSupplementPart1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); } #endregion private Telerik.Reporting.SqlDataSource CustomerDataSource; private Telerik.Reporting.PageFooterSection pageFooter; private Telerik.Reporting.TextBox pageInfoTextBox; private Telerik.Reporting.ReportHeaderSection reportHeader; private Telerik.Reporting.DetailSection detail; private Telerik.Reporting.TextBox textBox1; private Telerik.Reporting.TextBox textBox3; private Telerik.Reporting.TextBox textBox4; private Telerik.Reporting.TextBox textBox2; private Telerik.Reporting.PageHeaderSection pageHeader; private Telerik.Reporting.Panel panel1; private Telerik.Reporting.TextBox textBox6; private Telerik.Reporting.TextBox textBox7; private Telerik.Reporting.TextBox textBox8; private Telerik.Reporting.TextBox textBox9; private Telerik.Reporting.TextBox textBox10; private Telerik.Reporting.TextBox textBox11; private Telerik.Reporting.TextBox textBox12; private Telerik.Reporting.TextBox textBox13; private Telerik.Reporting.PictureBox pictureBox2; private Telerik.Reporting.TextBox textBox5; private Telerik.Reporting.TextBox textBox14; private Telerik.Reporting.TextBox textBox15; private Telerik.Reporting.TextBox textBox16; private Telerik.Reporting.TextBox textBox17; private Telerik.Reporting.SubReport subReport1; private Telerik.Reporting.Panel panel2; private InvoicePart invoicePart1; private Telerik.Reporting.SubReport subReport2; private InvoiceSupplementPart invoiceSupplementPart1; }}First Sub Report (InvoicePart.Designer.cs)
namespace Reporting.Reports.Invoicing{ partial class InvoicePart { #region Component Designer generated code /// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.ReportParameter reportParameter2 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); this.InvoicePartDataSource = new Telerik.Reporting.SqlDataSource(); this.detail = new Telerik.Reporting.DetailSection(); this.textBox1 = new Telerik.Reporting.TextBox(); this.textBox2 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.textBox10 = new Telerik.Reporting.TextBox(); this.reportHeaderSection1 = new Telerik.Reporting.ReportHeaderSection(); this.textBox4 = new Telerik.Reporting.TextBox(); this.shape1 = new Telerik.Reporting.Shape(); this.textBox9 = new Telerik.Reporting.TextBox(); this.textBox8 = new Telerik.Reporting.TextBox(); this.textBox7 = new Telerik.Reporting.TextBox(); this.textBox6 = new Telerik.Reporting.TextBox(); this.shape2 = new Telerik.Reporting.Shape(); this.reportFooterSection1 = new Telerik.Reporting.ReportFooterSection(); this.txtNetToal = new Telerik.Reporting.TextBox(); this.textBox11 = new Telerik.Reporting.TextBox(); this.textBox12 = new Telerik.Reporting.TextBox(); this.shape3 = new Telerik.Reporting.Shape(); this.txtVatAmount = new Telerik.Reporting.TextBox(); this.shape4 = new Telerik.Reporting.Shape(); this.textBox5 = new Telerik.Reporting.TextBox(); this.textBox13 = new Telerik.Reporting.TextBox(); this.shape5 = new Telerik.Reporting.Shape(); this.shape6 = new Telerik.Reporting.Shape(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // InvoicePartDataSource // this.InvoicePartDataSource.ConnectionString = "ReportingConnection"; this.InvoicePartDataSource.Name = "InvoicePartDataSource"; this.InvoicePartDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@InvoiceId", System.Data.DbType.Int64, "=Parameters.InvoiceId.Value")}); this.InvoicePartDataSource.SelectCommand = "USP_InvoiceMasterForInvoiceReport"; this.InvoicePartDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; // // detail // this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.21875007450580597D, Telerik.Reporting.Drawing.UnitType.Inch); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox1, this.textBox2, this.textBox3, this.textBox10}); this.detail.Name = "detail"; // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox1.Value = "=Fields.OrderID"; // // textBox2 // this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.4000000953674316D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox2.Style.Visible = true; this.textBox2.Value = "=Fields.OrderNumber"; // // textBox3 // this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.9000003337860107D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox3.Value = "=Fields.TariffName"; // // textBox10 // this.textBox10.Format = "{0:N2}"; this.textBox10.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.018750032410025597D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Name = "textBox10"; this.textBox10.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0999997854232788D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox10.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox10.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox10.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",Fields.OrderPrice)"; // // reportHeaderSection1 // this.reportHeaderSection1.Height = new Telerik.Reporting.Drawing.Unit(0.7000001072883606D, Telerik.Reporting.Drawing.UnitType.Inch); this.reportHeaderSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.textBox4, this.shape1, this.textBox9, this.textBox8, this.textBox7, this.textBox6, this.shape2}); this.reportHeaderSection1.Name = "reportHeaderSection1"; // // textBox4 // this.textBox4.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox4.Name = "textBox4"; this.textBox4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox4.Style.Font.Bold = false; this.textBox4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(16D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox4.Value = "INVOICE"; // // shape1 // this.shape1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.30000004172325134D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape1.Name = "shape1"; this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.1000000610947609D, Telerik.Reporting.Drawing.UnitType.Inch)); // // textBox9 // this.textBox9.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3020834922790527D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Name = "textBox9"; this.textBox9.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0979169607162476D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox9.Style.Font.Bold = true; this.textBox9.Style.Font.Italic = true; this.textBox9.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox9.Value = "Price"; // // textBox8 // this.textBox8.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.90625D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Name = "textBox8"; this.textBox8.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(2.2999999523162842D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox8.Style.Font.Bold = true; this.textBox8.Style.Font.Italic = true; this.textBox8.Value = "Description"; // // textBox7 // this.textBox7.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.40625D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Name = "textBox7"; this.textBox7.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3999999761581421D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox7.Style.Font.Bold = true; this.textBox7.Style.Font.Italic = true; this.textBox7.Value = "Reference"; // // textBox6 // this.textBox6.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.1041666641831398D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.40000000596046448D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Name = "textBox6"; this.textBox6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox6.Style.Font.Bold = true; this.textBox6.Style.Font.Italic = true; this.textBox6.Value = "Order Number"; // // shape2 // this.shape2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape2.Name = "shape2"; this.shape2.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.1000000610947609D, Telerik.Reporting.Drawing.UnitType.Inch)); // // reportFooterSection1 // this.reportFooterSection1.Height = new Telerik.Reporting.Drawing.Unit(1.0812498331069946D, Telerik.Reporting.Drawing.UnitType.Inch); this.reportFooterSection1.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.txtNetToal, this.textBox11, this.textBox12, this.shape3, this.txtVatAmount, this.shape4, this.textBox5, this.textBox13, this.shape5, this.shape6}); this.reportFooterSection1.Name = "reportFooterSection1"; // // txtNetToal // this.txtNetToal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.18124993145465851D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNetToal.Name = "txtNetToal"; this.txtNetToal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0999997854232788D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtNetToal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.txtNetToal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.txtNetToal.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\", Sum(Fields.OrderPrice* Fields.Mo" + "de))"; // // textBox11 // this.textBox11.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.18124993145465851D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Name = "textBox11"; this.textBox11.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.3000001907348633D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox11.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox11.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox11.Value = "Net"; // // textBox12 // this.textBox12.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124990463256836D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Name = "textBox12"; this.textBox12.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.3000001907348633D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox12.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox12.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox12.Value = "= Parameters.VAT.Value + \' % VAT\'"; // // shape3 // this.shape3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.081249870359897614D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape3.Name = "shape3"; this.shape3.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999998331069946D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999904632568359D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); // // txtVatAmount // this.txtVatAmount.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3020834922790527D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38132873177528381D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtVatAmount.Name = "txtVatAmount"; this.txtVatAmount.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.0979169607162476D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtVatAmount.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.txtVatAmount.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.txtVatAmount.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\", (Parameters.VAT.Value * (Sum(F" + "ields.OrderPrice * Fields.Mode)) /100))"; // // shape4 // this.shape4.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.5812498927116394D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape4.Name = "shape4"; this.shape4.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape4.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999998331069946D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999904632568359D, Telerik.Reporting.Drawing.UnitType.Inch)); // // textBox5 // this.textBox5.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.68124991655349731D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Name = "textBox5"; this.textBox5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(4.3000001907348633D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000012218952179D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox5.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox5.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox5.Value = "Net"; // // textBox13 // this.textBox13.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.68124991655349731D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox13.Name = "textBox13"; this.textBox13.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999998331069946D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox13.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox13.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox13.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",( Sum(Fields.OrderPrice * Fields." + "Mode) + ( Sum(Fields.OrderPrice * Fields.Mode) * Parameters.VAT.Value/100 ) ))"; // // shape5 // this.shape5.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.88124990463256836D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape5.Name = "shape5"; this.shape5.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape5.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999998331069946D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999904632568359D, Telerik.Reporting.Drawing.UnitType.Inch)); // // shape6 // this.shape6.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.98124980926513672D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape6.Name = "shape6"; this.shape6.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape6.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2999998331069946D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.099999904632568359D, Telerik.Reporting.Drawing.UnitType.Inch)); // // InvoicePart // this.DataSource = this.InvoicePartDataSource; this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.detail, this.reportHeaderSection1, this.reportFooterSection1}); this.PageSettings.Landscape = false; this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; reportParameter1.Name = "InvoiceId"; reportParameter1.Text = "InvoiceId"; reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter2.Name = "VAT"; reportParameter2.Type = Telerik.Reporting.ReportParameterType.Integer; this.ReportParameters.Add(reportParameter1); this.ReportParameters.Add(reportParameter2); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Title")}); styleRule1.Style.Color = System.Drawing.Color.Black; styleRule1.Style.Font.Bold = true; styleRule1.Style.Font.Italic = false; styleRule1.Style.Font.Name = "Tahoma"; styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(20D, Telerik.Reporting.Drawing.UnitType.Point); styleRule1.Style.Font.Strikeout = false; styleRule1.Style.Font.Underline = false; styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Caption")}); styleRule2.Style.Color = System.Drawing.Color.Black; styleRule2.Style.Font.Name = "Tahoma"; styleRule2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Data")}); styleRule3.Style.Font.Name = "Tahoma"; styleRule3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("PageInfo")}); styleRule4.Style.Font.Name = "Tahoma"; styleRule4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4}); this.Width = new Telerik.Reporting.Drawing.Unit(6.5D, Telerik.Reporting.Drawing.UnitType.Inch); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); } #endregion private Telerik.Reporting.SqlDataSource InvoicePartDataSource; private Telerik.Reporting.DetailSection detail; private Telerik.Reporting.TextBox textBox1; private Telerik.Reporting.TextBox textBox2; private Telerik.Reporting.TextBox textBox3; private Telerik.Reporting.TextBox textBox10; private Telerik.Reporting.ReportHeaderSection reportHeaderSection1; private Telerik.Reporting.TextBox textBox4; private Telerik.Reporting.Shape shape1; private Telerik.Reporting.TextBox textBox9; private Telerik.Reporting.TextBox textBox8; private Telerik.Reporting.TextBox textBox7; private Telerik.Reporting.TextBox textBox6; private Telerik.Reporting.Shape shape2; private Telerik.Reporting.ReportFooterSection reportFooterSection1; private Telerik.Reporting.TextBox txtNetToal; private Telerik.Reporting.TextBox textBox11; private Telerik.Reporting.TextBox textBox12; private Telerik.Reporting.Shape shape3; private Telerik.Reporting.TextBox txtVatAmount; private Telerik.Reporting.Shape shape4; private Telerik.Reporting.TextBox textBox5; private Telerik.Reporting.TextBox textBox13; private Telerik.Reporting.Shape shape5; private Telerik.Reporting.Shape shape6; }}Second SubReport (InvoiceSupplementPartDesigner.cs)
namespace Reporting.Reports.Invoicing{ partial class InvoiceSupplementPart { #region Component Designer generated code /// <summary> /// Required method for telerik Reporting designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { Telerik.Reporting.Drawing.FormattingRule formattingRule3 = new Telerik.Reporting.Drawing.FormattingRule(); Telerik.Reporting.Drawing.FormattingRule formattingRule4 = new Telerik.Reporting.Drawing.FormattingRule(); Telerik.Reporting.Drawing.FormattingRule formattingRule1 = new Telerik.Reporting.Drawing.FormattingRule(); Telerik.Reporting.Drawing.FormattingRule formattingRule2 = new Telerik.Reporting.Drawing.FormattingRule(); Telerik.Reporting.ReportParameter reportParameter1 = new Telerik.Reporting.ReportParameter(); Telerik.Reporting.Drawing.StyleRule styleRule1 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule2 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule3 = new Telerik.Reporting.Drawing.StyleRule(); Telerik.Reporting.Drawing.StyleRule styleRule4 = new Telerik.Reporting.Drawing.StyleRule(); this.InvoiceSupplementPartDataSource = new Telerik.Reporting.SqlDataSource(); this.orderIDGroupHeader = new Telerik.Reporting.GroupHeaderSection(); this.orderIDDataTextBox = new Telerik.Reporting.TextBox(); this.orderIDCaptionTextBox = new Telerik.Reporting.TextBox(); this.orderIDGroupFooter = new Telerik.Reporting.GroupFooterSection(); this.orderIDGroup = new Telerik.Reporting.Group(); this.reportHeader = new Telerik.Reporting.ReportHeaderSection(); this.titleTextBox = new Telerik.Reporting.TextBox(); this.detail = new Telerik.Reporting.DetailSection(); this.descriptionDataTextBox1 = new Telerik.Reporting.TextBox(); this.pricePerAmountDataTextBox1 = new Telerik.Reporting.TextBox(); this.amountDataTextBox1 = new Telerik.Reporting.TextBox(); this.pricePerAmount2DataTextBox1 = new Telerik.Reporting.TextBox(); this.amount2DataTextBox1 = new Telerik.Reporting.TextBox(); this.textBox3 = new Telerik.Reporting.TextBox(); this.shape2 = new Telerik.Reporting.Shape(); this.descriptionCaptionTextBox = new Telerik.Reporting.TextBox(); this.pricePerAmountCaptionTextBox = new Telerik.Reporting.TextBox(); this.amountCaptionTextBox = new Telerik.Reporting.TextBox(); this.pricePerAmount2CaptionTextBox = new Telerik.Reporting.TextBox(); this.amount2CaptionTextBox = new Telerik.Reporting.TextBox(); this.textBox1 = new Telerik.Reporting.TextBox(); this.shape1 = new Telerik.Reporting.Shape(); this.textBox2 = new Telerik.Reporting.TextBox(); this.txtGrandTotal = new Telerik.Reporting.TextBox(); ((System.ComponentModel.ISupportInitialize)(this)).BeginInit(); // // InvoiceSupplementPartDataSource // this.InvoiceSupplementPartDataSource.ConnectionString = "ReportingConnection"; this.InvoiceSupplementPartDataSource.Name = "InvoiceSupplementPartDataSource"; this.InvoiceSupplementPartDataSource.Parameters.AddRange(new Telerik.Reporting.SqlDataSourceParameter[] { new Telerik.Reporting.SqlDataSourceParameter("@InvoiceID", System.Data.DbType.Int64, "=Parameters.InvoiceID.Value")}); this.InvoiceSupplementPartDataSource.SelectCommand = "USP_InvoiceDetailForInvoiceReport"; this.InvoiceSupplementPartDataSource.SelectCommandType = Telerik.Reporting.SqlDataSourceCommandType.StoredProcedure; // // orderIDGroupHeader // this.orderIDGroupHeader.Height = new Telerik.Reporting.Drawing.Unit(0.78125005960464478D, Telerik.Reporting.Drawing.UnitType.Inch); this.orderIDGroupHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.orderIDDataTextBox, this.orderIDCaptionTextBox, this.shape2, this.descriptionCaptionTextBox, this.pricePerAmountCaptionTextBox, this.amountCaptionTextBox, this.pricePerAmount2CaptionTextBox, this.amount2CaptionTextBox, this.textBox1, this.shape1}); this.orderIDGroupHeader.Name = "orderIDGroupHeader"; // // orderIDDataTextBox // this.orderIDDataTextBox.CanGrow = true; this.orderIDDataTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.60000008344650269D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.orderIDDataTextBox.Name = "orderIDDataTextBox"; this.orderIDDataTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.orderIDDataTextBox.Style.Font.Bold = true; this.orderIDDataTextBox.Style.Font.Italic = false; this.orderIDDataTextBox.Style.Font.Name = "Arial"; this.orderIDDataTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.orderIDDataTextBox.StyleName = "Data"; this.orderIDDataTextBox.Value = "=Fields.OrderID"; // // orderIDCaptionTextBox // this.orderIDCaptionTextBox.CanGrow = true; this.orderIDCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.orderIDCaptionTextBox.Name = "orderIDCaptionTextBox"; this.orderIDCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.50000005960464478D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.orderIDCaptionTextBox.Style.Font.Bold = true; this.orderIDCaptionTextBox.Style.Font.Name = "Arial"; this.orderIDCaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.orderIDCaptionTextBox.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.orderIDCaptionTextBox.StyleName = "Caption"; this.orderIDCaptionTextBox.Value = "Order "; // // orderIDGroupFooter // this.orderIDGroupFooter.Height = new Telerik.Reporting.Drawing.Unit(0.28541675209999084D, Telerik.Reporting.Drawing.UnitType.Inch); this.orderIDGroupFooter.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.txtGrandTotal, this.textBox2}); this.orderIDGroupFooter.Name = "orderIDGroupFooter"; // // orderIDGroup // this.orderIDGroup.GroupFooter = this.orderIDGroupFooter; this.orderIDGroup.GroupHeader = this.orderIDGroupHeader; this.orderIDGroup.Groupings.AddRange(new Telerik.Reporting.Data.Grouping[] { new Telerik.Reporting.Data.Grouping("=Fields.OrderID")}); this.orderIDGroup.Name = "orderIDGroup"; // // reportHeader // this.reportHeader.Height = new Telerik.Reporting.Drawing.Unit(0.41875004768371582D, Telerik.Reporting.Drawing.UnitType.Inch); this.reportHeader.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.titleTextBox}); this.reportHeader.Name = "reportHeader"; // // titleTextBox // this.titleTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.titleTextBox.Name = "titleTextBox"; this.titleTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.4583334922790527D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.41875004768371582D, Telerik.Reporting.Drawing.UnitType.Inch)); this.titleTextBox.Style.Font.Bold = false; this.titleTextBox.Style.Font.Name = "Arial"; this.titleTextBox.StyleName = "Title"; this.titleTextBox.Value = "Supplement"; // // detail // this.detail.Height = new Telerik.Reporting.Drawing.Unit(0.28125D, Telerik.Reporting.Drawing.UnitType.Inch); this.detail.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.descriptionDataTextBox1, this.pricePerAmountDataTextBox1, this.amountDataTextBox1, this.pricePerAmount2DataTextBox1, this.amount2DataTextBox1, this.textBox3}); this.detail.Name = "detail"; this.detail.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); // // descriptionDataTextBox1 // this.descriptionDataTextBox1.CanGrow = true; this.descriptionDataTextBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.descriptionDataTextBox1.Name = "descriptionDataTextBox1"; this.descriptionDataTextBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.5729166269302368D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.descriptionDataTextBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.descriptionDataTextBox1.StyleName = "Data"; this.descriptionDataTextBox1.Value = "=Fields.Description"; // // pricePerAmountDataTextBox1 // this.pricePerAmountDataTextBox1.CanGrow = true; this.pricePerAmountDataTextBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.8000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmountDataTextBox1.Name = "pricePerAmountDataTextBox1"; this.pricePerAmountDataTextBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.699999988079071D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmountDataTextBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.pricePerAmountDataTextBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.pricePerAmountDataTextBox1.StyleName = "Data"; this.pricePerAmountDataTextBox1.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",Fields.PricePerAmount)"; // // amountDataTextBox1 // this.amountDataTextBox1.CanGrow = true; this.amountDataTextBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.6000001430511475D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amountDataTextBox1.Name = "amountDataTextBox1"; this.amountDataTextBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7000001072883606D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amountDataTextBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.amountDataTextBox1.StyleName = "Data"; this.amountDataTextBox1.Value = "= Format(\"{0:N2}\",Fields.Amount)"; // // pricePerAmount2DataTextBox1 // this.pricePerAmount2DataTextBox1.CanGrow = true; formattingRule3.Filters.AddRange(new Telerik.Reporting.Data.Filter[] { new Telerik.Reporting.Data.Filter("=Fields.TariffTypeID", Telerik.Reporting.Data.FilterOperator.NotEqual, "=8")}); formattingRule3.Style.Visible = false; this.pricePerAmount2DataTextBox1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] { formattingRule3}); this.pricePerAmount2DataTextBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.4000003337860107D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmount2DataTextBox1.Name = "pricePerAmount2DataTextBox1"; this.pricePerAmount2DataTextBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.69999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmount2DataTextBox1.Style.Font.Name = "Arial"; this.pricePerAmount2DataTextBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.pricePerAmount2DataTextBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.pricePerAmount2DataTextBox1.Style.Visible = true; this.pricePerAmount2DataTextBox1.StyleName = "Data"; this.pricePerAmount2DataTextBox1.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",Fields.PricePerAmount2)"; // // amount2DataTextBox1 // this.amount2DataTextBox1.CanGrow = true; formattingRule4.Filters.AddRange(new Telerik.Reporting.Data.Filter[] { new Telerik.Reporting.Data.Filter("=Fields.TariffTypeID", Telerik.Reporting.Data.FilterOperator.NotEqual, "=8")}); formattingRule4.Style.Visible = false; this.amount2DataTextBox1.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] { formattingRule4}); this.amount2DataTextBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.2000002861022949D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(3.9418537198798731E-05D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amount2DataTextBox1.Name = "amount2DataTextBox1"; this.amount2DataTextBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.900000274181366D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amount2DataTextBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.amount2DataTextBox1.Style.Visible = true; this.amount2DataTextBox1.StyleName = "Data"; this.amount2DataTextBox1.Value = "= Format(\"{0:N2}\",Fields.Amount2)"; // // textBox3 // this.textBox3.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Name = "textBox3"; this.textBox3.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2000007629394531D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox3.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox3.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",( (Fields.PricePerAmount* Fields." + "Amount) \r\n + ( IsNull(Fields.PricePerAmount2,0) * IsNull(Fields.Amount2,0) " + "))\r\n )\r\n"; // // shape2 // this.shape2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.2604166567325592D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape2.Name = "shape2"; this.shape2.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.5D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0520833320915699D, Telerik.Reporting.Drawing.UnitType.Inch)); // // descriptionCaptionTextBox // this.descriptionCaptionTextBox.CanGrow = true; this.descriptionCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0.099999986588954926D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.descriptionCaptionTextBox.Name = "descriptionCaptionTextBox"; this.descriptionCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.5729166269302368D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.descriptionCaptionTextBox.Style.Font.Bold = true; this.descriptionCaptionTextBox.Style.Font.Italic = true; this.descriptionCaptionTextBox.Style.Font.Name = "Arial"; this.descriptionCaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.descriptionCaptionTextBox.StyleName = "Caption"; this.descriptionCaptionTextBox.Value = "Description"; // // pricePerAmountCaptionTextBox // this.pricePerAmountCaptionTextBox.CanGrow = true; this.pricePerAmountCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(1.8000000715255737D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmountCaptionTextBox.Name = "pricePerAmountCaptionTextBox"; this.pricePerAmountCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.699999988079071D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmountCaptionTextBox.Style.Font.Bold = true; this.pricePerAmountCaptionTextBox.Style.Font.Italic = true; this.pricePerAmountCaptionTextBox.Style.Font.Name = "Arial"; this.pricePerAmountCaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.pricePerAmountCaptionTextBox.StyleName = "Caption"; this.pricePerAmountCaptionTextBox.Value = "Price Per Amount"; // // amountCaptionTextBox // this.amountCaptionTextBox.CanGrow = true; this.amountCaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(2.7000000476837158D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amountCaptionTextBox.Name = "amountCaptionTextBox"; this.amountCaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.7000001072883606D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amountCaptionTextBox.Style.Font.Bold = true; this.amountCaptionTextBox.Style.Font.Italic = true; this.amountCaptionTextBox.Style.Font.Name = "Arial"; this.amountCaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.amountCaptionTextBox.StyleName = "Caption"; this.amountCaptionTextBox.Value = "Amount"; // // pricePerAmount2CaptionTextBox // this.pricePerAmount2CaptionTextBox.CanGrow = true; formattingRule1.Filters.AddRange(new Telerik.Reporting.Data.Filter[] { new Telerik.Reporting.Data.Filter("=Fields.TariffTypeID", Telerik.Reporting.Data.FilterOperator.NotEqual, "=8")}); formattingRule1.Style.Visible = false; this.pricePerAmount2CaptionTextBox.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] { formattingRule1}); this.pricePerAmount2CaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(3.5D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmount2CaptionTextBox.Name = "pricePerAmount2CaptionTextBox"; this.pricePerAmount2CaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.69999980926513672D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.pricePerAmount2CaptionTextBox.Style.Font.Bold = true; this.pricePerAmount2CaptionTextBox.Style.Font.Italic = true; this.pricePerAmount2CaptionTextBox.Style.Font.Name = "Arial"; this.pricePerAmount2CaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.pricePerAmount2CaptionTextBox.Style.Visible = true; this.pricePerAmount2CaptionTextBox.StyleName = "Caption"; this.pricePerAmount2CaptionTextBox.Value = "Price Per Amount2"; // // amount2CaptionTextBox // this.amount2CaptionTextBox.CanGrow = true; formattingRule2.Filters.AddRange(new Telerik.Reporting.Data.Filter[] { new Telerik.Reporting.Data.Filter("=Fields.TariffTypeID", Telerik.Reporting.Data.FilterOperator.NotEqual, "=8")}); formattingRule2.Style.Visible = false; this.amount2CaptionTextBox.ConditionalFormatting.AddRange(new Telerik.Reporting.Drawing.FormattingRule[] { formattingRule2}); this.amount2CaptionTextBox.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.3000001907348633D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amount2CaptionTextBox.Name = "amount2CaptionTextBox"; this.amount2CaptionTextBox.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(0.900000274181366D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.20000000298023224D, Telerik.Reporting.Drawing.UnitType.Inch)); this.amount2CaptionTextBox.Style.Font.Bold = true; this.amount2CaptionTextBox.Style.Font.Italic = true; this.amount2CaptionTextBox.Style.Font.Name = "Arial"; this.amount2CaptionTextBox.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(10D, Telerik.Reporting.Drawing.UnitType.Point); this.amount2CaptionTextBox.Style.Visible = true; this.amount2CaptionTextBox.StyleName = "Caption"; this.amount2CaptionTextBox.Value = "Amount2"; // // textBox1 // this.textBox1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.3000006675720215D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.38124999403953552D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Name = "textBox1"; this.textBox1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.2000007629394531D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox1.Style.Font.Bold = true; this.textBox1.Style.Font.Italic = true; this.textBox1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox1.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox1.Value = "Price"; // // shape1 // this.shape1.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(0D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.58124995231628418D, Telerik.Reporting.Drawing.UnitType.Inch)); this.shape1.Name = "shape1"; this.shape1.ShapeType = new Telerik.Reporting.Drawing.Shapes.LineShape(Telerik.Reporting.Drawing.Shapes.LineDirection.EW); this.shape1.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(6.5D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.0520833320915699D, Telerik.Reporting.Drawing.UnitType.Inch)); // // textBox2 // this.textBox2.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(4.0999999046325684D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.085416793823242188D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Name = "textBox2"; this.textBox2.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.textBox2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.textBox2.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.textBox2.Value = "Total"; // // txtGrandTotal // this.txtGrandTotal.Location = new Telerik.Reporting.Drawing.PointU(new Telerik.Reporting.Drawing.Unit(5.1000003814697266D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.085416793823242188D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtGrandTotal.Name = "txtGrandTotal"; this.txtGrandTotal.Size = new Telerik.Reporting.Drawing.SizeU(new Telerik.Reporting.Drawing.Unit(1.3000005483627319D, Telerik.Reporting.Drawing.UnitType.Inch), new Telerik.Reporting.Drawing.Unit(0.19999997317790985D, Telerik.Reporting.Drawing.UnitType.Inch)); this.txtGrandTotal.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(9D, Telerik.Reporting.Drawing.UnitType.Point); this.txtGrandTotal.Style.TextAlign = Telerik.Reporting.Drawing.HorizontalAlign.Right; this.txtGrandTotal.Value = "= Fields.CurrencySymbol + \' \' + Format(\"{0:N2}\",(Sum( (Fields.PricePerAmount* Fie" + "lds.Amount) \r\n + ( IsNull(Fields.PricePerAmount2,0) * IsNull(Fields.Amount2" + ",0) )))\r\n )\r\n"; // // InvoiceSupplementPart // this.DataSource = this.InvoiceSupplementPartDataSource; this.Groups.AddRange(new Telerik.Reporting.Group[] { this.orderIDGroup}); this.Items.AddRange(new Telerik.Reporting.ReportItemBase[] { this.orderIDGroupHeader, this.orderIDGroupFooter, this.reportHeader, this.detail}); this.PageSettings.Landscape = false; this.PageSettings.Margins.Bottom = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Left = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Right = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.Margins.Top = new Telerik.Reporting.Drawing.Unit(1D, Telerik.Reporting.Drawing.UnitType.Inch); this.PageSettings.PaperKind = System.Drawing.Printing.PaperKind.Letter; reportParameter1.Name = "InvoiceID"; reportParameter1.Text = "InvoiceID"; reportParameter1.Type = Telerik.Reporting.ReportParameterType.Integer; reportParameter1.Value = "28"; this.ReportParameters.Add(reportParameter1); this.Style.BackgroundColor = System.Drawing.Color.White; styleRule1.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Title")}); styleRule1.Style.Color = System.Drawing.Color.Black; styleRule1.Style.Font.Bold = true; styleRule1.Style.Font.Italic = false; styleRule1.Style.Font.Name = "Tahoma"; styleRule1.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(20D, Telerik.Reporting.Drawing.UnitType.Point); styleRule1.Style.Font.Strikeout = false; styleRule1.Style.Font.Underline = false; styleRule2.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Caption")}); styleRule2.Style.Color = System.Drawing.Color.Black; styleRule2.Style.Font.Name = "Tahoma"; styleRule2.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule2.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule3.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("Data")}); styleRule3.Style.Font.Name = "Tahoma"; styleRule3.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule3.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; styleRule4.Selectors.AddRange(new Telerik.Reporting.Drawing.ISelector[] { new Telerik.Reporting.Drawing.StyleSelector("PageInfo")}); styleRule4.Style.Font.Name = "Tahoma"; styleRule4.Style.Font.Size = new Telerik.Reporting.Drawing.Unit(11D, Telerik.Reporting.Drawing.UnitType.Point); styleRule4.Style.VerticalAlign = Telerik.Reporting.Drawing.VerticalAlign.Middle; this.StyleSheet.AddRange(new Telerik.Reporting.Drawing.StyleRule[] { styleRule1, styleRule2, styleRule3, styleRule4}); this.Width = new Telerik.Reporting.Drawing.Unit(6.5D, Telerik.Reporting.Drawing.UnitType.Inch); ((System.ComponentModel.ISupportInitialize)(this)).EndInit(); } #endregion private Telerik.Reporting.SqlDataSource InvoiceSupplementPartDataSource; private Telerik.Reporting.GroupHeaderSection orderIDGroupHeader; private Telerik.Reporting.TextBox orderIDDataTextBox; private Telerik.Reporting.GroupFooterSection orderIDGroupFooter; private Telerik.Reporting.Group orderIDGroup; private Telerik.Reporting.ReportHeaderSection reportHeader; private Telerik.Reporting.TextBox titleTextBox; private Telerik.Reporting.DetailSection detail; private Telerik.Reporting.TextBox descriptionDataTextBox1; private Telerik.Reporting.TextBox pricePerAmountDataTextBox1; private Telerik.Reporting.TextBox amountDataTextBox1; private Telerik.Reporting.TextBox pricePerAmount2DataTextBox1; private Telerik.Reporting.TextBox amount2DataTextBox1; private Telerik.Reporting.TextBox orderIDCaptionTextBox; private Telerik.Reporting.TextBox textBox3; private Telerik.Reporting.Shape shape2; private Telerik.Reporting.TextBox descriptionCaptionTextBox; private Telerik.Reporting.TextBox pricePerAmountCaptionTextBox; private Telerik.Reporting.TextBox amountCaptionTextBox; private Telerik.Reporting.TextBox pricePerAmount2CaptionTextBox; private Telerik.Reporting.TextBox amount2CaptionTextBox; private Telerik.Reporting.TextBox textBox1; private Telerik.Reporting.Shape shape1; private Telerik.Reporting.TextBox txtGrandTotal; private Telerik.Reporting.TextBox textBox2; }}CREATE PROCEDURE [dbo].[USP_GetCustomerDetailsForInvoice]
(
@CustomerID BIGINT = NULL
)
AS
BEGIN
SET @CustomerID = 30
select 'TestCompany' as CompanyName,
'1100' as PostCode,'15' as HouseNo,
'121' as Street,
'Zootermeer' as City,
'NetherLands' as CountryName,
NULL as TransportCompanyLogo,
' - ' as RelationNumber,
' - ' as VATNumber,
19.00 as VAT,
'Yet to set ' as DeafultInvoiceText,
'Yet to set ' as InvoicePaymentTerms
END
CREATE PROCEDURE [dbo].[USP_InvoiceDetailForInvoiceReport]
(
@InvoiceID BIGINT =NULL
)
AS
BEGIN
Select 28 as InvoiceID,
51 as OrderID,
'Hour' as Description,
20.00 as PricePerAmount,
15.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
2 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
52 as OrderID,
'KM' as Description,
20.00 as PricePerAmount,
25.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
3 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
57 as OrderID,
'Freight' as Description,
200.00 as PricePerAmount,
1.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
4 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
127 as OrderID,
'Hour & KM' as Description,
17.00 as PricePerAmount,
10.00 as Amount,
16.00 as PricePerAmount2,
15.00 as Amount2,
'€' as CurrencySymbol,
8 as TariffTypeID
UNION ALL
Select 28 as InvoiceID,
59 as OrderID,
'SCC' as Description,
23.00 as PricePerAmount,
50.00 as Amount,
NULL as PricePerAmount2,
NULL as Amount2,
'€' as CurrencySymbol,
1 as TariffTypeID
END
CREATE PROCEDURE [dbo].[USP_InvoiceMasterForInvoiceReport]
(
@InvoiceId BIGINT = NULL
)
AS
BEGIN
select 51 as OrderID,
'X0010' as OrderNumber,
'Hour' as TariffName,
'€' as CurrencySymbol,
330.0000 as OrderPrice,
1 as Mode
UNION ALL
select 52 as OrderID,
'X0011' as OrderNumber,
'KM' as TariffName,
'€' as CurrencySymbol,
550.0000 as OrderPrice,
1 as Mode
UNION ALL
select 57 as OrderID,
'X0014' as OrderNumber,
'Freight' as TariffName,
'€' as CurrencySymbol,
220.0000 as OrderPrice,
1 as Mode
UNION ALL
select 59 as OrderID,
'X0015' as OrderNumber,
'Amount' as TariffName,
'€' as CurrencySymbol,
1265.0000 as OrderPrice,
1 as Mode
UNION ALL
select 127 as OrderID,
'X0025' as OrderNumber,
'Hour & KM' as TariffName,
'€' as CurrencySymbol,
451.0000 as OrderPrice,
1 as Mode
UNION ALL
select NULL as OrderID,
'' as OrderNumber,
'Discount' as TariffName,
'€' as CurrencySymbol,
100.0000 as OrderPrice,
-1 as Mode
END
2 Answers, 1 is accepted
0
Accepted
Hi Michel van Krimpen,
This is due to a problem that slipped into the Q3 release and has been immediately fixed in an internal build available for download from your account. Please download the internal build, upgrade and let us know if further help is needed.
Sorry for the temporary inconvenience.
Kind regards,
Steve
the Telerik team
This is due to a problem that slipped into the Q3 release and has been immediately fixed in an internal build available for download from your account. Please download the internal build, upgrade and let us know if further help is needed.
Sorry for the temporary inconvenience.
Kind regards,
Steve
the Telerik team
0
Ron
Top achievements
Rank 1
Rank 1
answered on 02 Dec 2010, 09:45 AM
Hello steve ,
It is working fine now .Thanks for quick solution.
It is working fine now .Thanks for quick solution.