I'm using Telerik Report Server to manage reporting system for different clients. I have one Main category and I created one report in it. This report has two different data sources(DS1 and DS2), which are populating exactly the same data, but from two different data connections(DC1 and DC2) created on the Telerik Report Server.

DS1 is using DC1 and DS2 is using DC2. These two data connections are created for two different databses/instances.

I also created two users(U1 and U2) and gave them specific permissions.

For U1:Read reports in Main Category and Read Specific Data Connection: DC1

For U2:Read reports in Main Category and Read Specific Data Connection: DC2

When I run the report with U2, I'm seeing data populated from DS1.

Why I'm seeing data with user that don't have access to this particular data connection? How these permissions work? 

Is there a way to handle this situation in Telerik Report Designer or Telerik Report Server, using one report instead of two?

Hello, I'm testing the trial version of telerik report server. However, I have a problem ... after generating a report in telerik report design R2 2018, I can not see it in the report server. It always generates the following error:

"Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named
connection string from the application configuration file, make sure the name is correct and the connection string settings are present
in the configuration file of your application.
------------- InnerException -------------
Format of the initialization string does not conform to specification starting at index 0."

I configured web.config to use my database connection (Oracle), and in my report (in the format ".trdp") I configured the same connection.
Within report design, my report is working but in report server does work.

Can you help me?

Is it possible to change a report connection string based on user? We have several instances of a web application (each with their own database). We have multiple reports for this web application and would like to not have to deploy a new set to the report server for each instance. Instead, it would be nice if we could have the report select a connection string based on the user accessing the Telerik Report Server. Is this possible?

We previously had reports deployed with the standalone Telerik Report Viewer, and the reports used the connection string based on the web.config of the site. However, we changed to using Telerik Report Server to obtain the report subscription and data alerts features.

Is it possible to obtain a list of reports from the API?

Specifically, I need the list of reports (title, description, URL) that are available to the guest user.

Hi,

I've used SSRS in the past, and here it was simple to group together details data with a "group by" clause.

This is very different i TRS, and I'm stumbling on how to do it. Apparently "groups" in TRS is all about showing things grouped, not about aggregating.

I have a database view that offers all details, and I have a single report parameter to filter the view (based on a single comparison).

I want to group together the details rows based on 4 keys, having the rest of the fields being SUM()'d or aggregated by other aggregate functions.

How do I basically do that in TRS ? It's not very obvious.

I've tried using Crosstab's, but they just add one table for each original details row.

Cheers

Lars

Hello,

When I copy a report in the management website and then go to open it with the "Design Report" button I get the following error in Report Designer as soon as it loads:

"Error:

Archive file cannot be size 0.

System.IO.FileFormatException: Archive file cannot be size 0.
   at MS.Internal.IO.Zip.ZipArchive.OpenOnStream(Stream stream, FileMode mode, FileAccess access, Boolean streaming)
   at System.IO.Packaging.ZipPackage..ctor(Stream s, FileMode mode, FileAccess access, Boolean streaming)
   at System.IO.Packaging.Package.Open(Stream stream, FileMode packageMode, FileAccess packageAccess, Boolean streaming)
   at Telerik.Reporting.Utils.ZipFile.Open(Stream stream)
   at Telerik.Reporting.Utils.ZipResourceHandler.LoadResources(Stream stream)
   at Telerik.Reporting.ReportPackager.UnpackageDocument(Stream packageStream)
   at Telerik.ReportDesigner.Packages.ReportDesigner.Serialization.ReportDocumentDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager)"

I am using Version: 4.0.18.227. Any thoughts? I have tested with several different reports with the same result.

Thank you - Scott

Dear Telerik,

I just installed Reporting Server locally and I have ensured the setup was correct:

• Database is good
• Windows service is up and running

When I try to save the configuration for SMTP setup, I get an error:

An error occurred while saving the settings: Telerik Report Server Service Agent is not running. Please, check the Windows service. The changes were not applied!

I'm not able to understand if the Report Server is doing some validation on the SMTP settings that I provide. The error is generic and doesn't specify what went wrong. Same settings are working for SSRS and another famous Suite.

Setup: https://1drv.ms/u/s!AniVX60enXnSu4FQLitndH8H_Ekybw

We are using Report Server to generate quite large report sets (up to 6000 pages, or 10Mb excel files).

Because of this, we adopted the Report Server solution instead of a client side report architecture, facilitating processing of these large data sets.

Our server has 32Gb of RAM and is used exclusively as a report server.

The stored procedures to retrieve the data in question executes in around 25 seconds.

Telerik Report Server will, however, still often fail with an out of memory exception.

What concerns me is that the amount of data we use is nowhere near 32Gb in size.

Currently, there is also only one or two users on the server at any point in time.

The out of memory exception is also inconsistent: Sometimes these reports will run fine, other times the memory exception crops up, resutling in an extremely inconsistent server experience.

What happens when 1000 users in the production environment tries to run the reports and the server actually has to behave like a server?

Did we make a mistake adopting Telerik Report Server instead of Microsoft Report Server?

Are we missing something?

If I try to set the RecurrenceRule through the API, the rule is created, but the email is never sent.

This is an example of the JSON

{
"Name": "8",
"Enabled": true,
"ReportId": "155724-8c3f",
"DocumentFormat": "PDF",
"StartDate": "2018-01-24T18:10:00",
"RecurrenceRule": "FREQ=Daily;COUNT=0",
"Parameters": {},
"MailSubject": "Telerik Report Server - Task Scheduler notification",
"MailBody": "foo",
"ExternalEmails": [
],
"SubscriberIds": [
"a56e2f86500b4ae0953f925e6c047fad"
],
"UserId": "a56e2f86500b4ae0953f925e6c047fad"
}