Microsoft Report Builder
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p><font size="+1"><font face="Optima">I am trying to configure
Microsoft Report Builder to run against a mainframe PostgreSQL
database. The ODBC connection tests as good and manually
entered SQL Select statements properly return data. The
problem is the Query Designer in the software doesn't support
the normal graphical display of available tables and fields
with PostgreSQL. All I find in Microsoft's documentation is
the statement some data sources don't support graphical tools
in Report Builder.</font></font></p>
<p><font size="+1"><font face="Optima">More than likely there are
better report generators than Microsoft's tool but our agency
is very fond of Microsoft solutions. Anyone know of a way to
get the graphical tools working in Report Builder? In the
alternative, is there an alternative Windows report generator
to try if Microsoft's software isn't repairable?</font></font><br>
</p>
</body>
</html>
On 2/11/22 22:22, Kim Foltz wrote:
I am trying to configure Microsoft Report Builder to run against a
mainframe PostgreSQL database. The ODBC connection tests as good and
manually entered SQL Select statements properly return data. The
problem is the Query Designer in the software doesn't support the
normal graphical display of available tables and fields with
PostgreSQL. All I find in Microsoft's documentation is the statement
some data sources don't support graphical tools in Report Builder.More than likely there are better report generators than Microsoft's
tool but our agency is very fond of Microsoft solutions. Anyone know
of a way to get the graphical tools working in Report Builder? In the
alternative, is there an alternative Windows report generator to try
if Microsoft's software isn't repairable?
Well, there is a fish to achieve just that:
The problem is that you will have to build PostgreSQL from source with
some specific hooks for Babelfish. On the other hand, this extension is
supported by AWS:
That means that it will continue to be developed and that you will not
waste all that effort.
Regards
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
I use Valentina Studio for some tasks.
https://www.valentina-db.com/ru/valentina-studio-overview
--
Regards, Dmitry!
сб, 12 февр. 2022 г. в 08:23, Kim Foltz <kafoltz@zohomail.com>:
Show quoted text
I am trying to configure Microsoft Report Builder to run against a
mainframe PostgreSQL database. The ODBC connection tests as good and
manually entered SQL Select statements properly return data. The problem is
the Query Designer in the software doesn't support the normal graphical
display of available tables and fields with PostgreSQL. All I find in
Microsoft's documentation is the statement some data sources don't support
graphical tools in Report Builder.More than likely there are better report generators than Microsoft's tool
but our agency is very fond of Microsoft solutions. Anyone know of a way to
get the graphical tools working in Report Builder? In the alternative, is
there an alternative Windows report generator to try if Microsoft's
software isn't repairable?