Telerik Forums
Reporting Forum
1 answer
270 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
137 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.2K+ 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
135 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
120 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
293 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
117 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
168 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
1 answer
312 views

How does parameter binding in the HTML reporting control - when using report parameters and datasource parameters. 

I have a file that works 100% in the designer - where the report parameters are linked to the datasource parameters ( FWIW - using postgres so no name parameters - they are ? in the query source). 

I have 2 parameters per query...   and they are bound to the Report parameters.

So each query has a section like this in the designer.

I am using the reports controller to return the report to the client...    but when using the html version -  the parameter binding doesn't seem to work and this i end up with syntax errors -  as it looks like the ?  is never replaced in the query.

The report parameters section renders fine..  and will match what i set via the parameters object. 

Using fiddler i can see the post to the below URL  setting my param to the values I choose..

http://localhost/reporting/api/reports/clients/cabb01e7aa1/parameters

But the query still fails with syntax error ( that doesn't happen in the designer).

I was hoping to leave "parameters"  blank -   since I dont want to set them independently of the reports parameters section. 

If I leave it blank...  the post to http://localhost/reporting/api/reports/clients/acb333b0fd4/instances  shows the default parameters from the parameters area...   but i still get syntax error. 

We are serving the report via a custom resolver returning the actual trdx file...    and it does contain the section i expect - which maps report parameter to query parameter... 

 

 

 

I don't know how to resolve or move forward -   any advise on how to resolve or what else i can post to try and assist diagnosing the issue ?

Steve

 

 

 

 

 

 

Todor
Telerik team
 answered on 01 Feb 2022
1 answer
186 views

I am a newbi to Telerik.Reporting, and wants to understand how CsvDataSource is connected to the Report. 

If I want to add two DataSources:

Source1:

MyCompanyId Name address ..... accountnumbers ..... <-- meta data for the heading of an invoice

Source2:

CustNum Name Address ...... etc    <-- these are meta data for the customer

Source3:

CustNum OrderNum ItemNum <-- these are the details of the report

How should I do this? I understand that if I put everyting on each line of Source3, it will work, but then I add a lot of unnesseary data.. 

I could probably add a Type: H for header and R for row on Source3 so that I only need to add an empty space for each of the header data, but that also seems kind of .... 

What will be the best way of doing this?

What if I use Json? Would that be easier? and if so, how?

Todor
Telerik team
 answered on 31 Jan 2022
Top users last month
Will
Top achievements
Rank 2
Iron
Motti
Top achievements
Rank 1
Iron
Hester
Top achievements
Rank 1
Iron
Bob
Top achievements
Rank 3
Iron
Iron
Veteran
Thomas
Top achievements
Rank 2
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?