BAQ to Browse / Ultrar Grid (V 8.03)

Yahoo Archive
1
Sounds like you can just create a simple dashboard based on your BAQ to do this...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of c.krusen1
Sent: Tuesday, August 30, 2011 7:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ to Browse / Ultrar Grid (V 8.03)



My users have the need to create the occasional BAQ, and and have the results just listed on a grid. Basically to "browse" through the data, without having to create a Crystal Report to run and display the BAQ.

Has anyone made a custom form that allows a user to enter a BAQ ID, and then display the data on an grid? Something like the results table from the Test function on the BAQ Designer's Analyze tab. But with the ability to sort, group, running sums, etc...

Wouldn't need printing capabilities, just copying to the clipboard for pasting into Excel.

They do some Queries right from Excel using ODBC. But some tables aren't ODBC friendly (the PartTran in particular).

Thanks,

Calvin



[Non-text portions of this message have been removed]
2
My users have the need to create the occasional BAQ, and and have the results just listed on a grid. Basically to "browse" through the data, without having to create a Crystal Report to run and display the BAQ.

Has anyone made a custom form that allows a user to enter a BAQ ID, and then display the data on an grid? Something like the results table from the Test function on the BAQ Designer's Analyze tab. But with the ability to sort, group, running sums, etc...

Wouldn't need printing capabilities, just copying to the clipboard for pasting into Excel.

They do some Queries right from Excel using ODBC. But some tables aren't ODBC friendly (the PartTran in particular).

Thanks,

Calvin