Telerik Forums
Reporting Forum
1 answer
156 views

I'm trying the query builder for the first time, trying to create a very simple query. IDItemMaster and ItemMasterID are the keys. I click on add new relationship but nothing pops up and when I click on edit on the blank relationship the relationship tab closes. 

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 02 Aug 2024
1 answer
217 views

We converted the .rpt file to .trdp file using Telerik Standalone Report Wizard. We have a header and the details consist of many sub reports. we need to display the values in the sub reports getting the data from different select queries. We are not sure about specifying the data source for each sub report. 

Need help on the below items

1) How to set the data source to main report? how to set the separate data source to each sub report?

2) When we tried to set the data source for one of the sub report, we are able to only invoke the fields of that data source in another sub report. But we are able to create a separate data source in common. Can you help us with this?

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 02 Aug 2024
0 answers
723 views

Have been making some changes and updates to an existing Blazor web assembly project, and I have most things fixed/resolved regarding the reporting.   However, I get the following when trying to actually display a report:

 

"The version of the Report Viewer '18.1.24.606' does not match the version of the Reporting REST Service '18.1.24.709'. Please make sure both are running same version"

 

The dependencies in the projects all show Telerik Packages with version 18.1.24.709... so clearly I am overlooking something.  Clean & Rebuild does not help -- what am I overlooking.

 

Thanks.

 

Thanks in advance.

 

 

 

Bob Nonnemann
Top achievements
Rank 1
 asked on 01 Aug 2024
1 answer
452 views

Trying to integrate the native blazor report view into my we app, but running into all kinds of issues...I have the Rest Api installed, and the reportviewer.  I keep getting      

 Failed to load resource: the server responded with a status of 404 (Not Found)
telerik-report-viewer:1 Uncaught (in promise) Report '%2FReports%2FSampleReport.trdp' cannot be resolved. 

 or         

Failed to load resource: net::ERR_CONNECTION_REFUSED
telerik-report-viewer:1 Uncaught (in promise) Invalid ClientId  

 

The documentation is horrible and I can't get a response from support...hope somebody has some experience with this.

 

Also, .net 8 web app in auto mode...

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 31 Jul 2024
1 answer
153 views

I have a program to Order a widget.  When they order widgets, they are allowed to pick and choose options for those widgets.

The options are stored as individual records in a SQL table like this:

ProductID      OptionID
     5                     6
     5                      13
     5                      101

So, I want my report to show the total list of options as checkboxes, when that value is present in the datasource.  Options not selected should be unselected checkboxes.

I'm guessing this will be a subreport, passing in my ProductID.  The result would be a datasource with three records.  How do i associate these records to trigger checkboxes on my report?

Thanks

I would like to avoid writing my SQL to include record fields for every possible value as the options will change and I'd have to re-write the SQL every time.

1 answer
185 views

This is VERY URGENT: a business database migration from SQL Server to PostgreSQL, due to happen this weekend, is dependant on it.  I'll ask the question in 2 parts:

1. We have a SQL Server database called TelerikReportingCache, containing tables tr_AppLock, tr_Object, tr_Set and tr_String, which is used by Telerik Reporting. I have been told that this database cannot exist on a PostgreSQL server. Can you confirm that this is correct, please?

2. We have been told to use a file for the cache instead of a database. However, we have many users, and the file gets locked, causing an error message in reports - see image in attached file. If we cannot use a file as a cache, then what other alternatives do we have?

 

Error Message Text: Error creating report instance (Report = 'ConnectReports. Finance.CustomerInvoiceSummary, ConnectReports"). An error has occurred. The process cannot access the file '\\172.21.23.75\Telerik ReportingCache\ConnectReports 16.0.22.225\Is\A\value.dat' because it is being used by another process.

 

Lance | Senior Manager - Technical Support
Telerik team
 updated answer on 22 Jul 2024
2 answers
444 views

My titled should be "Can I DECRYPT my connection string" - however, I cannot modify the title above.

In my .Net 8 appsettings.json config, I have these two connection strings:

"ConnectionStrings": {
  "MyReports.Properties.Settings.dev": "Data Source=Eng-Server;Initial Catalog=devsvr;Persist Security Info=True;User ID=myID;Password=myPass",
  "Encrypted.Properties.Settings.devEncr": "jjwerjwerjwerjwerjwerjwerjwejwerjwer=="
},

 

The first conn string works fine when Telerik Reporting resolves the DataSource connections at runtime, however if I try to use the Encrypted string - it does NOT work.

Can you point me to some documentation on how I can get it to work with encrypted connection strings ?

I know that the Report Config object is exposed at the ReportsController level, for example:

public class ReportsController : ReportsControllerBase
{

    public ReportsController(IReportServiceConfiguration reportServiceConfiguration, IConfiguration configuration)
        : base(reportServiceConfiguration)
    {
    }

}

 

however where would I decrypt my string ?

By the way, I also have a ClassLibrary with some custom code. I use that DLL in the standalone report designer to hook up a DataSourceObject for some custom methods I need to call. Would I possibly hook into the connect string, and decrypt it here ?

Thanks,

Bob

Dimitar
Telerik team
 updated answer on 22 Jul 2024
1 answer
203 views

I Have a requirement like to open the corresponding HTML5 report viewer dynamically by passing the report source based on the click of a hyperlink.

Example:

Hyperlink1

Hyperlink2.

On clicking the Hyperlink 1, I need to pass the report source dynamically to report viewer and open its corresponding report. Similarly, on clicking link2 and so on.

Kindly suggest me the approach to satisfy this requirement. Thanks in advance.

 

Dess | Tech Support Engineer, Principal
Telerik team
 answered on 18 Jul 2024
1 answer
276 views

When I add this extension to .Net 8, I get this compatibility error, since I'm incorporating it into my application.

This is the error shown in the extension, so I can't use its features;

The message is:
"Package 'Telerik.ReportViewer.Mvc 18.1.24.709' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8, .NETFramework,Version=v4.8.1' instead of the project target framework 'net8.0'. This package may not be fully compatible with your project."

See the image below:

Dimitar
Telerik team
 answered on 18 Jul 2024
1 answer
179 views
Hello team Telerik

I've implemented your web report designer in my angular application and now I want to ask that how can I provide data to It

Basically my main purpose is that I want my user to generate report with the data set I've provided in my application like if there is a return generated in my application and my user want to design report of that return how can I bind my data (in what format) in a way that when he open a web designer he gets that data automatically and then he design and export that report by himself 
Is this functionality is available in your web designer for angular or not? 
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?