Telerik Forums
Reporting Forum
4 answers
426 views
Hello,

I have the following problem: I have Telerik Report Q2 2010 class with SqlDataSource set on stored procedure. This procedure has several output parameters which are (obviously) evaluated during procedure's execution. Also, this procedure returns some columns from database. Now what I want is to retrieve these parameters value after execution of procedure and use them in designer (something like "{Fields.ReturnedValue}" in for example textbox).

What is the simpliest way to do this? Some examples would be helpful.

Best regards
Rafael
Silviya
Telerik team
 answered on 24 Jan 2019
1 answer
129 views
I got it how to use it ...
Priyanka
Top achievements
Rank 1
 answered on 24 Jan 2019
0 answers
269 views

Hello there ,

 I have a problem to loading the report from localhost , below is the my project environment 

1. Angular 5 , typescript 2.5.3 , ASP.Net Core2.0 , VS 2017 and Telerik Selhost Report service project .

   Issue : I have publish the project one my folder then i create a web site from my IIS  then reference to my published folder .  Then i have tested  from browser like " http://localhost:12345/api/reports "  then formats are loading 

        [{"name":"PDF","localizedName":"Acrobat (PDF) file"},{"name":"CSV","localizedName":"CSV (comma delimited)"},{"name":"XLS","localizedName":"Excel 97-2003"},{"name":"XLSX","localizedName":"Excel Worksheet"},{"name":"PPTX","localizedName":"PowerPoint Presentation"},{"name":"RTF","localizedName":"Rich Text Format"},{"name":"IMAGE","localizedName":"TIFF file"},{"name":"MHTML","localizedName":"Web Archive"},{"name":"DOCX","localizedName":"Word Document"},{"name":"XPS","localizedName":"XPS Document"}]

Then i try to call this report from Angular project using type script like below .

   @Component({
    selector: 'printReport',
    template: `<tr-viewer #viewer1 
    [containerStyle]="viewerContainerStyle"
    [serviceUrl]="'http://localhost:12345/api/reports'"
    [templateUrl]="'node_modules/@progress/telerik-angular-report-viewer/dist/dependencies/telerikReportViewerTemplate-sass.html'"
    [reportSource]="Viewdata"
    [scaleMode]="'SPECIFIC'"
    [scale] = "1.0"
    [renderingEnd]="boundReportRendered"
    [error]="ReportError"
    [viewMode]="'PRINT_PREVIEW'">
    </tr-viewer>
    <button id='btnprint' style="display:none;" name='btnprint' (click)="viewer1.commands.print.exec()">Print</button>`,
   
})

So, report is not loading then i check this in Fiddler it gives error like :

