Telerik Forums
Reporting Forum
3 answers
266 views

Hello everyone,

I have a question about the possibilities in the detail section:

we have multiple transports where each transport can have multiple kinds of goods and we would like to use the detail section to show both of them.

It should look like this (simplified) e.g.:


Truck A
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples

Truck B
                4 Pal. Cups
                2 Pal. Gloves


…..

The problem is that in SQL we have no other possibility to join the tables so that the result looks like see att..

This will transform in multiple lines:

Truck A
                2 Pal. Lights
Truck A
                1 Pal. Bananas
Truck A
                20 Pal. Apples

Truck B
                4 Pal. Cups
Truck B
                2 Pal. Gloves

I also tried to use a table or a list Item but both would show all results for each entry.

Truck A
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples
                4 Pal. Cups
                2 Pal. Gloves

Truck B
                2 Pal. Lights
                1 Pal. Bananas
                20 Pal. Apples
                4 Pal. Cups
                2 Pal. Gloves

Is there any possibility with another item, format, filter,group ..anything to get one row for each truck and with the goods for this one?

 

 


Neli
Telerik team
 answered on 07 Oct 2020
1 answer
496 views
I’m trying to pass in a list of integer IDs from within C# by setting a Telerik.Reporting.ReportParameter.Value.  I have tried a number of combinations of object types, from passing in a string of comma separated values to passing in an IEnumerable of Integers to no avail.  I have tried using the Array function on Designer side, but no matter what combination I try, I’m receiving an error that the value for WidgetIDList is invalid.  I was wondering what the object should look like that I set in the C# code, and what I should set the Value in the Telerik Report Designer for the parameter that will be passed to the stored procedure to generate results.  I’ve gone over the notes on the website over and over, and looked at a few articles on workarounds posted here, and still haven’t been able to determine a solution.  I would try to pass a string of comma separated values, but our UI relies on the AvailableValues to be set so that it can populate a dropdown list in our UI for the user to select from.  I'm wondering if that's what's causing the issue, the validation not liking what I'm passing. Thanks for your assistance.

Parameter being passed in
Name: WidgetIDList
AllowBlank: False
AllowNull: False
AvailableValues: dsGetAllWidgetNames [Telerik.Reporting.SqlDataSource] (This is a SQLDataSource that uses a connection string to call a stored procedure to populate the values.)
DataSource: dsGetAllWidgetNames [Telerik.Reporting.SqlDataSource]
DisplayMember: = Fields.WidgetName
Filters: (No Filters)
Sortings: (No sorting)
ValueMember: = Fields.WidgetID
Mergeable: True
MultiValue: True
Name: WidgetIDList
Text: Widget
Type: Integer
Value:
Visible: True

Parameter to be passed to Stored Procedure to generate results
@WidgetIDList: Telerik.Reporting.SqlDataSourceParameter
DBType: AnsiString
Name: @WidgetIDList
Value:
Neli
Telerik team
 answered on 05 Oct 2020
1 answer
186 views

Hi.

My report contains a table that is expected to not fit on a single page so it has KeepTogether set to false. It also has ColumnHeadersPrintOnEveryPage set to true. 

In print preview or when rendered as DOCX or PDF the table splits correctly, i.e. a blank row is drawn at the end of the first page indicating that the table continues on the next page. 

When rendered into PPTX however (which is the target format for me) the blank row gets drawn at the start of the next page instead. It would not be that much issue without table headers repeating on every page. With them it looks quite confusing.

Neli
Telerik team
 answered on 02 Oct 2020
3 answers
477 views

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

Todor
Telerik team
 answered on 02 Oct 2020
5 answers
350 views

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?

Matthew
Top achievements
Rank 1
 answered on 30 Sep 2020
1 answer
652 views

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.

 

 

 

Todor
Telerik team
 answered on 30 Sep 2020
1 answer
760 views

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.

Silviya
Telerik team
 answered on 30 Sep 2020
4 answers
1.2K+ views

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?

 

sky
Top achievements
Rank 1
 answered on 30 Sep 2020
1 answer
460 views

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?

 

 

Neli
Telerik team
 answered on 28 Sep 2020
8 answers
1.0K+ views
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.
Neli
Telerik team
 answered on 24 Sep 2020
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?