Telerik Forums
Reporting Forum
4 answers
1.0K+ views

Hi, currently we are using version 12.2.18.1017 of telerik reporting.

we are thinking of upgrading to the latest version since you guys have release the web designer which is really awesome.

however, we are still using VS designer to modified all the template. as far as I know, if we want to use web designer, we need to convert all templates to standalone template.

our currently project is rely on the report REST Service to get the report. we may want to switch away from the REST service or may be stay on it depends what is it offered in web designer.

So here are my questions:

1. What would be best solution for us from your perspective / expertise?

2. If we want to convert our old VS template to standalone template, how do we do it. We are using store procedure as Data source which means our old template is not parameterless (I think). What is the best way to convert them?

an example of how we import the data right now is attached in the file.

 

 

Recent update, I have managed to convert the file from our class object to trdx format. I am thinking to store it inside our DB so that we can call this format from an RESP API endpoint and present it to the html designer.

However, this template has alot funtions. not sure how would I called those functions if I am trying to access the template from a standalone designer or a html designer.

new xml file is attached.

Bob
Top achievements
Rank 1
Iron
Iron
Iron
 updated answer on 30 Jun 2024
1 answer
322 views

Hi 

we include Telerik Reporting v.6.2.12 in our System. This System will be exported (from Italy). Is Telerik Reporting subject to dual use EU or US legislation? Has it an ECCN (Export Control Classification Number) code associated?

thanks in advance for your kind reply

Daniele Perucchini

Dimitar
Telerik team
 answered on 27 Jun 2024
1 answer
201 views

Edit: 6/26/2024 11AM

My apologies, I should have been more specific and added some context through code snippets.

We use this version the HTML5 ASP.NET Web Forms Report Viewer

https://docs.telerik.com/reporting/embedding-reports/display-reports-in-applications/web-application/html5-asp.net-web-forms-report-viewer/overview

Also we initialized it like so

                <telerikReporting:ReportViewer ID="rvStandard" Visible="false"
                    Height="750px" ParametersAreaVisible="false" EnableViewState="false" runat="server">
                    <ClientEvents RenderingBegin="rvStandard_RenderingBegin" Error="Report_ClientError" />
                </telerikReporting:ReportViewer>

This resulted in the unusual behavior with newest version 18.1.24.514.

Moving the initialization to like this with PersistSession set to false resolved the weird issue even though we hadn't set PersistSession at all.

                <telerikReporting:ReportViewer ID="rvStandard" PersistSession="false" Visible="false"
                    Height="750px" ParametersAreaVisible="false" EnableViewState="false" runat="server">
                    <ClientEvents RenderingBegin="rvStandard_RenderingBegin" Error="Report_ClientError" />
                </telerikReporting:ReportViewer>

To set the report to be viewed we do that in the code behind of the .aspx page. This occurs after the user has clicked a desired report. This click of what report they desire to view triggers a PostBack to the aspx page which then runs this code below to do some final configuring on the ReportSource.

rvStandard.Visible = true;
rvStandard.AuthenticationToken = IWT.Sped.Encryption.WebApiEncryption.EncryptTextAsBase64( Cast.ToString( SessionManager.CurrentUser.ID ) );
ReportSource rptSource = new ReportSource( );
rptSource.IdentifierType = IdentifierType.TypeReportSource;
var reportSourceParams = new Telerik.ReportViewer.Html5.WebForms.Parameter[]
{ /* your report params here*/};
rptSource.Identifier = "IWT.Sped.Reporting.rptCaseLoadDetail, Reporting, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null";
rptSource.Parameters.AddRange( reportSourceParams );
rvStandard.ReportSource = rptSource;


Hello there,

We have been using Telerik Reporting successfully for many years and have never had a single issue upgrading to the newest version until upgrading to 18.1.24.514.

We were getting the behavior of our ReportViewer getting locked/stuck to the first report being ran. We programmatically set the report in the code behind of our .aspx pages and trigger the ReportViewer to update with the new report and parameters.

After some head banging against the wall, we resolved the issue by setting the PersistSession setting on the ReportViewer to false. To be clear we did not have the PersistSession set to true, it was not configured at all. What is confusing is according to the documentation this value is set to false by default.

https://docs.telerik.com/reporting/embedding-reports/display-reports-in-applications/web-application/html5-report-viewer/api-reference/report-viewer-initialization

Could you please update the documentation or double check that PersistSession is not set to true in the newest version of Telerik Reporting 18.1.24.514 ?

 

Thomas
Top achievements
Rank 1
 updated question on 26 Jun 2024
1 answer
183 views

Hello, 
I'm creating a multi-column report that's printing Across Then Down. I used the Multi-Column Example to get started. And it works perfect. Now I need to use the same data source for fields in my Report Header and Footer. When I assign the same Data source from the List to the report the list is duplicated for ever record in the data. When I remove the List Data Source and try to do a binding expression on the List (Property Path=DataSource Expression=ReportItem.DataObject) the List no longer does multi-column, and is just a single column. I also tried using the PageExec() function to try and access the List scope and  Details scope to get the data that way, but was unsuccessful. 

Due to an external integration, I can only use a single data source as the external tooling replaces all the Data sources with something it configures and inserts into the report XML. 

So how can I achieve this? 

Sample data out of the database is attached. 

 

Thanks

 

1 answer
724 views

We are unable to use the report builder in visual studio for a .net 8 core project

If we use the standalone builder, we can not find out how to load the data from class / model.

We were expecting the external to be able to point to the build / dll and select the appropiate view model

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 24 Jun 2024
1 answer
144 views

Hello everyone,

I have an issue with visibel paremter.
To be precise I have to show different texts based on the users language.
The basic process looks like this:

