Telerik Forums
Reporting Forum
1 answer
71 views

I have a client that is using the Telerik Report Designer (standalone) with a DLL that is used in conjunction with the Object Data Source used in their reports.

Everything is working properly, though they are requesting to see if there is a way that metadata can be provided on the POCO fields so that a description of the field will be displayed (for instance, in the tooltip) within the Data Explorer.

 This would greatly aid in the usability of the standalone Telerik Report Designer tool.

 Is there a current way to achieve this ?

Nasko
Telerik team
 answered on 07 May 2015
1 answer
545 views

Hello!

I have encountered an issue during creating a multi-table report. I need to place 2 tables next to each other (in one panel), but when one of the tables has less items than the other one, rows are getting automatically adjusted to take same amount of space as the other table. I figured out that if I add some blank rows height will not change, but this solution does not make me happy. Is there a solution to turn off row height auto adjustment? 

 

Nasko
Telerik team
 answered on 07 May 2015
1 answer
109 views

SP is returning multiple columns. I need to print each column value in each page.

 

Ex: If SP returns 5 columns

    Report should contain 5 pages. 1st record should print in the 1st page.2nd record should print in the 2nd page. How can I do this ??? Help me ASAP !!!

Nasko
Telerik team
 answered on 07 May 2015
1 answer
75 views

hi

i want to display multiple value in single pie chart but it gives  multiple pie chart so how to resolve it.

following pei chart and code

  private void BindColorPieChart()
        {
            //DataTable dt = null;
            DataController dc = new DataController();
            DataTable dt = dc.GetUsageDetailsOne(Convert.ToDateTime(txtTodate.Text.Trim()), Convert.ToDateTime(txtFromdate.Text.Trim()));
            if (dt.Rows.Count == 0)
            {
                ColorPieChart.HttpHandlerUrl = ResolveUrl("ChartImage.axd");
                ColorPieChart.Visible = false;
                lblMessage.Text = "No data found";
            }
            else
            {

                ColorPieChart.HttpHandlerUrl = ResolveUrl("ChartImage.axd");
                ColorPieChart.ChartTitle.TextBlock.Text = "Usage Details";
                ColorPieChart.Legend.Appearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.TopRight;

                ColorPieChart.PlotArea.XAxis.AxisLabel.Visible = true;
                ColorPieChart.PlotArea.YAxis.AxisLabel.Visible = true;
                ColorPieChart.AutoLayout = true;
                ColorPieChart.Legend.TextBlock.Visible = true;
              
                
                ChartSeries series = new ChartSeries();
                series.Type = ChartSeriesType.Pie;
                series.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.ItemLabels;
                series.DataYColumn = "TotalCost";
                //series.Name = "Total Cost";
     
               series.DataLabelsColumn = "TotalCost";
                series.Appearance.ShowLabelConnectors = true;


             
                ColorPieChart.Series.Add(series);
                ColorPieChart.DataSource = dt;
               

                ColorPieChart.DataBind();
            }
        }
        protected void lnkToDate_Click(object sender, EventArgs e)
        {
            CalToDate.Visible = !CalToDate.Visible;
        }
        protected void lnkFromDate_Click(object sender, EventArgs e)
        {
            CalFromDate.Visible = !CalFromDate.Visible;
        }
        protected void CalToDate_SelectionChanged(object sender, EventArgs e)
        {
            //set date in MM/dd/yyyy format in textbox
            txtTodate.Text = CalToDate.SelectedDate.ToString("MM/dd/yyyy");
            if (txtTodate.Text != string.Empty)
                CalToDate.Visible = false;
        }
        protected void CalFromDate_SelectionChanged(object sender, EventArgs e)
        {
            //set date in MM/dd/yyyy format in textbox
            txtFromdate.Text = CalFromDate.SelectedDate.ToString("MM/dd/yyyy");
            if (txtFromdate.Text != string.Empty)
                CalFromDate.Visible = false;
        }
        protected void btnGo_Click(object sender, EventArgs e)
        {
            ColorPieChart.Visible = true;
            BindColorPieChart();
        }
        protected void RadChart1_ItemDataBound(object sender, Telerik.Charting.ChartItemDataBoundEventArgs e)
        {
            e.SeriesItem.Name = e.SeriesItem.Name = (e.DataItem as DataRowView).Row["TotalCost"].ToString();
        }
    }

UI part aspx

