Todd - Much has changed since '06. You will find a wealth of information here on this forum on the use of BAQ's, the BAQ Report Designer, and Crystal Reports. It isn't a perfect toolset and does have it's quirks but I think that you will find that you can satisfy the vast majority of your reporting needs through the use of this toolset.
Good luck,
Dale.
Good luck,
Dale.
--- In vantage@yahoogroups.com, "mahsangilbert" <tgilbert@...> wrote:
>
> I have been away from the Users Group since early 2006 but as of today find myself back in a Vantage company. We are on version 6.1 and will be migrating to the latest version sometime in Q1 2011 (this was part of the reason I was hired).
>
> I'd like to hear any suggestions on the best options for writing SQL-intense reports against the database, both for 6.1 and the latest version. In the past, I split my reports between the following (each of which have issues):
> -Report Builder
> -Crystal Reports (via ODBC connection)
> -MS Access (via ODBC or exported data tables)
>
> I hope like heck that the latest version has addressed the need for manually creating SQL reports (without being restricted to predefined table relationships) that do not slow down the system significantly. If anything like this is available for 6.1, I'd also love to know about it.
>
> Any input is welcomed and appreciated.
>
>
> Glad to be back,
>
> Todd Gilbert
> GCM Mfg, Inc.
>