Client sets language parameter -> Telerik language paremeter -> SQL selects language label based on language parameter -> Result set in language label value -> language label value set in visible report parameter text

I cannot implement the language labels into the select of the report. Therefor the multilangual labels have an own query. This ml query is set into the language label parameter.

The additional step setting the result of the SQL in the language label value is necessary as the visible parameter already has an SQL source.

Follwing steps i tried:
set the sql query for the language label (Label Text parameter.txt)
set the text value of the target to the value of the parameter mentioned above (Visible Parameter.png)
use the sql query with hardcoded language as a test (SQL hardcoded language.png)
This works fine (Result hardcoded language.png)

Changing sql to language parameter (Select with parameter.png)
SQL gets a result (Result check sql with parameter.png)
Does not work in runtime (Result SQL with parameter.png)

Changing SQL to get every text label and filter in the parameter. (SQL get all labels.png)
Testing the idea, hardcode language filter in parameter (Parameter Filter.png)
Check result works (result hardcoded filter.png)

Changing to filter with parameter (Filter with parameter.png)
Result does not work (Result filter with parameter.png)

So the problem only exists if I use a parameter. Which is unavoidable as I need the language from the active user.

I know that I could hardcode it into the parameter.text with an IIF expression.
I would have to do this for every language and every label and I´d like to avoid that.

Is there any possibility to put result of an SQL query into the parameter.text when the target parmeter already has a different query and is set visibile?

1 answer
188 views
I generate reports through Telerik Reporting, the reports are displayed correctly in the system, but when switching to the browser's print window (in all browsers), the report is displayed followed by an unnecessary blank page, for example: if the report displays 3 pages, 4 pages are displayed with the last page being blank

Looking for a quick solution because it is very disturbing
Ivan Hristov
Telerik team
 answered on 21 Jun 2024
0 answers
141 views

Hello, Im facing a problem with c# telerik report designer.  We have specified report and all columns were looking good until we add one more "Comments". So major view looks ok but all childs have moved rows into right side without any reason and column are not aligned to its parent. How to align this? picture in attachment.

1 answer
143 views

Let’s say we have the data below.

How could I put this into a table and it show only the items in each Pet/Grouping per page.    

For example:

Page 1

Page 2

Page 3

I tried making a group header for Pet, with a child of Grouping and then putting a page break at the bottom of the Grouping group but that didn’t work.  I always get the result at the bottom here.

What am I missing?

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 18 Jun 2024
0 answers
221 views

Hello

I'm using the WebDataSource component from Web Report Designer, and I want to receive data from our REST API. 

On endpoints with no auth it works fine and the data gets loaded. But when I try to use 2-step auth (get token and pass it to api), I get a popup from web data source Wizard:

Error

Could not get preview.. An error has occurred. Object reference not set to an instance of an object.

 

And the debugger shows this:

WebDesigner Warning: 0 : Newtonsoft.Json.JsonReaderException: Error reading JObject from JsonReader. Path '', line 0, position 0.
   at Newtonsoft.Json.Linq.JObject.Load(JsonReader reader, JsonLoadSettings settings)
   at Newtonsoft.Json.Linq.JObject.Parse(String json, JsonLoadSettings settings)
   at Telerik.Reporting.Processing.WebServiceDataSource.ErrorParsers.ErrorManager.ParseJson(String responseContent)
WebDesigner Error: 0 : Object reference not set to an instance of an object.
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.SendCore(IWebServiceRequestSettings settings, AuthenticationHeaderValue authHeader, HttpClient httpClient, HttpClientHandler httpClientHandler)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.GetTwoStepAuthorizationHeader(WebServiceTwoStepAuthentication processedAuth)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.Request(WebServiceDataSource processedDS)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider.GetRemoteRawData(WebServiceDataSource processedDS)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider.get_RawData()
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceSchemaAdapter.AddDataMeasures(SimpleDataModel model)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.GetSchemaCore()
   at Telerik.Reporting.Processing.Data.DataProvider`1.Telerik.Reporting.Processing.Data.IDataProvider.GetSchema()
   at Telerik.WebReportDesigner.Services.ConnectionsService.GetDataModel(DataSourceInfo dsi)
WebDesigner Error: 0 : Object reference not set to an instance of an object.
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.SendCore(IWebServiceRequestSettings settings, AuthenticationHeaderValue authHeader, HttpClient httpClient, HttpClientHandler httpClientHandler)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.GetTwoStepAuthorizationHeader(WebServiceTwoStepAuthentication processedAuth)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceClient.Request(WebServiceDataSource processedDS)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider.GetRemoteRawData(WebServiceDataSource processedDS)
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceDataProvider.get_RawData()
   at Telerik.Reporting.Processing.WebServiceDataSource.WebServiceSchemaAdapter.AddDataMeasures(SimpleDataModel model)
   at Telerik.Reporting.Processing.Data.SimpleDataProvider`1.GetSchemaCore()
   at Telerik.Reporting.Processing.Data.DataProvider`1.Telerik.Reporting.Processing.Data.IDataProvider.GetSchema()
   at Telerik.WebReportDesigner.Services.ConnectionsService.GetDataModel(DataSourceInfo dsi)

Auth URL is `https://localhost:5001/api/Account/Token2` and it should return plain text string with the token.

Request body is

{
  "login": "admin",
  "password": "foobar"
}

I click next-next in the Wizard and on the last step get the error above.

Why does not it work ??

Dmitry
Top achievements
Rank 1
 asked on 17 Jun 2024
Top users last month
Tien
Top achievements
Rank 1
Iron
Krasimir
Top achievements
Rank 3
Bronze
Iron
Iron
Cedar
Top achievements
Rank 1
Iron
Emil
Top achievements
Rank 1
Iron
Kyle Watson
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?