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!
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 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.
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.
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:
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: 184.108.40.206. Any thoughts? I have tested with several different reports with the same result.
Thank you - Scott
I just installed Reporting Server locally and I have ensured the setup was correct:
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.