Questions on Reporting Forum

3 answers

396 views

Automatic (alphabetically) sorting of Parameters in Report Explorer

Hello everyone,

is there any possibility to automatically sort the parameters in the report explorer? I know you can sort manually if you use the 'edit parameter' function but i would need an automatic way.

Regards

Report Designer (standalone)

answered on 02 Oct 2020

5 answers

282 views

An unhandled exception has occurred : Telerik.ReportViewer.WebForms.StreamManager.GetHtmlPage(Int32 pageIndex)

Hello.

I have a normal report and when I click to see the next page this error occurs :

Exception information:
    Exception type: NullReferenceException
    Exception message: Object reference not set to an instance of an object.
   at Telerik.ReportViewer.WebForms.StreamManager.GetHtmlPage(Int32 pageIndex)
   at Telerik.ReportViewer.WebForms.ReportPageOperation.WriteHtmlPage(StreamManager streamManager, Int32 pageIndex)
   at Telerik.ReportViewer.WebForms.BasicHandler.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Request information:
    Request URL: .... Telerik.ReportViewer.axd?instanceID=0cdcda6604764ba2a837581cedb1ae5f&optype=Report&PageIndex=1&RenderID=312cd5f978ca4b8baf48ad45439e270e&RenderingFormat=HTML5
    Request path: /Telerik.ReportViewer.axd

Any idea?

General Discussions

answered on 30 Sep 2020

1 answer

567 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

707 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.1K+ views

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

406 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

936 views

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

77 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

365 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

69 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