Telerik Forums
Reporting Forum
1 answer
265 views
I have a report that I put together that has a cross tab table grouped on TitleUnitEmail address, and TitleNumber.  I'm trying to get a conditional format applied that will alternate the cell color by theTitleNumber group but I can't get it it work right.  For a regular table I know I can add = RowNumber()%2 and set the value to =1 and it works great but I can't figure out how to achieve the same result when I want the band to occur based on the TitleNumber group and not the Row Number.  Help?
Todor
Telerik team
 answered on 06 Jan 2021
2 answers
138 views

I apologize if an example of what I would like to do is in another thread. I tried searching for something similar but

I have a customer that would like to zoom in on the data points of a graph. I told them that I don't think that capability exists, but I could adjust the range of the graph so that they could better see where each data point exists in the swim lanes.

What I would like to do is either offset the data point labels that are off the chart, or create an x axis at the top of the graph containing the data point value for each week in the series. Is this feasible?

 

 

 

James
Top achievements
Rank 1
Veteran
 answered on 04 Jan 2021
3 answers
189 views

Hello guys, i'm having a big problem and this time i don't think it's possible to solve with telerik reporting.

I've a big accounting reporting with a lot of data, so eventually a lot of pages.

In this report i've groups, and i'm using the ColumnHeadearsPrintOnEveryPage = true. So far is OK. But the problem is, when the group break automatically i need to show one value of the last row of the page before in the Header.

Is it possible?

Todor
Telerik team
 answered on 04 Jan 2021
4 answers
323 views

 

Request URL:
http://localhost:5011/api/reports/clients/a424ed34405/parameters

Response error:

