Telerik Forums
Reporting Forum
1 answer
239 views

Hello,

We have an odata api that limits the maximum number of records that can be returned to the client to 1000 records. The service allows for query parameters $top and $skip that allow us to page through the data, which works great in kendo grids, etc. For reporting though, I'm wondering if there's any way using the web service data source to somehow auto-page through data until it gets through all of the pages of data, that way we get all of the data from the api server without worrying about only being able to retrieve the fist page of 1000 records only? Is this a thing?

Thank you in advance!

Brandon

Todor
Telerik team
 answered on 10 Feb 2022
1 answer
252 views

We have a report with a multivalue parameter whose record source may include ~32k rows of data.  Thanks to virtualization, the user is able to scroll through the entire list selecting as many options as they wish.  Unfortunately, if the user selects the "<select all>" option, the application becomes immediately unresponsive, and the only way to continue is to restart the application by performing an end task in the windows task manager.

 

Questions:

  1. Is there any way to prevent this hard lockup in the current scenario?
  2. Is there some way to remove the "<select all>" option, either by default or when the data in the combobox exceeds a threshold?
Todor
Telerik team
 answered on 10 Feb 2022
1 answer
339 views

I have embedded web designer using this link. It's working fine but I want to hide some data sources from the list. Currently it's showing 5 data sources i.e SqlDataSource, CsvDataSource, WebServiceDataSource, JsonDataSource and ObjectDataSource.

I want to keep only CsvDataSource and hide all others. How can I do that programmatically?

Sia
Telerik team
 answered on 10 Feb 2022
1 answer
196 views

Hi,

We have old version of Telerik reporting . and old version of Kendo UI library(on our client side)

we use with Rest API in server side and with HTML5 Telerik report viewer in client side. 

Now we want to upgrade our Telerik reporting version.

The behaviour of the new HTML5 report viewer depends on a new version of the Kendo ui.

We have a big project and we do not want to upgrade Kendo Ui library.

Is it possible to upgrade only the server side of the reports?
Without upgrading Reporter Viewer?

 

Thanks,

Chani

 

Todor
Telerik team
 answered on 09 Feb 2022
1 answer
1.4K+ views

Hello,

I'm using the Reporting Tool with an Angular Frontend and have a question how the authentication works.
The report is created with the standalone ReportDesigner and contains one SubReport.

In the frontend the authentication token is assigned:
<tr-viewer 
...
    [authenticationToken]="authenticationToken"
</tr-viewer>

In the Designer a 2-step authentication is configured - only for design purpose.

The desired behaviour is that the authenticationToken assigned in the frontend is used when accessing the backend controller. But the observed behaviour is that the report requests multiple times (3) new tokens by calling the login URL assigned to the 2-step authentication config. 

How can I configure the Report so that no new tokens are requested and the one assigned on the frontend is used (via Bearer xxxx). Nevertheless the Controller Entry-Point for data retrieval for the report dataSource must be protected. And what is the report auth behaviour by design?

Todor
Telerik team
 answered on 04 Feb 2022
0 answers
195 views

I have a ridiculously simple graph I want to build.  The data source works fine, and returns 2 columns:  a "bin" (number from 0 to N) and a "count".  So the data looks like this:

BagActivityAfterXDays,  Count

0, 35

1, 20

2, 5

3, 0

 

I used the wizard to build the chart like this:

 

But this is all I get, in designer or preview, with no context as to what on earth is going on:

 

Please help - I'm stuck in the mud and can't figure out what is wrong, or how to fix it.

Johann
Top achievements
Rank 1
 updated question on 03 Feb 2022
2 answers
164 views

I need to display large amounts of text in side by side columns that flow from the bottom of one to the top of the next one, and continue onto a following page.  Is it possible?  I'm including a diagram to explain what I mean.

 

  
Timothy
Top achievements
Rank 1
Iron
 answered on 03 Feb 2022
1 answer
379 views

I have a PDF report to create..  Its usually 2 pages long and contains the information for a single record.  It is generated by manual selection one record at a time.  It already includes a sub-report with multiple child entities related to the parent record.

The thing is the parent record contains 134 fields.  I've got these split into multiple related panels currently

For maintainability, is it easier to split the panels into sub-reports?  Is there any performance issue with that? Although only 1 report is selected at a time.

I find that when I have to make a change the desktop report designer isn't very user friendly when panels need to be moved down to expand a prior panel. 

Or am I just not familiar with the designer enough to more things around efficiently?

Todor
Telerik team
 answered on 02 Feb 2022
0 answers
152 views

I have a report that's basically an export of a SQL View.

Parameters are passed in to filter the view based on Venue and a range of Event Date (i.e.: EventDate between (@StartDate) and (@EndDate)

The report is rendered correctly, except that I cannot get a page number using

= PageNumber("detailSection1", Fields.Venue) + " of " + PageCount("detailSection1", Fields.Venue)

It appears that this will only work if there is something in detailSection1. Only thing there is the table.

If I add Fields.Venue into detailSection1, I get that page # and count, but the problem is that I get one page for each row in the view since Venue is part of it.

I tried this with no luck = PageNumber("VenueSummaryTable", Fields.Venue) + " of " + PageCount("VenueSummaryTable", Fields.Venue)

So, how do I get the table to only appear once and be able to get the page # and page count?

Taras
Top achievements
Rank 3
Iron
Iron
Veteran
 asked on 01 Feb 2022
1 answer
226 views

I'm configuring a custom format for a SQL datasource using Telerik (desktop) Report Designer v14.2.21.115.

I create the custom format for a date field as such

I click OK and when I preview the report I get an error "Input string was not in a correct format".  Looking at the custom format settings again, the value type changes back to numeric as below

Why does the Value Type change back to Numeric?

A similar issue occurs with CallTime when I format it as HH:mm

The property for the fields do contain the appropriate format values

Taras
Top achievements
Rank 3
Iron
Iron
Veteran
 answered on 01 Feb 2022
Top users last month
Hiba
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
Max
Top achievements
Rank 1
Veteran
Iron
Alina
Top achievements
Rank 1
Rakhee
Top achievements
Rank 1
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?