Questions on Reporting Forum

1 answer

625 views

Report output to word and pdf layout problem

Dear all,

I have a report viewer which output report properly when viewed in computer. However, when I export to word document. Some text box is not fully extened, I need to pull the textbox border in order to show the content. And textbox is not aligned with other textbox like what is in computer view. The alignment problem also exist when I export to PDF. How can I fix it? Thanks.

General Discussions

answered on 30 Sep 2020

1 answer

749 views

Report : Error Creating Report instance

Report was running fine since last 2 months but now having below issue : Error Creating Report instance. When same reports deployed on another server (IIS) its working fine.

I want to run that report on previous server but didn't succeed. getting response internal 500 error.

This issue is on clicking preview button on report.

General Discussions

answered on 30 Sep 2020

4 answers

1.2K+ views

[Solved] Report Service runs normally on Windows, but fails in Docker.

Report Service runs normally on Windows, but fails in Docker.

I deployed the Report Service in Docker, and the following API call reported an error:

http://localhost:60248/api/reports/clients/813685ac1f3/parameters

http method: post

request body:

{

"report": "MedDispense.Reporting.ReportService.InventoryCost, MedDispense.Reporting.ReportService",

"parameterValues": {

"SiteID": "999",

"StationID": "1",

"SortBy": ""

}

response：

{

"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.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)"

}

Anybody can help me?

General Discussions

answered on 30 Sep 2020

1 answer

451 views

Web Service Data Source 2-step Auth Content Type Not Supported

The Web Service Data Source will only POST the body of the Authentication request as 'text/plain' and I need to be able to authenticated to web services requiring 'application/json' content type.

Currently I am unable to authenticate due to a 415 Unsupported Media Type error.

Is there any way to change the content type in the header of the authentication request?

General Discussions

answered on 28 Sep 2020

8 answers

1.0K+ views

[Solved] Internal Server Error: Parameter is not valid when export to PDF

Dear Telerik team,

I always got error "Internal Server Error: Parameter is not valid." when I export report to PDF from Html5 report viewer.
This issue happen when I upload project to online server Windows Azure. But it is not happen on local or test environment.

Error message is in attached image.

Thanks.

General Discussions

answered on 24 Sep 2020

1 answer

95 views

Telerik Reporting

Hi
I want to Sum on conditional basis on string field just like this If SalesTypes = "Ledger" then add Cash in Hand field
or Sum(IIF(Fields.SalesType=="Ledger",Field.Cashinhand,0)))
So please help me out I have read so many article but didn't find any solution.

General Discussions

answered on 23 Sep 2020

3 answers

425 views

Report Header and Detail Section does not print together

I want to print Detail Section in the first page, but it could not, all components's keep together are setted false, but it's no effort,

And the Catogary Name does not print on every Page.

My demo code is bellow:

<?xml version="1.0" encoding="utf-8"?>

<Report Width="18.1cm" Name="Report1" xmlns="http://schemas.telerik.com/reporting/2020/1.0">

<DataSources>

<JsonDataSource Name="jsonDataSource1">

<Source>

<String

>Ww0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiAxfSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogMn0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDN9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiA0fSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogNX0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDZ9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiA3fSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogOH0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDl9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiAxMH0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDExfSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogMTJ9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiAxM30sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDE0fSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogMTV9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiAxNn0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDE3fSwNCnsiTmFtZSI6IlRFU1QiLCAiQW1vdW50IjogMTh9LA0KeyJOYW1lIjoiVEVTVCIsICJBbW91bnQiOiAxOX0sDQp7Ik5hbWUiOiJURVNUIiwgIkFtb3VudCI6IDIwfQ0KXQ==</

String>

</Source>

</JsonDataSource>

</DataSources>

<Items>

<DetailSection KeepTogether="False" Height="1.217cm" Name="detailSection1">

<Items>

<List Width="17.905cm" Height="1.217cm" Left="0cm" Top="0cm" KeepTogether="False" Name="list1">

<Body>

<Cells>

<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<Panel Width="16.2cm" Height="1.217cm" Left="0cm" Top="0cm" KeepTogether="False" Name="panel1">

<Items>

<Table DataSourceName="jsonDataSource1" Width="16.2cm" Height="1.217cm" Left="0cm" Top="0cm" KeepTogether="False" Name="table1">

<Body>

<Cells>

<TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="5.4cm" Height="0.608cm" Left="0cm" Top="0cm" Name="textBox6">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="5.4cm" Height="0.608cm" Left="8.095cm" Top="0.6cm" Value="= Fields.Name" Name="textBox8" StyleName="">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="5.4cm" Height="0.608cm" Left="8.095cm" Top="0.6cm" Value="= Fields.Amount" Name="textBox2" StyleName="">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

</Style>

</TextBox>

</ReportItem>

</TableCell>

</Cells>

<Columns>

<Column Width="5.4cm" />

</Columns>

<Rows>

<Row Height="0.608cm" />

</Rows>

</Body>

<Corner />

<Style Visible="True">

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

<RowGroups>

<TableGroup Name="detailTableGroup">

<Groupings>

<Grouping />

</Groupings>

</TableGroup>

</RowGroups>

<ColumnGroups>

<TableGroup Name="tableGroup">

<ReportItem>

<TextBox Width="5.4cm" Height="0.609cm" Left="0cm" Top="0cm" Value="Name" Name="textBox1">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

</TextBox>

</ReportItem>

</TableGroup>

<TableGroup Name="tableGroup1">

<ReportItem>

<TextBox Width="5.4cm" Height="0.609cm" Left="0cm" Top="0cm" Value="Amount" Name="textBox3">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

</TextBox>

</ReportItem>

</TableGroup>

<TableGroup Name="tableGroup2">

<ReportItem>

<TextBox Width="5.4cm" Height="0.609cm" Left="0cm" Top="0cm" Name="textBox5">

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

</TextBox>

</ReportItem>

</TableGroup>

</ColumnGroups>

</Table>

</Items>

</Panel>

</ReportItem>

</TableCell>

<TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">

<ReportItem>

<TextBox Width="1.705cm" Height="1.217cm" Left="0cm" Top="0cm" KeepTogether="False" Value="Catogary Name" Name="textBox7" StyleName="">

<Style TextAlign="Center" VerticalAlign="Middle" />

</TextBox>

</ReportItem>

</TableCell>

</Cells>

<Columns>

<Column Width="1.705cm" />

<Column Width="16.2cm" />

</Columns>

<Rows>

<Row Height="1.217cm" />

</Rows>

</Body>

<Corner />

<Style>

<BorderStyle Top="Solid" Bottom="Solid" Left="Solid" Right="Solid" />

<BorderColor Top="Black" Bottom="Black" Left="Black" Right="Black" />

<BorderWidth Top="1pt" Bottom="1pt" Left="1pt" Right="1pt" />

</Style>

<RowGroups>

<TableGroup Name="DetailGroup">

<Groupings>

<Grouping />

</Groupings>

</TableGroup>

</RowGroups>

<ColumnGroups>

<TableGroup Name="group" />

<TableGroup Name="ColumnGroup" />

</ColumnGroups>

</List>

</Items>

</DetailSection>

<ReportHeaderSection KeepTogether="False" Height="0.5cm" Name="reportHeaderSection1">

<Items>

<TextBox Width="3cm" Height="0.5cm" Left="7.7cm" Top="0cm" Value="TEST" Name="textBox14" />

</Items>

</ReportHeaderSection>

</Items>

<PageSettings PaperKind="Custom" PaperSize="210mm, 60mm" Landscape="False" ContinuousPaper="False">

<Margins>

<MarginsU Left="1cm" Right="1cm" Top="1cm" Bottom="1cm" />

</Margins>

</PageSettings>

<StyleSheet>

<StyleRule>

<Style>

<Padding Left="2pt" Right="2pt" />

</Style>

<Selectors>

<TypeSelector Type="TextItemBase" />

<TypeSelector Type="HtmlTextBox" />

</Selectors>

</StyleRule>

</StyleSheet>

</Report>

Report Designer (standalone)

answered on 23 Sep 2020

1 answer

96 views

Graph extended on several pages possible?

Hi, I have a graph(stacked bars type) that is for showing departments. At the moment its on one page, its height is enough to display 40 departments, however if the data includes more than 40 the graph will still just be one page, not displaying the remaining data.

Is it possible to make the graph extend onto the next page/grow untill it has displayed all the data?
If no, is it possible to program the height somehow through code (so i could calculate the correct height based on the data it will receive)?

General Discussions

answered on 21 Sep 2020

2 answers

186 views

Column groups are displayed diagonally

Hi, I have a problem formatting the report. I set up column groups, but the next group always appears below the previous one. I attach picture for illustration. Is there any way to display the data side by side? Thank you

Report Designer (standalone)