Telerik Forums
Reporting Forum
5 answers
128 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
110 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
386 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
335 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
411 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
60 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
117 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
3 answers
206 views

Morning.

I am wondering if this is possible using the standalone designer.

I have a report already built that I need to insert a subreport into. However, the sub report needs to use a CSV file as its datasource (main report is using SQL Native). The path to this CSV is stored as a STRING in my main report query. So the MainReport has a SQL statement similar to:

Select Field1, Field2, ....'Path to CSV File' as dsCSV  From SomeTable

I know need to tell the subreport that the field dsCSV is the path to the file it should use.

Any ideas as to if this is possible (good program so I assume everything is possible) and how it would be done (looking for an example).

Note that I only have the standalone designer.

Thanks,

Brian

Katia
Telerik team
 answered on 01 Mar 2017
1 answer
118 views

I have big report that take around 2 min until finish generating the report, while the report is processing, I am unable to load another page.

 

I read it could be session blocking issue, so I tried to use async Task in the .NET to get the Data from the server, but still I am unable to  load another page in  the same time.

 

I am trying to load another page while report viewer is generating the report

Please Help !

Stef
Telerik team
 answered on 28 Feb 2017
5 answers
307 views
Hi
1-When we allow null value in a parameter so that if end user has not selected any value report can get all data, it adds a check box in Parameter section with text "Null". i want to change this word "Null" with some of my own text like "all sectors" because the end user the word null is not clear, i is technical word and only developers know it? how can i change it?

Stef
Telerik team
 answered on 28 Feb 2017
Top users last month
Jay
Top achievements
Rank 3
Bronze
Iron
Iron
yw
Top achievements
Rank 2
Iron
Iron
Stefan
Top achievements
Rank 2
Iron
Iron
Iron
Kao Hung
Top achievements
Rank 1
Iron
Bohdan
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?