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.

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.

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

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.

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:

Hi Team ,

I started using Telerik reporting , not sure how to use Cache mechanism , so telerik report should not connect production database every time instead cache data should be render ?

Tried few things like DatabaseCacheConfigurator.exe , but below error occurs .

Also any file cache mechanism available in Telerik Reporting ? , i can see all Cache mechanism are related to database like SQL Server , Postgre SQL , SQLLite etc....please help on this.

I have a html5 report viewer that loads a report book, of which is hidden, with a print button shown that issues the print command. Viewer is hidden as I just want a print button and this was the only approach to do that shows the print dialog.

Anyways, that report book contains two reports. First one is a sales report, the other are items part of that sale. It was to simulate a functionality that I ported over from a function in MS Access to as close as possible. The report loaded and printed fine.

However, it needs to be now changed. The reports need to be printed on two different sizes. The sales report is fine the current dimensions. However, the items need to be sent to a printer that prints on 4x6 cards.

The idea I came up with is have two report viewers and load the individual reports and have the printEnd client event of the sales report to trigger the print of the items report. However, that doesn't work as that looks to immediately trigger the print of the items report and skips printing sales.

My question would be is there a way to print the next report after the first report is printed?

Hi,

Because of the recent supply chain attack related to Polyfill.io, are there any new version of telerik-angular-report-viewer that has removed the reference to the polyfill.io that we can use in out Angular application. 

Please advise. 

Thanks

Vas

I have created a Report Book with two separate reports using Report Designer. The report book and the individual reports have been uploaded to the Telerik Report Server. When previewing each individual report on the Report Server, the report displays fine. However, when I try to preview the report book, I get the error "Unable to get report parameters. An error has occurred. 'Report1.trdp' report cannot be found."

Not sure what I need to do to get this working since both are working individually. Thank you for any help you can provide.