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"
}

Hi,

I'm fairly new to Report Server, but am promoting its purchase in-house.

I have gotten the question about whether it's possible to extend the available component respository thru the RS API. E.g. a custom pie chart diagram.

I've searched wide and deep, but haven't so far found any mention of such a functionality.

Is this possible thru some .Net assembly using the API, being made available thru the Report Designer ?

Cheers.

Web preview not working.

Only got Header of the web where come with the Telerik Report Server Logo only.

We are currently testing Report Server to generate reports with an OpenEdge RDBS.

So far, we've managed to connect via the OpenClient DataSource, upload the report to the Report Server and run it.

https://docs.telerik.com/reporting/openclientdatasource

Now we'd like to try it in another environment (let's say PROD vs DEV), so we need to change the data source to switch environment.

Do we need to edit the report per environment ? or is there another way ? 

In the following blog post, you answer this question, but it seems you cannot create an alias for an OpenClient DataSource.

https://www.telerik.com/blogs/your-report-server-questions-answered

> Q: Can you update a reports data source in Report Server? Example when in DEV we use a Demo Database.
> A: You can design your report to use named connections. Then you can have different definitions for the connection string of this named connection on each computer the report is being tested on.

The Admin page of the report server does not allow to create an alias for an OpenClient ConnectionString.

Regards,

Christophe