stackTrace=   at Telerik.Reporting.Services.Engine.ReportEngine.ResolveReportSource(String report)
   at Telerik.Reporting.Services.Engine.ReportEngine.GetParameters(String clientID, String report, Dictionary`2 parameterValues)
   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource)
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()

 

I am unable to duplicate this , can please help out to solve this issue .

 

 

 

Thanks

Victor.A

 

        

   

 

 

 

 

victor
Top achievements
Rank 1
 asked on 24 Jan 2019
1 answer
218 views

I am unable to get either of the new .NET Core samples to compile with both giving me the following error:

SeverityCodeDescriptionProjectFileLineSuppression State
ErrorNU1101Unable to find package Telerik.Reporting.OpenXmlRendering. No packages exist with this id in source(s): https://dotnetfeed.blob.core.windows.net/dotnet-core/index.json, Microsoft Visual Studio Offline Packages, nuget.org, TelerikCSharp.AspNetCoreDemoC:\Program Files (x86)\Progress\Telerik Reporting R1 2019\Examples\CSharp\Asp.NetCoreDemo\CSharp.AspNetCoreDemo.csproj1

Any thoughts?

Thank you,

Scott

Todor
Telerik team
 answered on 23 Jan 2019
1 answer
238 views

I have previously created a report in the standalone designer and successfully deployed it to my server with an api.  I was able to view it in my Angular application.  This worked fine using the .trdp file.  However, I recently tried creating a report in the Visual Studio designer and am having difficulty getting it deployed to my server.  I see there is no .trdp file.  Are there any files that are supposed to be generated and reside in the reports folder if I am doing it this way?  Is everything just compiled?  

I am getting the error "Unable to get report parameters. Report 'MyReport' cannot be resolved."  My report does not have any parameters and my controller code contains a call to .AddFallbackResolver.  

Please let me know what steps can be taken to a resolution.

 

Thanks,

Jennifer

Silviya
Telerik team
 answered on 23 Jan 2019
1 answer
287 views

We have a report where the data sources are provided as CSV files. In some scenarios, not all of these CSV files provided even though they are configured in the report. In standalone designer fields that have missing data sources will only show empty spaces. But when trying to generate through programmatically an error given as "Output error: Could not find file 'C:\DataSource\MissingFileName.csv'.".  Is there a way that programmatically to remove those data sources from a report item if the CSV file is missing which will show empty spaces in the output file? 

 

Thank you

Janitha
Top achievements
Rank 1
 answered on 23 Jan 2019
7 answers
1.5K+ views
Can you create a custom Report Viewer toolbar? Specifically can certain options be hidden and can you style the toolbar?
Neil N
Top achievements
Rank 2
Iron
Iron
Veteran
 answered on 22 Jan 2019
2 answers
411 views

Hello. I've faced a problem trying to use HTML5 MVC Report viewer when using a .dll file loaded during runtime. I'm using a custom report resolver which creates TypeReportSource, sets a type name which I get from the loaded .dll  and then returns the created report source. However, the report viewer displays an error. (Stack trace below).

 

Is it possible to use reporting service with a dynamically loaded .dll like that? Or is it only possible if I reference the .dll in my project directly (when I do that, everything works, but this is obviously not a desired way for me)

stackTrace: "   в Telerik.Reporting.Processing.TypeReportDocumentResolver.Resolve(IProcessingContext context, TypeReportSource rs)<br>↵   в Telerik.Reporting.Processing.ReportDocumentResolver`1.Telerik.Reporting.Processing.IReportDocumentResolver.Resolve(IProcessingContext context, ReportSource rs)<br>↵   в Telerik.Reporting.Processing.ReportDocumentResolver.<>c__DisplayClass1.<Resolve>b__0(IReportDocumentResolver r)<br>↵   в Telerik.Reporting.Processing.ReportDocumentResolver.Bind[T](IProcessingContext context, ReportSource source, Func`2 func)<br>↵   в Telerik.Reporting.Processing.ReportDocumentResolver.Resolve(IProcessingContext context, ReportSource source)<br>↵   в Telerik.Reporting.Processing.ResolvedReportDocument.ResolveReportsRecursively(ReportSource rs, IProcessingContext context, IDictionary`2 parentRsParameters, Boolean parentShouldDispose, List`1 result, IReportDocument& definition, ResolvedReport& tocReport, ReportBookTocPosition& tocReportPosition)<br>↵   в Telerik.Reporting.Processing.ResolvedReportDocument.Create(ReportSource rs, IProcessingContext context)<br>↵   в Telerik.Reporting.Services.Engine.ReportEngine.GetParameters(String clientID, String report, Dictionary`2 parameterValues)<br>↵   в Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetParameters(String clientID, ClientReportSource reportSource) в c:\temp\reporting\RBuild-18776\Reporting_Build\Source\Code\Telerik.Reporting.Services.WebApi\ReportsControllerBase.cs:строка 166<br>↵   в lambda_method(Closure , Object , Object[] )<br>↵   в System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetExecutor>b__3(Object instance, Object[] methodParameters)<br>↵   в System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)<br>↵   в System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)<br>↵--- Конец трассировка стека из предыдущего расположения, где возникло исключение ---<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)<br>↵   в System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()<br>↵--- Конец трассировка стека из предыдущего расположения, где возникло исключение ---<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)<br>↵   в System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()<br>↵--- Конец трассировка стека из предыдущего расположения, где возникло исключение ---<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)<br>↵   в System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)<br>↵   в System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()"
Nikita
Top achievements
Rank 1
 answered on 22 Jan 2019
3 answers
1.5K+ views

Hi,

We need to know if there is any workaround for printing each Table Group on New page. Basically our Report Datasource is already bind and having Group with setting Page Break After in Group Footer.  Report contains a Table having different Datasource also having Grouping. Now it is required that each Table Group should appear on next Page addition to existing Report group. 

Please advise any way to address the requirement...

Thanks,

Silviya
Telerik team
 answered on 21 Jan 2019
0 answers
139 views

I have a subreport that is being hidden under certain conditions. That is no problem and is working. However it still appears the subreport is executed when it's visibility is set to false, can I stop that behaviour.

 

The reason is if the subreport contains too much information I don't want it to run as it takes too long. 

Craig
Top achievements
Rank 1
 asked on 21 Jan 2019
Top users last month
Edmond
Top achievements
Rank 1
Iron
fabrizio
Top achievements
Rank 2
Iron
Veteran
RobMarz
Top achievements
Rank 2
Iron
Fakhrul
Top achievements
Rank 1
Iron
Tejas
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?