or
<?xml version="1.0" encoding="utf-8"?><Report DataSourceName="sqlDataSource1" Width="8.1in" Name="guestlist" SnapGridSize="0.1in" xmlns="http://schemas.telerik.com/reporting/2012/3.3"> <Style> <BorderWidth Default="0in" /> </Style> <DataSources> <SqlDataSource ConnectionString="STRINGNAME" SelectCommand="select * from guestlist order by lastname" Name="sqlDataSource1" /> </DataSources> <Items> <DetailSection Height="1.8in" Name="detail"> <Style> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> </Style> <Items> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.07in" Value="Name:" Name="textBox1"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.3in" Value="Guest Name:" Name="textBox4"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.5625in" Value="Children:" Name="textBox5"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="0.8in" Value="Address:" Name="textBox6"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.25in" Value="Phone:" Name="textBox8"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="0.9in" Height="0.2in" Left="0.15in" Top="1.5in" Value="Email:" Name="textBox9"> <Style TextAlign="Right" VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="None" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.0700000151991844in" Value="=Fields.FirstName + " " + Fields.LastName" Name="textBox10"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.0299999993294477in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.3in" Value="=Fields.Guests" Name="textBox11"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.5625in" Value="=Fields.Children" Name="textBox12"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="0.8in" Value="=Fields.Street" Name="textBox13"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1in" Value="=Fields.City + ", " + Fields.State + " " + Fields.Zip
" Name="textBox14"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.25in" Value="=Fields.Phone" Name="textBox15"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> <TextBox Width="2.80000025431315in" Height="0.2in" Left="1.10000014305115in" Top="1.5in" Value="= Fields.Email" Name="textBox16"> <Style VerticalAlign="Middle"> <BorderStyle Top="None" Bottom="Solid" Left="None" Right="None" /> <BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Size="9pt" /> <Padding Left="0.03in" /> </Style> </TextBox> </Items> </DetailSection> <PageHeaderSection Height="1in" Name="pageHeaderSection1"> <Style BackgroundColor="238, 236, 225"> <BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" /> <BorderColor Top="74, 69, 42" Bottom="74, 69, 42" Left="74, 69, 42" Right="74, 69, 42" /> <BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" /> <Font Name="Edwardian Script ITC" /> </Style> <Items> <PictureBox Value="Value" Width="7.7000002861023in" Height="0.799960613250732in" Left="0.199999968210856in" Top="0.0999999865889549in" Sizing="ScaleProportional" MimeType="image/png" Name="pictureBox1" /> </Items> </PageHeaderSection> </Items> <PageSettings> <PageSettings PaperKind="Letter" Landscape="False" ColumnCount="2" ColumnSpacing="0in"> <Margins> <MarginsU Left="0.2in" Right="0.2in" Top="0.2in" Bottom="0.2in" /> </Margins> <BorderWidth Default="0in" /> </PageSettings> </PageSettings></Report>public class DashboardController : Controller{ public ActionResult Index() { var model = data.GetReportData() return View(model); }}@(Html.TelerikReporting().ReportViewer() .Id("reportViewer1") .ServiceUrl("/api/reports/") .TemplateUrl("/ReportViewer/templates/telerikReportViewerTemplate.htmll") .ReportSource(new TypeReportSource{TypeName="MyReportLibrary, Dashboard"}) .ViewMode(ViewModes.INTERACTIVE) .ScaleMode(ScaleModes.SPECIFIC) .Scale(1.0) .PersistSession(true))private void Report1_ItemDataBound(object sender, EventArgs e)
{
SqlDataAdapter adapter = new SqlDataAdapter();
rep = new reportRepository();
List<ReportViewModel> model = rep.GetData();
// Creating and configuring the ObjectDataSource component:
var objectDataSource = new Telerik.Reporting.ObjectDataSource();
objectDataSource.DataSource = dsConvertion.ToDataSet(model); // GetData returns a DataSet with three tables
objectDataSource.DataMember = "tblFirst"; /// Indicating the exact table to bind to. If the DataMember is not specified the first data table will be used.
// Creating a new report
Telerik.Reporting.Report report = new Telerik.Reporting.Report();
// Assigning the ObjectDataSource component to the DataSource property of the report.
report.DataSource = objectDataSource;
// Use the InstanceReportSource to pass the report to the viewer for displaying
Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();
reportSource.ReportDocument = report;
}
I am new to Telerik reporting and am trying to include a simple graph from data that has two columns (X, Y), for instance
1 345
2 10
...
12 3273
The Graph wizard seems to assume a more complicated data structure and requires a category.
For the simple X Y graph I need there are no grouping or categories.
How do I graph this simple data.
The graph produced by the wizard also has "ALL" under the X axis for which I can not find the property displaying this text.