ReportViewer remote data

1

Good morning.

I have a problem with the reports (.RDLC) of my project (ASP.Net MVC), it turns out that I just uploaded it to Azure (App Service).

I was working with a local database, which did not have credentials (username, password), with Windows authentication.

Now I am using a remote database, the reports (.RDLC) do not work, with the application that I use to design the reports, I update the datasource, but I guess that the credentials are not being saved, this is the chain of connection.

<ConnectionProperties>
  <DataProvider>SQL</DataProvider>
  <ConnectString>Data Source=miservidor;Initial Catalog=DataBase</ConnectString>
</ConnectionProperties>

In the preview that the design application gives me (already updated with the remote bd), if it works, but when I run the application, no data is output.

    
asked by Norcarde 12.03.2017 в 16:25
source

1 answer

0

Here is the solution:

<ConnectionProperties> 
    <DataProvider>SQL</DataProvider> 
    <ConnectString>Data Source=mvc.syncfusion.com;Initial Catalog=AdventureWorks;User ID=ssrs1;Password=RDLReport1</ConnectString> 
</ConnectionProperties> 
    
answered by 15.03.2017 / 16:19
source