Telerik Forums
Reporting Forum
2 answers
152 views

Telerik Report Designer – Does *not* collapse empty sections.  I can use Expressions and Conditional formatting to blank out certain detail records or fields, for example, but the final report leaves an empty gap; it does not “collapse” the suppressed section.

Stef
Telerik team
 answered on 02 Mar 2017
8 answers
592 views
Hi,
I have created a report with a landscape layout but when I try to export it with the ReportViewer (for WebForm and in PDF format) the report is always rendered with a portrait layout.

Is there any way to adjust this issue?? Thanks

Michael
Stef
Telerik team
 answered on 02 Mar 2017
4 answers
169 views
Hello,

We used Telerik UI for Silverlight and Telerik Reporting and when we try to export the report to Excel with FIPS Algorithm Policy enabled in the server, we are getting the error "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms". We version of the Telerik components we are using are below:

UI for Silverlight:2014.3.1202.1050
Reporting:802.14.1204

I know that Telerik UI for ASP.NET AJAX officially supports the FIPS standard as stated in your documentation. Could you please confirm if the above components do not support FIPS?

Thank you,
Sherwin
Stef
Telerik team
 answered on 02 Mar 2017
5 answers
138 views

Hi,

Our company has been using Telerik Reporting Q2 2014 to generate PDFs for our web app. We're undergoing a migration from an Azure VM to an Azure Web Apps set-up. Unfortunately Azure Web Apps does not have Garamond installed, so we've been considering upgrading to Telerik R3 2016 SP1 to use the privateFonts feature.

In my local testing when Garamond is installed and used natively (our current situation), the alignment of header text in tables is different to when it is used via privateFonts. I've prepared a Minimal Example (at my non-corporate github: https://github.com/Blimply/PrivateFontsMWE/tree/master) and attached a comparison screenshot of two example PDFs.

Reproduction steps:
 - Generate a PDF document using an installed font
 - Uninstall the font and logout/login
 - Generate a PDF document in the same font using the privateFonts feature

I know it looks reasonably small in the provided shots but it's quite noticeable in many of our business documents. We've got a lot of documents so it'd be a pain to realign them all manually.

Any help would be appreciated!

Stef
Telerik team
 answered on 02 Mar 2017
5 answers
111 views

I have a procedure pr.test which has 3 parameters @id @date_from @date_to. This procedure is set as datasource to a report.Report's parameter id is set as multivalue and in preview i saw my values perfectly ,but with now functionality because i have forgotten to connect them with procedure parameters.When finally i connected them i lost multivalues that i had before. I have the dropdown box but with no values.Please help.I've tried with no luck to setup the datasourse firstly and then to  make new parameters but nothing different happened . i have the drop down box but with no values.I ve attached you a screenshots with parameters settings.

 

ps if i set pamameter as a single textbox and write the id works perfectly but my point is to have as a display value a name(it field in my procedure) and as a value my id(it is also field in db)

 

 

Stef
Telerik team
 answered on 02 Mar 2017
3 answers
397 views

I have successfully created reports with additional Table items (i.e. in the report footer) that share the same main report datasource, and avoid having it re-execute.  This works well.

However I now have a different scenario.  We use just Designer for building reports, and entity datasources which are all calls to SQL Server stored procedures.

I have a Master datasource, call it M, which is the main report datasource.  The detail section has a few fields from M, plus a small Table.  I use a Table as you recommend that as more efficient than a subreport.  I have a second datasource for details fetched for all master rows call it D.  The Table is assigned to D, and I can get a filter condition on the table by referring to a Key field in M.  This all actually displays properly, each Table displays the proper 2 or 3 rows filtered out of the entire D result set.

However, the datasource D is being re-executed for every master Detail section being displayed.  I somewhat expected that, but still is very bad.

Also just as a bonus, I have one additional table in the report Footer and refers to the same datasource D and summarizes that data, and of course it causes the datasource D to execute yet one more time.

I have read many articles here but I have not seen a master-detail example using entity data source, and just Report Designer, and avoiding the multiple re-executions of the D datasource.  I have done a similar layout in SSRS and the detail datasource is executed only once then shared, but I can not find the equivalent implementation using your Report Designer.  Thanks.

Stef
Telerik team
 answered on 02 Mar 2017
5 answers
350 views

I'm having an intermittent issue where calls to the reporting REST API service are failing with a 500 error (below).

The steps that are occurring are:

  1. Report run is initiated.
  2. Can see successful POST to the instances URL: ~/api/reports/clients/113946-7092/instances.  Responds with: {"instanceId":"105138-bc13"}.
  3. Can see successful POST to the documents URL: ~/api/reports/clients/113946-7092/instances/105138-bc13/documents. Responds with: {"documentId":"114313-ce58114313-a5ac"}
  4. Can see unsuccessful GET to the info URL: ~/api/reports/clients/113946-7092/instances/105138-bc13/documents/114313-ce58114313-a5ac/info.  Responds with the below 500 error.

If I keep clicking the Preview button (with the same parameters set), eventually, one of the requests will complete successfully and the report runs.  Otherwise, the above happens.

Has anyone run into this before?

500 error being returned:

{
    "message": "",
    "exceptionMessage": "Invalid report typeException has been thrown by the target of an invocation.",
    "exceptionType": "Telerik.Reporting.Services.Engine.DocumentRenderException",
    "stackTrace": "   at Telerik.Reporting.Services.Engine.Document.GetDocumentInfo() in c:\\temp\\reporting\\RBuild-28809\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.Engine\\Document.cs:line 181\r\n   at Telerik.Reporting.Services.Engine.ReportEngine.GetDocumentInfo(String clientID, String instanceID, String documentID) in c:\\temp\\reporting\\RBuild-28809\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.Engine\\ReportEngine.cs:line 391\r\n   at Telerik.Reporting.Services.WebApi.ReportsControllerBase.GetDocumentInfo(String clientID, String instanceID, String documentID) in c:\\temp\\reporting\\RBuild-28809\\Reporting_Build\\Source\\Code\\Telerik.Reporting.Services.WebApi\\ReportsControllerBase.cs:line 291\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__0.MoveNext()"
}
Katia
Telerik team
 answered on 02 Mar 2017
3 answers
425 views

Hello, 

i have a table and want to set the backcolor of my cells to the Hex-Value that is stored in my Fields. Is this even possible and if yes, how can i do this?

Greets, Philipp

Philipp
Top achievements
Rank 1
 answered on 01 Mar 2017
1 answer
65 views
I currently develop using the designer and use the telerik_ReportViewer to render these on a website for end users. I currently have a set of around 50 reports. Is there a way to create something that will enable my users to "favorite" reports and have that be saved somewhere to create a "my favorites" list with links to their favorite reports? 
Katia
Telerik team
 answered on 01 Mar 2017
2 answers
126 views

We just upgraded from Sept 2016 to Oct 2016.  The user said he did not have this issue with the previous version.  The only thing I changed in the app was that it updated it when I upgraded the controls.  I compiled and this is what we are seeing:  (makes it hard for users to sort)

 

Mark
Top achievements
Rank 1
 answered on 01 Mar 2017
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?