Please let me know about Telerik reports customization.
I have to create a report where the user can select the fields from front end using .net to generate the reports.
the filters are provided in the front end along with the shorting fields and displaying fields in the reports. once the user click on generate report the required reports gets generated.
Below is my report customization
Report Setup and configuration,
report orientation like Landscape, Portrait and sort Filtering ,
Report columns Renaming , adding columns
and fourth one header and footer customization
All I have to give it to enduser who ever is generating the Reports.
Thanks,
= IIf(Fields.AdjType1 = "ETR", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "ETR", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "ETR", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "ETR", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "ETR", "$" + " " + Fields.AdjAmount5,IIf
(Fields.AdjType1 = "ETR T", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "ETR T", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "ETR T", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "ETR T", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "ETR T", "$" + " " + Fields.AdjAmount5,IIf(Fields.AdjType1 = "PARKT", "$" + " " + Fields.AdjAmount1,IIF(Fields.AdjType2 = "PARKT", "$" + " " + Fields.AdjAmount2,IIF(Fields.AdjType3 = "PARKT", "$" + " " + Fields.AdjAmount3,IIF(Fields.AdjType4 = "PARKT", "$" + " " + Fields.AdjAmount4,IIF(Fields.AdjType5 = "PARKT", "$" + " " + Fields.AdjAmount5,IIF(Fields.OptSvcCust1Code = "ETR", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "ETR", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "ETR", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "ETR", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF(Fields.OptSvcCust5Code = "ETR", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "ETR", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "ETR", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "ETR", "$" + " " + Fields.OptSvcCust8TotalAmt,IIF(Fields.OptSvcCust1Code = "ETR T", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "ETR T", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "ETR T", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "ETR T", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF(Fields.OptSvcCust5Code = "ETR T", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "ETR T", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "ETR T", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "ETR T", "$" + " " + Fields.OptSvcCust8TotalAmt,IIF(Fields.OptSvcCust1Code = "PARKT", "$" + " " + Fields.OptSvcCust1TotalAmt,IIF(Fields.OptSvcCust2Code = "PARKT", "$" + " " + Fields.OptSvcCust2TotalAmt,IIF(Fields.OptSvcCust3Code = "PARKT", "$" + " " + Fields.OptSvcCust3TotalAmt,IIF(Fields.OptSvcCust4Code = "PARKT", "$" + " " + Fields.OptSvcCust4TotalAmt,IIF
(Fields.OptSvcCust5Code = "PARKT", "$" + " " + Fields.OptSvcCust5TotalAmt,IIF(Fields.OptSvcCust6Code = "PARKT", "$" + " " + Fields.OptSvcCust6TotalAmt,IIF(Fields.OptSvcCust7Code = "PARKT", "$" + " " + Fields.OptSvcCust7TotalAmt,IIF(Fields.OptSvcCust8Code = "PARKT", "$" + " " + Fields.OptSvcCust8TotalAmt,"")))))))))))))))))))))))))))))))))))))))
| namespace DO |
| { |
| public class ReportBars |
| { |
| public ReportBars() |
| { |
| } |
| public ReportBars(string name, int value) |
| { |
| _name = name; |
| _value = value; |
| } |
| private string _name; |
| public string Name |
| { |
| get { return _name; } |
| set { _name = value; } |
| } |
| private int _value; |
| public int Value |
| { |
| get { return _value; } |
| set { _value = value; } |
| } |
| } |
| } |
| private void chart1_NeedDataSource(object sender, EventArgs e) |
| { |
| Telerik.Reporting.Processing.Chart chart = (Telerik.Reporting.Processing.Chart)sender; |
| Telerik.Reporting.Chart chartDef = (Telerik.Reporting.Chart)chart.ItemDefinition; |
| List<DO.ReportBars> bars = new List<DO.ReportBars>(); |
| bars.Add(new DO.ReportBars("Parka L", 120)); |
| bars.Add(new DO.ReportBars("Parka M", 100)); |
| bars.Add(new DO.ReportBars("Parka S", 132)); |
| bars.Add(new DO.ReportBars("Wool Cap", 45)); |
| bars.Add(new DO.ReportBars("Mittens", 67)); |
| chartDef.Series.Clear(); |
| ChartSeries s = new ChartSeries(); |
| s.Type = ChartSeriesType.Bar; |
| chartDef.Series.Add(s); |
| s.DataYColumn = "Value"; |
| s.DataLabelsColumn = "Name"; |
| chart.DataSource = bars; |
| } |