Telerik Forums
Reporting Forum
0 answers
189 views

Hello,

I have an issue with HTML5 Report Viewer 13.0.19 when exporting Excel.

It seems that if the size of the resulting excel is big aprox 15MB you get an error when open it saying there is a problem with the content of the .xls file, if you try the report with partial data then the resulting excel of those partial reports are ok,

Is there any known issue with this?

Regards.

Toni
Top achievements
Rank 1
 asked on 21 Feb 2022
1 answer
2.2K+ views

Hi,

I have 2 tables in my report , each report has different data, it works very well, but there are 2 problems:

1) The measured table a lot of data, therefore it appears on more than one page, is that possible that the header of the table will always displayed on each page? ( I tried to set the 'ColumnHeaderPrintOnEveryPage' and it's not working)

2) The target value takes only one page , so I want the the table will continue showing up in every page the measured table exist.

this what happened now in page 2

The table measured Values has no header, and Target Values is empty (appears only in the first page)

 

thank you!

Todor
Telerik team
 answered on 21 Feb 2022
1 answer
7.8K+ views

I have an application using ABP.IO framework. This framework implements Swagger on the Host side (REST service application). I've added the package Telerik.WebReportDesigner.Services (16.0.22.119) in the project and have compiled. I'm getting this error below and Swagger is no longer working. I've tried to override the method SaveReport and add [HttpPost], also to add [ApiExplorerSettings(IgnoreApi = true)], but, it is not working.

[16:06:51 ERR] An unhandled exception has occurred while executing the request.
Swashbuckle.AspNetCore.SwaggerGen.SwaggerGeneratorException: Ambiguous HTTP method for action - Telerik.WebReportDesigner.Services.Controllers.ReportDesignerControllerBase.SaveReport (Telerik.WebReportDesigner.Services). Actions require an explicit HttpMethod binding for Swagger/OpenAPI 3.0
   at Swashbuckle.AspNetCore.SwaggerGen.SwaggerGenerator.GenerateOperations(IEnumerable`1 apiDescriptions, SchemaRepository schemaRepository)
   at Swashbuckle.AspNetCore.SwaggerGen.SwaggerGenerator.GeneratePaths(IEnumerable`1 apiDescriptions, SchemaRepository schemaRepository)
   at Swashbuckle.AspNetCore.SwaggerGen.SwaggerGenerator.GetSwagger(String documentName, String host, String basePath)
   at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at IdentityServer4.Hosting.IdentityServerMiddleware.Invoke(HttpContext context, IEndpointRouter router, IUserSession session, IEventService events, IBackChannelLogoutService backChannelLogoutService)
   at IdentityServer4.Hosting.MutualTlsEndpointMiddleware.Invoke(HttpContext context, IAuthenticationSchemeProvider schemes)
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at IdentityServer4.Hosting.BaseUrlMiddleware.Invoke(HttpContext context)
   at Volo.Abp.AspNetCore.Uow.AbpUnitOfWorkMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Volo.Abp.AspNetCore.ExceptionHandling.AbpExceptionHandlingMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
   at Volo.Abp.AspNetCore.ExceptionHandling.AbpExceptionHandlingMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Volo.Abp.AspNetCore.MultiTenancy.MultiTenancyMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Builder.ApplicationBuilderAbpJwtTokenMiddlewareExtension.<>c__DisplayClass0_0.<<UseJwtTokenMiddleware>b__0>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.RequestLocalization.AbpRequestLocalizationMiddleware.InvokeAsync(HttpContext context, RequestDelegate next)
   at Microsoft.AspNetCore.Builder.UseMiddlewareExtensions.<>c__DisplayClass6_1.<<UseMiddlewareInterface>b__1>d.MoveNext()
--- End of stack trace from previous location ---
   at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)

 

 

 

 

Dimitar
Telerik team
 answered on 17 Feb 2022
1 answer
128 views

We are currently using Telerik to generate unique barcodes and are running into an issue. Clients are printing the same barcodes multiple times without refreshing the list. Is there a way for us to either automatically refresh after a print has been completed or disable multiple prints of the same report?

 

General Info:

asp.net web application

Barcodes are generated through a stored procedure that verifies the barcodes are unique.

Dimitar
Telerik team
 answered on 16 Feb 2022
0 answers
254 views

Hi Team ,

