I have a very simple query (below). I have tested in SQL Management Studio as well as the Configure DataSource in the Telerik Report Designer. Both return 19 rows of data. I added the ISNULL as those fields have the ability to be NULL and wanted to eliminate them from causing an error. If there is no parameter in query everything works . When a parameter is filled in I see the title of the TABLE but the rest is blank. I know this is something beyond simple. 

If I put in a default value into the parameter field on the table not even the header appears. The attachment shows how the Parameter is setup. Originally I was trying to pass the RegardingIdentifier () and through that was it so I modified the routine to use a string and still get the same results.

 

SELECT 

  Tasks.TaskIdentifier
, Tasks.RegardingIdentifier
, Tasks.StatusIdentifier
, Tasks.TaskNumber
, Tasks.DescriptionShort
, Tasks.StartDate
, Tasks.DueDate
, ISNULL(Tasks.Priority, 'Normal') AS Priority
, ISNULL(Tasks.EstimatedHours, 0) AS EstimatedHours
, ISNULL(Tasks.PercentComplete, 0) AS PercentComplete
, ISNULL(Status.FieldName, '') AS TaskStatus
FROM 
Tasks 
LEFT OUTER JOIN AppSettings Status ON Tasks.StatusIdentifier = Status.AppSettingIdentifier
LEFT OUTER JOIN Accounts ON Tasks.RegardingIdentifier = Accounts.AccountIdentifier
WHERE 
(Accounts.AccountCode = @AccountCode)
AND (Tasks.TaskComplete = 0)
ORDER BY 
Tasks.TaskNumber

I am currently working towards moving our report files into database storage. I have setup a custom resolver that is able to get the report from the id properly; however, when the subreport is loaded, it does not appear to be using the /api/reports serviceUrl. instead, it is looking in the root directory of the project in visual studio and not being routed through the Reports controller. Of course, the report is not there. What do I need to do to make the reports to evaluate on the serviceUrl to get it like the other reports? 

Here's my resolver:

public class DatabaseReportResolver : Telerik.Reporting.Services.Engine.IReportResolver
    {
        public ReportSource Resolve(string message)
        {
            using (var _context = new CommonDataContext())
            {
                var report = _context.ReportRecord.FirstOrDefault(x => x.UniqueName == message);
                if(report == null)
                {
                    return null;
                }
                var fileContent = report.ReportFiles.OrderByDescending(x => x.DateActive).FirstOrDefault();

                if (fileContent != null)
                {
                    var file = fileContent.File;
                    XmlReportSource source = new XmlReportSource();
                    source.Xml = System.Text.Encoding.Default.GetString(file);
                    return source;
                }
            }
            return null;
        }

       
    }

In my current project, ASP.NET Core 2 (on full .Net framework), users will have no use for the Navigate backward, Navigate forward, Toggle parameters, Toggle document buttons. These are disabled but I would like to remove them from the toolbar. Do you have an example on how to do this?

Thanks

Hi,

we try generating reports on the server simultaneously:

