or
| Imports NSSReports |
| Imports Telerik.Reporting.Data |
| Partial Class AllReports_SectionReportGroupDetails |
| Inherits System.Web.UI.Page |
| Protected Sub Page_PreLoad(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreLoad |
| TryCast(ReportViewer1.Report, SectionReportGroup).ReportParameters("a1").Value = 5 |
| End Sub |
| End Class |
| Imports System.ComponentModel |
| Imports System.Drawing |
| Imports System.Windows.Forms |
| Imports Telerik.Reporting |
| Imports Telerik.Reporting.Drawing |
| Imports System.Data |
| Imports System.Data.SqlClient |
| Partial Public Class SectionReportGroup |
| Inherits Telerik.Reporting.Report |
| Public Sub New() |
| InitializeComponent() |
| DisplayData() |
| End Sub |
| Public sub DisplayData() |
| Dim t as string |
| t= RetrieveSelectCommand() |
| End Sub |
| Public Function RetrieveSelectCommand() As String |
| Dim s As String = Nothing |
| Select Case Me.Report.ReportParameters("a1").Value |
| Case 1 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 2 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 3 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 4 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 5 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 6 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 7 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M7_JUL),SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 8 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M8_AUG),SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 9 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M9_SEP),SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 10 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M10_OCT),SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 11 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M11_NOV),SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| Case 12 |
| s = "Select RESOURCE_NAME,SECTION_ID, DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK, SUM(M12_DEC),SUM(M1_JAN), SUM(M2_FEB),SUM(M3_MAR),SUM(M4_APR),SUM(M5_MAY),SUM(M6_JUN),SUM(M7_JUL),SUM(M8_AUG) FROM RESOURCE_DATA GROUP BY RESOURCE_NAME,SECTION_ID,DIVISION_ID,RESOURCE_YEAR,RESOURCE_MONTH,RESOURCE_WEEK" |
| End Select |
| Return s |
| End Function |
| End Class |
| string mimType = string.Empty; |
| string extension = string.Empty; |
| Encoding encoding = null; |
| byte[] buffer = Telerik.Reporting.Processing.ReportProcessor.Render( |
| "PDF", invoice, null, out mimType, out extension, out encoding); |
| FileStream fs = new FileStream("c:\\Invoice.pdf", FileMode.Create); |
| fs.Write(buffer, 0, buffer.Length); |
| fs.Flush(); |
| fs.Close(); |
| _memberId = int.Parse(((System.Data.DataRowView)(itemBase.DataObject))["MemberID"].ToString()); |

Hello,
I'm trying to create a table programmatically. I have been rather succesful in doing so but I can not find a way to set the size for the columns and rows (width for columns and height for rows).
When you create a report using the designer you can do so by using the mouse. Also if you click on the columns the property editor shows an item with the name TableColumnX or TableRowX where X is the number of the column. However I was unable to locate these items in the code-behind of the report.
Any ideas?
| Public Sub New() |
| InitializeComponent() |
| Me.DetailSection1.Height = Unit.Inch(0.01) |
| Me.DataSource = Nothing |
| End Sub |