| private void chart1_NeedDataSource(object sender, EventArgs e) |
| { |
| chart1.Width = Unit.Pixel(300); |
| chart1.Height = Unit.Pixel(300); |
| ChartSeries s = new ChartSeries(); |
| s.Name = "NameOfSerie"; |
| s.Type = ChartSeriesType.Pie; |
| for (int i = 1; i < 6; i++) |
| { |
| ChartSeriesItem item = new ChartSeriesItem(); |
| item.YValue =i* 3.5; |
| item.Label.TextBlock.Text = "A" + i.ToString(); |
| s.Items.Add(item); |
| } |
| s.Appearance.LegendDisplayMode =ChartSeriesLegendDisplayMode.Nothing; |
| chart1.Series.Add(s); |
| } |
| private void chart1_NeedDataSource(object sender, EventArgs e) |
| { |
| string sql = @"SELECT TOP 10 Production.Product.ListPrice, Production.Product.Name, Production.Product.ProductID FROM Production.Product"; |
| string connectionString ="Data Source=localhost;Initial Catalog=AdventureWorks;Integrated Security=True"; |
| SqlDataAdapter adapter = new SqlDataAdapter(sql, connectionString); |
| DataSet dataSet = new DataSet(); |
| adapter.Fill(dataSet); |
| ChartSeries series = new ChartSeries(); |
| series.DataYColumn = "ProductID"; |
| series.DataLabelsColumn = "Name"; |
| chart1.SeriesOrientation=ChartSeriesOrientation.Horizontal; |
| chart1.Width =Unit.Pixel(300); |
| chart1.Height = Unit.Pixel(300); |
| chart1.Series.Add(series); |
| (sender as Telerik.Reporting.Processing.Chart).DataSource = dataSet.Tables[0].DefaultView; |
| } |
| Public Sub New() |
| InitializeComponent() |
| Try |
| Dim connMAS As SqlConnection = New SqlConnection() |
| Dim cmd As SqlCommand |
| Dim commLoadPortalUserInfo As SqlCommand = connMAS.CreateCommand() |
| connMAS.ConnectionString = Convert.ToString("some connection string") |
| connMAS.Open() |
| cmd = connMAS.CreateCommand() |
| cmd.CommandText = "storedprocedurename" |
| cmd.CommandType = CommandType.StoredProcedure |
| cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar) |
| cmd.Parameters("@CompanyID").Value = Me.ReportParameters("CompanyID").Value |
| Dim da As SqlDataAdapter = New SqlDataAdapter(cmd) |
| Dim ds As DataSet = New DataSet |
| da.Fill(ds) |
| Me.DataSource = ds |
| connMAS.Close() |
| Catch ex As System.Exception |
| System.Diagnostics.Debug.WriteLine(ex.Message) |
| End Try |
| End Sub |
| Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load |
| If (Not Page.IsPostBack) Then |
| ReportViewer1.Report = New RosterReport() |
| ReportViewer1.Report.ReportParameters(0).Value = "Value" |
| ReportViewer1.RefreshReport() |
| End If |
| End Sub |
| End Class |
Hi,
I've been playing around with Telerik Report for just a couple days (basically reading the documentation and watching some videos) and have some questions. They are probable really basic questions, but since I didn't find so far an answer for them in the documentation nor by searching in the forum, I post them here.
I am trying to set a telerik report without having any DataBase conexion, so I thought on using a List (e.g. List<MyClass>) as DataSource.
How should I do this?
Until now, I added the DataSource programmatically, but then how do I connect the properties of the list elements (of type MyClass) with table/list/... cells?
Should I better define somehow the list as a project dataSource? how can I do this?
Does my approach make sense?
As I said at the beginning, I know these are probably beginner's questions, but I'm blocked!
Thanks!
Marta
| <body> |
| <form id="form1" runat="server"> |
| <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> |
| </telerik:RadScriptManager> |
| <div id="TitleSection"> |
| <fortress:PopupWindowToolbar ID="PopupWindowToolbar1" runat="server"></fortress:PopupWindowToolbar> |
| </div> |
| <div id="PageSection"> |
| <div id="ContentSection"> |
| <div id="ContentSectionContainer"> |
| <asp:ContentPlaceHolder ID="ContentPlaceHolderPopup" runat="server" > |
| </asp:ContentPlaceHolder> |
| </div> |
| </div> |
| </div> |
| </form> |
| </body> |
| html, body, form |
| { |
| height:100%; |
| } |
| html |
| { |
| overflow:hidden; |
| } |
| #TitleSection |
| { |
| position: static; |
| top:0px; |
| width:100%; |
| text-align: left; |
| vertical-align: middle; |
| background: #b6cef1 url(Header/GradiantEntete.png) repeat-x scroll bottombottom left; |
| } |
| #ContentSection |
| { |
| position:relative; |
| top:0px; |
| left:0px; |
| width:100%; |
| height:100%; |
| } |
| .FortressReportViewer |
| { |
| position:absolute; |
| top:0px; |
| left:0px; |
| rightright:0px; |
| bottombottom:0px; |
| height:100% !important; |
| width:100% !important; |
| } |
*** Measure Report (Vertical) STARTED ***
*** Measure Report (Vertical) DONE in 00:00:00.0008545 ***
*** Measure Report (Vertical) STARTED ***
*** Measure Report (Vertical) DONE in 00:00:00.0010941 ***
*** Measure Report (Vertical) DONE in 00:00:00.0055121 ***
*** ProcessReport #0 DONE in 00:00:00.3215597 ***
*** RenderReport #0 STARTED ***
*** RENDER PAGES STARTED ***
*** RENDER PAGES DONE in 00:00:00.0028726 ***
An error has occured while rendering the report: System.InvalidOperationException: The calling thread must be STA, because many UI components require this.
at System.Windows.Input.InputManager..ctor()
at System.Windows.Input.InputManager.GetCurrentInputManagerImpl()
at System.Windows.Input.InputManager.get_Current()
at System.Windows.Input.KeyboardNavigation..ctor()
at System.Windows.FrameworkElement.FrameworkServices..ctor()
at System.Windows.FrameworkElement.EnsureFrameworkServices()
at System.Windows.FrameworkElement..ctor()
at System.Windows.Controls.Panel..ctor()
at System.Windows.Controls.Canvas..ctor()
at Telerik.Reporting.XamlRendering.CompositionXamlBase.NewPhysicalPage()
at Telerik.Reporting.XamlRendering.CompositionXps.NewPhysicalPage()
at Telerik.Reporting.ImageRendering.CompositionBase.NextUsableArea()
at Telerik.Reporting.ImageRendering.CompositionBase.NextHorizontalPage()
at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(CompositionBase composition, RenderingElement renderingReport, Int32 startPage, Int32 endPage, Boolean render)
at Telerik.Reporting.ImageRendering.ImageRendererBase.ProcessPages(Report report, CompositionBase composition, Int32 startPage, Int32 endPage, Boolean render)
at Telerik.Reporting.ImageRendering.ImageRendererBase.RenderReport(Report report, Hashtable renderingContext, Hashtable deviceInfo, CreateStream createStreamCallback, EvaluateHeaderFooterExpressions evalHeaderFooterCallback)
*** RenderReport #0 DONE in 00:00:00.0068132 ***
*** ReportProcessor.Render DONE in 00:00:00.3291403 ***
---------------------------------------------------------------------------------------------------------------------------------