Hi all.

I've created a report with a number of multi-value parameters. This works just fine in the Report Designer preview. Image3

I then published it to our report server, andright off it seems to work (all parameters select all distinct values) Image1

But if I select a subset of certain values for one of the parameters, the report server viewer fails with system error message: "Missing or invalid parameter value" Image2

It varies which combination exhibit this behaviour.

Please advise.

/Lars

Hello,

I have created a report in Report Designer (Stand Alone) and saved it on the Report Server.
The data is fetched from a database via ODBC drivers.

For this I have a connection string stored on the Report Server, which is used in the report as a data connection.

The report should be usable by different clients.
Each client has its own database (with the same structure).

For each client, a data connection is then stored on the server.

The report should be displayed in the HTML5 report viewer, which should be integrated into our web application.

Is there any way to specify the data connection to be used when calling the report via the API?
e.g .:
Client A calls the report. -> The data connection X is used.
Client B calls the report. -> The data connection Y is used.
Etc.

Hi Telerik/Progress/?

After having purchased and used Telerik Reportserver for almost a year now, we've come across multiple problematic designs in TRS.

 

The worst issue was our attempt to delete the built-in "Guest" account (via REST, tidying up unnecessary users), which resulted in its user name being wiped, and it being reactivated (was deactivated).

This result crashed the server software repeatedly, and we had to reinstall a backup of the server database to fix it. Why is it even possible to make changes to a built-in account, that clearly is essential to the workings of TRS ?

 

Other grievances include:

- The inability to delete users in the web interface.

- The very limited dropdown width for reports, showing only a small part of the names, when we use long category and report names.

- Missing sensible sorting of various lists, rendering them very troublesome to navigate.

- The inability to exclude certain reports from sharing (via the Guest account), forcing us to instead add a lot of reports on the account's permissions (90%/10% problem).

- The locking of server reports after publishing a report from the stand-alone Designer, always requiring the Designer to be shut down and restarted to release the lock.

 

Cheers

Lars

Is it possible to pass a parameter to report server in the URL?

I'm just getting started with Report Server and have an overall strategy/approach question. The database containing our report data is a SQL Server 2017 database that uses a schema-per-tenant design. My question is, is there anybody else out there querying their report database in such a manner from Telerik reports? What I want to avoid, is creating a data source for every schema that exists in our database. Schemas are added weekly, every time we setup a new customer. I don't want to have to create a new data source for every report every time we add a new customer.

Any input or advice is welcome!

Hi Guys - I need to be able to log a user straight into the report server after authenticating with the api either in .NET or javascript and retrieving the token via the api (http://localhost:83/Token) instead of showing the login boxes.  

This is a requirement because we use our own authentication mechanism in our web apps and once the user has successfully logged into our app using our authentication methods we do not want them to have to provide any further 'log in details' on the report server - Can you advise how to achieve this.  I think the steps involved may be as follows:

1) user logs into our web app using there own credentials for our business.

2) use the report server API to authenticate and get the token back for an admin account set up by us on report server.

3) after successfully getting the token back, redirect the user to report server from .NET web app using a special account we set up without the requirement for them to log into report server again.

I know there is ADFS available in Telerik report server, however our domain servers are 2003 and do not support the ADFS feature offered by report server - which is why I am looking for an alternative approach.

Hope that makes sense, thanks for your help.:)

 

Anthony J Brown.

I'm creating a intranet site in .net core 2.1

 need to send a report in an email

How can I get a report as PDF and send is as an attachment via email

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.