<telerik:RadChart ID="ColorPieChart" runat="server" Height="600px" Width="700px" DefaultType="Pie">
        <ChartTitle>
            <TextBlock Text="">
            </TextBlock>
        </ChartTitle>
    </telerik:RadChart>

 

 

Stef
Telerik team
 answered on 06 May 2015
3 answers
475 views

Made sure all the web.config items were there

Created a report from designer including Data Source

called the following

UriReportSource rptSource = new UriReportSource();
string tst = Server.MapPath("~/METI/HP/Reporting/TestReport.trdx");
rptSource.Uri = tst;

rptViewer.ReportSource = rptSource;
rptViewer.RefreshReport();

 Source is correct

All I get is reportviewer saying generating report and Nothing else no errors, nothing...

not 100%

What am I missing?
               

Nasko
Telerik team
 answered on 06 May 2015
3 answers
914 views

I'm using Telerik Reporting Q3 2014............I do not know why inside my aspx file says: "could not load file or assembly telerik.reporting 4.1.10.714"?.....even so the application works properly..........How can I remove that error ??

Thanks!

 

My WebConfig is:

<?xml version="1.0"?>
<!--
Nota: en lugar de editar manualmente este archivo, puede usar la
herramienta Administración de sitios web para configurar las opciones de su aplicación. Use
la opción Sitio web->Configuración de Asp.Net en Visual Studio.
Encontrará la lista completa de opciones y comentarios en
machine.config.comments ubicado normalmente en
\Windows\Microsoft.Net\Framework\vx.x\Config
-->
<configuration>
<appSettings/>
<connectionStrings>
<remove name="connCIC"/>
<add name="connCIC" connectionString="Data Source=CJFDESARROLLO;Initial Catalog=CIC_net;Persist Security Info=True;User ID=usrCIC;Password=316146" providerName="System.Data.SqlClient"/>
<!-- <add name="connCIC" connectionString="Data Source=CJFDATASTORE;Initial Catalog=CIC_net;Persist Security Info=True;User ID=usrCIC_Net;Password=usrR3m0t3Cnx; Min Pool Size=5; Max Pool Size=400;" providerName="System.Data.SqlClient"/>-->
</connectionStrings>
<!--
Para obtener una descripción de los cambios de web.config, vea http://go.microsoft.com/fwlink/?LinkId=235367.

Los siguientes atributos se pueden establecer en la etiqueta <httpRuntime>.
<system.Web>
<httpRuntime targetFramework="4.5.1" />
</system.Web>
-->
<system.web>
<httpHandlers>
<add verb="*" path="Telerik.ReportViewer.axd" type="Telerik.ReportViewer.WebForms.HttpHandler, Telerik.ReportViewer.WebForms, Version=8.2.14.1027, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
</httpHandlers>
<httpRuntime executionTimeout="3600" maxRequestLength="2097151" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100"/>
<!--
Establezca debug="true" en la compilación para insertar símbolos
de depuración en la página compilada. Dado que este
proceso afecta al rendimiento, debe establecer este valor como true
durante la depuración.
-->
<compilation debug="true" defaultLanguage="c#" targetFramework="4.5.1">
<assemblies>
<add assembly="Telerik.Reporting, Version=8.2.14.1027, Culture=neutral, PublicKeyToken=a9d7983dfcc261be"/>
</assemblies>
</compilation>
<!--
La sección <authentication> habilita la configuración
del modo de autenticación de seguridad que usa
ASP.NET para identificar a un usuario entrante.
-->
<authentication mode="Forms">
<forms protection="All" defaultUrl="inicio.aspx" loginUrl="login.aspx" requireSSL="true" timeout="120" path="/"/>
</authentication>
<authorization>
<deny users="?"/>
</authorization>
<!--
La sección <customErrors> habilita la configuración de
las acciones que se deben realizar si un error no controlado tiene lugar
durante la ejecución de una solicitud. En concreto,
permite a los desarrolladores configurar páginas de error html
que se mostrarán en lugar de un seguimiento de pila de errores.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
<error statusCode="403" redirect="NoAccess.htm" />
<error statusCode="404" redirect="FileNotFound.htm" />
</customErrors>
-->
<customErrors defaultRedirect="error.aspx" mode="Off">
<error statusCode="401" redirect="unauthorized.aspx"/>
</customErrors>
<sessionState cookieless="AutoDetect" timeout="120"/>
<pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
</system.web>
<system.webServer>
<security>
<requestFiltering>
<!--This will handle requests up to 1024MB (1GB) -->
<requestLimits maxAllowedContentLength="1048576000"/>
</requestFiltering>
</security>
<defaultDocument>
<files>
<add value="inicio.aspx"/>
</files>
</defaultDocument>
</system.webServer>
<location path="olvidoPassword.aspx">
<system.web>
<authorization>
<allow users="*"/>
</authorization>
</system.web>
</location>
</configuration>

 

