Using a .NET Data Provider extension for Paginated Reports and Report Builder

Thanks for the suggestion. I tried it out. It is not ideal because I am going to use a PostgreSQL .NET Data Provider on the Report Server as I need to create data sources for multiple databases. 

• First, I do not have access to the OS of the Report Server to configure an ODBC In addition, I cannot have a single ODBC data source configured as I plan to use multiple database connections. This is why I am using the .NET provider data source, which allows me to create and configure the connection string within the Report Server data sources as I please. The PostgreSQL .NET prodiver works fine on the server.
• I can configure an ODBC on my workstation just to get by for building reports. However, this method "sort of works" and requires flip-flopping to be able to develop and test the report. For example, I configure a report with an embedded PostgreSQL ODBC data source, allowing me to query the data base and populate fields for report objects. This works from my workstation. However, in order to test run the report, I have to switch it back to the shared data source on the server since that is the only way for the server to connect to the database.

If this is the only way to connect to PostgreSQL from Microsoft Report Builder, then it is what it is. If there is a way I can add an extension for a .NET data provider to Report Builder, that would solve all my troubles :).

I did look more into Visual Studio. So I realized that I needed to install the "Microsoft Reporting Services Project" VS Extension to get the RSReportDesigner.config file (SSDT alone was not enough). I added an extension to that for the PostgreSQL .NET Data Provider and it works within Visual Studio (does nothing for Report Builder). Was able to connect to PostgreSQL and populate fields. However, VS does not seem so great for building reports in comparison to Report Builder, but maybe I am just not finding my way around the extension. For one, I don't see any way to connect to a report server and can only develop reports locally. That is sort of ok as I can always upload the file. Second, I am not finding all the same tools as Report Builder. For example, how do I had a graph object? If I can work in VS exactly the same way as Report Builder (connect to Report Server and access all report objects), then I will be fine with using that as it works with the .NET data provider.