After updating version of Telerik assemblies, Itemdatabound event[I have attached one screenshot for reference (its written in .vb file)]  is getting called while creating report as well while printing report. but I don't want it to get called while I am printing report. Is there any way that I can set autopostback(in telerik report) to false in telerik report ? Or any other solution will be appreciated to call Itemdatabound event only while creating report and not while printing.

Anyone can help me ? 

Kind regards, 

Payal

1 answer
151 views
Kindly when i printing a report it gives me  Report instance with ID 'null' not found. i tried many solutions i tried to fix the state of the report viewer component trigger it gives me error in commands since it gives undefined and when i use to another state it gives report instance with ID null please if you can help me in this issue
Yana
Telerik team
 answered on 15 Feb 2022
1 answer
361 views

I have a line chart with two series. I would like to show or hide each series based on whether they are checked in a report parameter.

For example, if Ongoing is unchecked in the list below, the red line should disappear from the chart and legend. Is this possible?

If so, what property on the graph should be toggled and how can a particular checkbox value be determined in an expression?

For testing purposes I have hard-coded the data in the data source like this:

SELECT '2021-1' YearMonth, 1 AS New, 2 AS Ongoing
UNION ALL
SELECT '2021-2' YearMonth, 2 AS New, 3 AS Ongoing
UNION ALL
SELECT '2021-3' YearMonth, 4 AS New, 1 AS Ongoing

Thanks,

Tim

Tim
Top achievements
Rank 3
Iron
Iron
Iron
 answered on 14 Feb 2022
0 answers
456 views

Hi,

I'm having a difficulty trying to make this design work. What I want is just to let the panels after the table to be positioned properly when the table size is growing.

 

Right now it's just messed up. It stays at the same position regardless of the table growing making it overlaps each other. (As you can see in the picture attached)

 

Any help would be highly appreciated.

Wasenshi
Top achievements
Rank 2
 updated question on 14 Feb 2022
0 answers
293 views
I have a report containing basic column clustered chart. it works fine on report designer and preview, my problem is when i export it to excel using asp.net mvc telerik reporting report processor, the charts becomes smaller.

Archieval
Top achievements
Rank 1
Veteran
 updated question on 11 Feb 2022
0 answers
652 views

Hello,

I am trying to use the HTML5 WebForms Report Viewer in an ASP.NET WebForms (.NET Framework 4.6.1) application.  I am using Telerik Reporting version 16.0.22.119.

I need to update the report source and parameters from the code behind, and I have not been able to get this to work. 

My report displays correctly when the page first loads.  Then, I select a choice from a drop-down list on the page.  I attempt to change the parameter and datasource in an event in the code behind.  When the screen refreshes, the report viewer is no longer there.

My report viewer is inside of an UpdatePanel on the page, like this:

			<asp:UpdatePanel ID="UP1" UpdateMode="Always" runat="server">
				<ContentTemplate>

					<%--practice group list and practice ddl--%>
					<div style="width: auto;">
						<uc:wucPracticeListAndPractice ID="PracticeAndListBar" runat="server"
						ControlStyle="Bar" AdjustWidths="True" SelectionsAreSticky="True"
						AllowAllPractices="false" />
					</div>

					<div style="border: 2px solid red;">

						<telerik:ReportViewer
							ID="reportViewer"
							Width="1300px"
							Height="900px"
							
							runat="server" ServiceUrl="https://localhost:44364/api/reports" >
							<ReportSource Identifier="Samples/TestReport.trdp" IdentifierType="UriReportSource">
								<Parameters>
									<telerik:Parameter Name="AccountOid" Value="00000000-0000-0000-0000-000000000000" />
								</Parameters>
							</ReportSource>
							
							<%-- If set to true shows the Send Mail Message toolbar button --%>
							<SendEmail Enabled = "false" />
						</telerik:ReportViewer>

						<telerik:DeferredScripts runat="server"></telerik:DeferredScripts>

					</div>

				</ContentTemplate>
			</asp:UpdatePanel>

In my event in the code behind:

            ReportSource reportSource = new ReportSource()
            {
                Identifier = "Samples/TestReport.trdp",
                IdentifierType = IdentifierType.UriReportSource
            };
            reportSource.Parameters.Add("AccountOid", Guid.Empty.ToString());

            this.reportViewer.ReportSource = reportSource;

Any suggestions on what I might be doing wrong?

Thank you.

Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?