Telerik Forums
Report Server Forum
3 answers
10 views

I am new to the product and trying to overcome basic hurdle - connect to DB from within Report Designer

Sorry if it was discussed already but I only can find very old threads on the subject and one of the videos on the steps is using Adobe Flash which is dead now.
Any help is appreciated

===

Maria DB 10.4 is installed on the same machine as Report Server
ODBC Drivers both 32 and 64 deployed to both server and my desktop machine

Telerik Data Direct is not being used as it does not have support of Maria DB, only mySQL.
I have tested ODBC access both remote and on the server from ODBC Manager and it is working
Data Connection "my-server" is added on Report Server and looks like this

DRIVER={MariaDB ODBC 3.1
Driver};TCPIP=1;SERVER=server-name;UID=*********;PWD=********;DATABASE=******;PORT=3309;OPTIONS=4194384;

it is unfortunate that there is no action on the portal to test it from UI, but may be it is done automatically, hard to say

When in Report Designer using SQL Data Source I can see existing data connection listed as "server:/http://server-name:83/my-server" but when I try to execute simple select statement (ex: select * from my_table; ) in next step I am getting

"An error has occurred. Parameter information cannot be retrieved: The query parameters cannot be obtained...."

followed by empty screens and more errors.

In documentation there is a reference to https://docs.telerik.com/reporting/sqldatasource but content is convoluted to read and figure out what is missing.

are there additional steps which need to be taken for Report Server to work out of the box?

Todor
Telerik team
 answered on 20 Apr 2021
6 answers
33 views

Hello,

     Does Report Server support a PostgreSQL data connection for reports?  I do not see it in my dropdown for my free trial version of 6.0.20.219.

Thank you.

Neli
Telerik team
 answered on 15 Apr 2021
9 answers
24 views

Hello,

  We have a number of reports configured to show sales data from last week, last month, last quarter, etc. The date parameters all work off of a CurrentDate = Now() expression, and extrapolate from there for the different time periods required (AddDays, AddMonths, etc). All of these work perfectly when used on-demand. However, if I set up a subscription/scheduled report, the date parameters don't seem to get refreshed. I made sure that the CurrentDate parameter was ordered as the first parameter to be run, but that didn't seem to make a difference. The report runs on the scheduled date and time, but the data that it's returning is not relevant.  Is there any way to make sure that those date parameters get refreshed before the scheduled report runs?

Thanks

Travis

Todor
Telerik team
 answered on 25 Mar 2021
1 answer
8 views

Hi,

I have wrongly setup the report server (trial version) storage type as File when it should be Microsoft SQL Server. Now I'm stuck at the login page with login error : The required anti-forgery cookie "__RequestVerificationToken" is not present

How do I change the storage type for the report server?

Thank you.

Nasko
Telerik team
 answered on 17 Jul 2020
4 answers
144 views

Dear support team,
I'm using Report server (Version: 6.0.20.219) to design and manage report.

After completed design report I follow this link "https://docs.telerik.com/reporting/html5-report-viewer-howto-use-it-with-reportserver" to  embed report into my ASP.NET Application.

I follow step by step is completed, but when I run that html report it show error:

"Error loading the report viewer's templates. (templateUrl = 'http://localhost:83/api/reports/resources/templates/telerikReportViewerTemplate-14.0.20.219.html/')."

I come in to Report Server installed folder "C:\Program Files (x86)\Progress\Telerik Report Server\Telerik.ReportServer.Web\ReportViewer" but I can't find the "templates" folder :(

Please help me the way to fix it.

 

Christian Sandöy
Top achievements
Rank 2
 answered on 01 Jul 2020
5 answers
191 views
I can't see any option to do so, and I can't find anything about it in the documentation.
Nasko
Telerik team
 answered on 15 May 2020
1 answer
12 views
Does anyone know when this will no longer be marked experimental (or did I miss a configuration step on the upgrade to R1 2020)?
Todor
Telerik team
 answered on 31 Mar 2020
8 answers
71 views

Is it possible to modify the loading message on a report? ("0 pages loaded so far...") I have two issues:

 

1) By default it loads with orange text/background regardless of the white labeling done in the configuration menu.

2) Some of our reports load slowly, and different text would be helpful to inform the user of such.

Joel
Top achievements
Rank 1
 answered on 25 Feb 2020
1 answer
13 views

Hello! I'm fairly new to Reporting and Report Server so I'm wondering if there are some tips on making a report I'm trying to generate run better. The desired result I'm looking for is to get a report in Excel that can be up to 150,000 lines. If I run the query in SSMS it takes about 2 seconds, but how I have it designed in the Report server it times out after 100(?) seconds. If I limit the range to ~80,000 records it can being it up, but takes about a minute to run and you can tell the browser is under a heavy load.

To create this report, I ran the Table Wizard and little else. I see that creates a table in the Details section of the report, which makes this many rows super tall (which is fine), but I'm wonder if there's a better practice for creating reports which are destined for Excel?

Neli
Telerik team
 answered on 11 Nov 2019
1 answer
6 views

When should i set Serveroperation (False)  ?

What are the advantages and disadvantages of it  

Tsvetomir
Telerik team
 answered on 30 Oct 2019