Parallel.ForEach(x, x =>

{

...

ReportProcessor.RenderReport(...);

....

}

and get the occasional exception below:

 

System.AggregateException: One or more errors occurred. ---> Telerik.Reporting.Processing.CancelProcessingException: An error occurred while evaluating the report parameters. Report source cannot be processed. ---> System.ArgumentNullException: Value cannot be null.

Parameter name: path2
   at System.IO.Path.Combine(String path1, String path2, String path3)
   at Telerik.Reporting.Interfaces.LocalizationContext.InitializeBucket(String resx)
   at Telerik.Reporting.Interfaces.LocalizationContext.GetString(String resx, String key)
   at Telerik.Reporting.Interfaces.StringsResolver.GetString(String key)

   at Telerik.Reporting.SRDescriptionAttribute.get_Description()
   at Telerik.Reporting.Expressions.EnumContextManager.GetItem(Type enumType)
   at Telerik.Reporting.Processing.ReportExpressionContext.RegisterAllReportingEnums()
   at Telerik.Reporting.Processing.ReportExpressionContext..ctor(Type reportType)
   at Telerik.Reporting.Processing.ReportParametersManager`1.CreateExpressionContext(Report report, IList`1 runtimeParameters)
   at Telerik.Reporting.Processing.ReportParametersManager`1..ctor(Report definitionReport, IEnumerable`1 definitionParameters, IDictionary`2 reportSourceParameters, IDataProviderContext dataProviderContext)
   at Telerik.Reporting.Processing.DocumentParametersManager`1.CreateManager(Report definition, IDataProviderContext dataProviderContext, IParameterValueParser parameterValueParser, IDictionary`2 rsParameters)
   at Telerik.Reporting.Processing.DocumentParametersManager`1.CreateManagers(IProcessingContext context, IParameterValueParser parameterValueParser)
   at Telerik.Reporting.Processing.DocumentParametersManager`1..ctor(ResolvedReportDocument resolvedReports, IProcessingContext processingContext, IParameterValueParser parameterValueParser)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReportSource(ReportSource reportSource, IRenderingContext context)
   --- End of inner exception stack trace ---
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReportSource(ReportSource reportSource, IRenderingContext context)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessReportSource(ReportSource reportSource, Hashtable deviceInfo, IRenderingContext context)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRender(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.ProcessAndRenderStateless(String format, ReportSource reportSource, Hashtable deviceInfo, IRenderingContext renderingContext, CreateStream createStreamCallback)
   at Telerik.Reporting.Processing.ReportProcessor.RenderReport(String format, ReportSource reportSource, Hashtable deviceInfo)

 

All the reporting assemblies are the latest.

Can the issue be related to?:

https://www.telerik.com/forums/is-the-reportprocessor-renderreport-function-thread-safe

 

Thank you,

Vlad

 

Hi Team,

 

I am new to Reporting. We have created a reporting Project using Telerik Reporting. It is working fine in Chrome and Mozilla. But it is not working in IE.

I am not getting any error

Please find the details below.

 

Aspx Code

 

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm2.aspx.cs" Inherits="IWarrantyClaimSearch.WebForm2" %>
<%@ Register Assembly="Telerik.ReportViewer.Html5.WebForms, Version=12.0.18.227, Culture=neutral, PublicKeyToken=a9d7983dfcc261be" Namespace="Telerik.ReportViewer.Html5.WebForms" TagPrefix="telerik" %>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
     <meta http-equiv="X-UA-Compatible" content="IE=Edge" />

    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />
    <script src="Scripts/jquery-1.10.2.min.js"></script>
    <%--<script src="Scripts/polyfill.min.js"></script>--%>
</head>
<body>
    <form id="form1" runat="server">
             <telerik:DeferredScripts ID="DeferredScripts1" runat="server" />
        <telerik:ReportViewer ID="ReportViewer1" runat="server"></telerik:ReportViewer>
    </form>
</body>
</html>

 

C# Code

 protected void Page_Load(object sender, EventArgs e)
        {
            Telerik.ReportViewer.Html5.WebForms.ReportSource reportSource = new Telerik.ReportViewer.Html5.WebForms.ReportSource();
            reportSource.IdentifierType = Telerik.ReportViewer.Html5.WebForms.IdentifierType.UriReportSource;
            reportSource.Identifier = @"Report/Report1.trdp";
            ReportViewer1.ReportSource = reportSource;
            ReportViewer1.Visible = true;
        }

 

 

Please help me on this. It is very critical For me

 

Hi, I am creating an invoice report that has a payment slip at the bottom of the report. The payment slip contains the Amount Due and the Address to mail in the payment. Customers detach the payment slip along the dotted line and send it along with their payment. The address on the payment slip should always show up through the envelope window. This can only happen when the payment slip always prints at a fixed distance from the bottom of the page. I've tried using a panel (that docks to the bottom of the page etc.) without any luck.

Can you please provide me some tips on how I can do this?

Thanks
Mahipal

Hello, for testing, I installed Telerik Reporting R1 2018 and configured the filtering in the parameter report. In the studio, everything works, but when you build and install on the server, the data is displayed all without filtering in Chrome and Firefox. In safari and IE work fine. Project ASP.NET 2.0 Framework 4.0.

I have a report that has a table that is populated from a stored procedure showing sales by contract - one line per contract.

I need to add 2 levels of groups so that I can show Sales by Salesperson within Shop with a page break on Shop and totals at both the Salesperson and Shop levels.

I have tried adding 2 Groups and moved the table to the last Group Header section but the grouping doesn't seem to be doing anything.  The report is not showing any Shop or Salesman details.  The design is shown in the attached image.

 

What am I missing?

Regards

Kevin

 

Hi,

I'm trying to create a graph with a few series on a numerical Y axis and date time X axis.
The Y axis is very simple with a fixed range and a known number of steps. However the X axis could have anything from a few values over a 5 minute range to a few hundred values over a 5 year range.

By default the graph appears to be configured to automatically set the scale, unit set to auto, but for a short range of values it just puts a label every minute and for longer periods it complains about having more than 5000 ticks.
All the documentation seems to suggest I need to set the unit and step values in the designer but this is not an option when I have an unknown range of values.

What do I need to do to get it to automatically calculate a suitable scale for the X axis.

I'm using Q2 2014 SP1.

Thanks,
Martin

I'm trying to incorporate the new InstanceReportSource into an existing program that I've inherited.  I understand the Visual Basic examples given, but I'm stymied how to apply it to a C# program that is using interfaces.  Using the older version of Telerik that came with the program, the code will compile and run (although the designer won't come up).  Upon upgrading to the latest release of Telerik reporting, I've gotten the designer to come up on some of the reports.  However, I've got a few that are flagging errors about the deprecated RecordSource.  Therein is my confusion.  My attempts to incorporate the InstanceReportSource seems to result in more errors and I'm at a loss.  I did submit a trouble ticket when I was first intially using the trial version.  The end result was to "use the Instance Report Source".

I'm currently using Telerik Q2 2012 SP1, Visual Studio C# 10.0.30319.1 and .NET 2010 4.0.30319

In addition to the code listed below, I've also included a screen shot of the error message(s).   Any help or direction you could provide would be greatly appreciated.  Many Thanks!! 

 

namespace Reports 

  

 {

  

 using System; 

  

 using System.ComponentModel; 

  

 using System.Drawing; 

  

 using System.Windows.Forms; 

  

 using Telerik.Reporting; 

  

 using Telerik.Reporting.Drawing; 

  

   

  

/// <summary> 

  

 /// Summary description for Conservation2VacuumReport. 

  

 /// </summary> 

  

 public partial class ConservationPressureReport : Telerik.Reporting.Report, IStandardReport 

  

 {

  

 public ConservationPressureReport() 

  

 {

  

/// <summary> 

  

/// Required for telerik Reporting designer support 

  

/// </summary> 

  

 InitializeComponent();

  

// 

  

 // TODO: Add any constructor code after InitializeComponent call 

  

 // 

  

 }

  

  

  

#region IStandardReport Members 

  

 ProjectReport IStandardReport.ProjectReport 

  

 {

  

get { return this.ProjectReport.ReportSource as ProjectReport; } 

  

 }

  

   

  

TankReport IStandardReport.TankReport 

  

 {

  

get { return this.TankReport.ReportSource as TankReport; } 

  

 }

  

ISO283Report IStandardReport.isoReport 

  

 {

  

get { return isoReport.ReportSource as ISO283Report; } 

  

 }

  

 public bool iso283Visible 

  

 {

  

 get 

{

return isoReport.Visible; 

  

}

  

   

  

set 

  

 {

  

isoReport.Visible = value; 

  

 }

  

}

  

   

  

VacuumReport IStandardReport.vacuumReport 

  

 { 

  

 get { return this.VacuumReport.ReportSource as VacuumReport; } 

  

 }

  

#endregion

  

}

  

}