The ASPX file is:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="REPobligaciones.aspx.cs" Inherits="REPobligaciones" %>
<%@ Register TagPrefix="headerInicio" TagName="header" Src="include/headerInicioV.ascx" %>
<%@ Register assembly="Telerik.ReportViewer.WebForms, Version=8.2.14.1027, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" namespace="Telerik.ReportViewer.WebForms" tagprefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head id="Head1" runat="server">
<title>TecnoVisita</title>
</head>
<headerInicio:header ID="Header" runat="server"/>
<body>
<form id="form1" runat="server">
<div>
<telerik:ReportViewer ID="ReportViewer1" runat="server" BackColor="White"
Height="600px" Width="70%">
</telerik:ReportViewer>
</div>
</form>
</body>
</html>

 

 And.......its Code is:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class REPobligaciones : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Telerik.Reporting.UriReportSource uriReportSource = new Telerik.Reporting.UriReportSource();
// Specifying an URL or a file path
uriReportSource.Uri = Server.MapPath("reportes/WEBrepObligaciones.trdx");
// Adding the initial parameter values
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("fiIdConcurso", Page.Session["fiIdConcurso"]));
uriReportSource.Parameters.Add(new Telerik.Reporting.Parameter("fcDesComerciante", Page.Session["fcDesComerciante"]));
ReportViewer1.ReportSource = uriReportSource;
}
}

 

Stef
Telerik team
 answered on 06 May 2015
1 answer
261 views

Hi

I make Report with multi column. When i add report header in report its width is also column width how i can make report header section width equal to report width. please see the attached screenshot of report design. in blue circle is a table which is in report header section Refer to datasource1

Red circle include the table in detail section refer to datasource2

in this section when table reach at the end of the page i want to show vertically on the same page.

 How can I do this?

Nasko
Telerik team
 answered on 05 May 2015
1 answer
91 views
I have a report bound to an ObjectDataSource. Among the properties these objects have, one is itself a collection of objects. I want to display the individual values with these collections as well. I assume some combination of creating a group and a crosstab would work, but I am not seeing anything. If the property is Fields.Collection and I create a group based on that, how do I refer to the Collection's properties in the detail panel? Fields.Collection.Property or just Fields.Property?
Nasko
Telerik team
 answered on 05 May 2015
4 answers
308 views

Hi,

For an app i'm developing, the user can print several invoices selected in a list.

 The invoice report works just fine for one item. I decided to reuse this code and include them in a ReportBook object. What I can't figure is how to send the ReportBook object to the view with a ReportViewerViewModel object.

 public ActionResult Invoices(IEnumerable<int> ids)
{

     var book = new ReportBook();
     ids.ForEach(id =>
      {
           var invoiceReport = new ReportDefinitions.Invoice();
           book.Reports.Add(invoiceReport);

      });           
     var source = new InstanceReportSource {ReportDocument = book};
     var viewer = new ReportViewerViewModel();

 

     return ?
}

 If my way of doing is right, how can I pass the book to the Index view which use a ReportViewerViewModel model or resolve the report ?

Nasko
Telerik team
 answered on 05 May 2015
1 answer
198 views

I am trying to create a parent/child report for a single item, a Job, which contains Parts. 

I want to present the Job object, containing the Parts, to the Report. However, when I try to access the Parts, defined as List<Part>, I cannot access it's attributes, only the attributes of the List itself (Capacity and Count).

What am I doing wrong?

Thanks Larzeb 

  public class Job
   {
      public Job()
      {
         PartList = new List<JobPart>();
      }
 
      public int Id { get; set; }
      public string JobNumber { get; set; }
      public string Name { get; set; }
      public List<JobPart> PartList { get; set; }
      public DateTime ServiceDate { get; set; }
      public decimal SalesTaxRate { get; set; }
      public string Comments { get; set; }
}

Nasko
Telerik team
 answered on 05 May 2015
Top users last month
Rob
Top achievements
Rank 3
Iron
Iron
Iron
Atul
Top achievements
Rank 1
Iron
Iron
Iron
Alexander
Top achievements
Rank 1
Veteran
Iron
Serkan
Top achievements
Rank 1
Iron
Shawn
Top achievements
Rank 1
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?