Telerik Forums
Reporting Forum
3 answers
260 views

I am looking for an example on how to show the percentage difference from one column to the next in a crosstab.

I have a report that shows sales per month in dollars. For each month, I have added an additional column to the right that should show this value.

Hown can this be done? Everything points to some custom code which is not acceptable for my situation.

Example. 

January   February    March 

$100  0%  $120  20%  

Stef
Telerik team
 answered on 02 Mar 2017
2 answers
154 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
604 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
178 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
142 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
116 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
399 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
358 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
431 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
71 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
Top users last month
Cynthia
Top achievements
Rank 1
Iron
Toby
Top achievements
Rank 3
Iron
Iron
Iron
Danielle
Top achievements
Rank 1
Iron
Iron
Joel
Top achievements
Rank 3
Bronze
Bronze
Iron
yw
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?