{
    "message": "An error has occurred.",
    "exceptionMessage": "Invalid report type",
    "exceptionType": "System.ArgumentException",
    "stackTrace": "   at Telerik.Reporting.Processing.TypeReportDocumentResolver.Resolve(IProcessingContext context, TypeReportSource rs)\n   
at Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IProcessingContext context, ReportSource rs)\n   
at Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass0_0.<Resolve>b__0(IReportDocumentResolver r)\n   
at Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](IProcessingContext context, ReportSource source, Func`2 func)\n   
at Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source)\n   
at Telerik.Reporting.Processing.ResolvedReportDocument.ResolveReportsRecursively(ReportSource rs, IProcessingContext context, IDictionary`2 parentRsParameters, Boolean parentShouldDispose, List`1 result, IReportDocument& definition, ResolvedReport& tocReport, ReportBookTocPosition& tocReportPosition)\n   
at Telerik.Reporting.Processing.ResolvedReportDocument.Create(ReportSource rs, IProcessingContext context)\n   
at Telerik.Reporting.Processing.DocumentParametersManager`1..ctor(ReportSource definition, IProcessingContext processingContext, IParameterValueParser parameterValueParser)\n   
at Telerik.Reporting.Processing.DocumentParametersManager..ctor(ReportSource rs, IProcessingContext processingContext, IParameterValueParser parameterValueParser)\n   
at Telerik.Reporting.Services.Engine.ReportEngine.GetParameters(String clientID, String report, Dictionary`2 parameterValues)\n   
at Telerik.Reporting.Services.AspNetCore.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource)\n   
at lambda_method(Closure , Object , Object[] )\n   
at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()\n--- End of stack trace from previous location where exception was thrown ---\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()\n--- End of stack trace from previous location where exception was thrown ---\n   
at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeNextExceptionFilterAsync>g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)"
}


sky
Top achievements
Rank 1
 answered on 28 Dec 2020
3 answers
196 views

I'm dynamically setting the value on a PictureBox to a api controller that resizes the image from storage and returns the bytes.

ex: https://localhost:44300/company-logos/4?width=96

 

Getting this error:

An error has occurred while processing PictureBox 'Logo':
Invalid image data.
------------- InnerException -------------
Too many automatic redirections were attempted.

 

This was working fine up until a couple weeks ago. Not sure what changed to be honest.

 

If I access the route directly, the controller works as expected (returns the resized image). When setting it in the report, the controller never gets called.

 

If I set the value to an external source, it's working. Of course the image isn't resized though.

ex: https://somedomain.blob.core.windows.net/logos/00000004/635939217942995665_FullSizeRender.jpeg

Nasko
Telerik team
 answered on 25 Dec 2020
5 answers
1.6K+ views

Hi,

I'm using below code to generate report on run time:

using (ReportBook reportBook = new ReportBook())
            {
                foreach (Object input in inputValues)
                {
                    InstanceReportSource reportSource = new InstanceReportSource
                    {
                        ReportDocument = new MyReport
                        {
                            DataSource = new JsonDataSource
                            {
                                Name = "jsonDataSource1",
                                Source = genJsonDataSource(input)  // get json string from input object
                            }
                        }
                    };
                    reportBook.ReportSources.Add(reportSource);
                }
 
                ReportProcessor reportProcessor = new ReportProcessor();
                InstanceReportSource instanceReportSource = new InstanceReportSource
                {
                    ReportDocument = reportBook
                };
                RenderingResult result = reportProcessor.RenderReport("PDF", instanceReportSource, new System.Collections.Hashtable());
                // save report file from result
......
            }

 

MyReport is a c# report class created by visual studio designer. It is designed with a json datasource named "jsonDataSource1" with some sample data in it. The report is generated as PDF but error is shown as in attached screenshot. I followed the instructions in https://docs.telerik.com/reporting/knowledge-base/missing-assembly-reference-when-using-jsondatasource by referencing Telerik.Reporting.WebServiceDataSource.dll in my project and make sure it's exist in the running directory. But the error persists. And when the dll is not referenced, I can preview the report without problem. So the symptom seems not exactly same as the document describes. The dll version is 14.2.20.1021. .Net 4.8.

What else need be done to fix this error?

Randy
Top achievements
Rank 1
Veteran
 answered on 24 Dec 2020
3 answers
614 views
I am moving a report from SSRS to Telerik due to better support for HTML fields in Telerik.

I have a table, and I want it to appear like:

Table Header
Group Header
Data

However, in using Telerik Reporting, I don't seem able to achieve this. It seems that the best I can do is:

Group Header
Table Header
Data

Based on the below screenshot (currenttelerikreport.png) - I would think I could "just" add a new group header row and add my table header columns, but I'm unable to split the cells. I don't know if the multiple merged cells are causing a problem or what. 

Any ideas?
Nasko
Telerik team
 answered on 24 Dec 2020
1 answer
476 views

The text-transform: capitalize syntax is perfectly working when viewing in design tab of Htmlbox , but whenever I printpreview the report , the syntax is not working.

I provided some screenshots regarding to this issue, hope someone could help me out ,really need this feature so that I can use the capitalize text form.
Thanks in Advance.

Dimitar
Telerik team
 answered on 23 Dec 2020
7 answers
3.3K+ views
I'm trying to find the best way to get a count of rows returned from the data source? I'm trying to put this in a text box. Is there something like =DataSource.Count ?
Mads
Telerik team
 answered on 23 Dec 2020
1 answer
262 views

I am programmatically generating a PDF from a TRDP file which uses an ObjectDataSource.  When I preview my report using default values in the standalone report designer, the data is displayed correctly.  When I set the parameters programatically and render the report in code, no data is displayed.  Here is the code to generate the PDF.  Appreciate any help.

Telerik.Reporting.UriReportSource reportSource =
    new Telerik.Reporting.UriReportSource
    {
        Uri = "Reports\\MyReport.trdp"
    };
 
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("batchId", batchId));
reportSource.Parameters.Add(new Telerik.Reporting.Parameter("accession", accession));
 
Telerik.Reporting.Processing.ReportProcessor reportProcessor = new Telerik.Reporting.Processing.ReportProcessor();
System.Collections.Hashtable deviceInfo = new System.Collections.Hashtable();
 
var result = reportProcessor.RenderReport("PDF", reportSource, deviceInfo);

 

Tony
Top achievements
Rank 1
 answered on 22 Dec 2020
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?