Aaron,
I read a couple of the BAQ postings about replacing some report
builder reports with BAQ's. I made a simple one using
OrderHead.OrderNum, OrderDtl.OrderLine, OrderDtl.PartNum,
OrderDtl.SellQty, and OrderDtl.UnitPrice. I ran the query and had
many lines (up to 40+ lines) for each order number since we add
releases and changed release quantities over time. This file ended up
being over 3500 lines when exported to Excel. I then made a Crystal
report of the same information and had only 600 lines (I did not
select "Hide Duplicates"). Using BAQ, how do I hide duplicate fields
or display only the last entry in the database?
Thanks again for your help.
John Deligdisch
Axiomatic Technologies Corp.
I read a couple of the BAQ postings about replacing some report
builder reports with BAQ's. I made a simple one using
OrderHead.OrderNum, OrderDtl.OrderLine, OrderDtl.PartNum,
OrderDtl.SellQty, and OrderDtl.UnitPrice. I ran the query and had
many lines (up to 40+ lines) for each order number since we add
releases and changed release quantities over time. This file ended up
being over 3500 lines when exported to Excel. I then made a Crystal
report of the same information and had only 600 lines (I did not
select "Hide Duplicates"). Using BAQ, how do I hide duplicate fields
or display only the last entry in the database?
Thanks again for your help.
John Deligdisch
Axiomatic Technologies Corp.
--- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> John,
> You still can't total in BAQ.
> That being said. In 6.1 in the menu that you select Run, there is a
> Generate ASP choice. You have to export the initial query to XML
(can
> be set to do so automatically using a process server) and you will
have
> to do this to an IIS web (XP has one built in that can just be
> installed). The ASP file is a web page interface that lets you
easily
> sort, filter and display the data in the xml export. If you have
office
> 2002 or above, right clicking on the grid in the ASP lets you
export it
> to excel filtered and sorted.
> Some of the uses that I am using are:
> Displaying on a web page the active labor transactions. This gives
> production a up to the minute, who is on what machine doing what on
what
> job.
> I have exported all shipment lines with SO pricing to yearly XML
files
> with a web page for each year. Sales is using this and excel to
find
> best customers, best selling products and who buys specific parts.
> I also have a BAQ to export current Backlog so our Sales Admins can
> review their open orders and keep track of anything overdue,
allowing
> them to be proactive in dealing with unhappy customers.
> Just some thoughts.
> Aaron Hoyt
> Hittite Microwave
>
> -----Original Message-----
> From: johndeligdisch [mailto:johndeligdisch@y...]
> Sent: Thursday, May 27, 2004 8:34 AM
> To: vantage@yahoogroups.com
> Subject: [SPAM] - [Vantage] Re: BAQ and ASP pages - Email found in
> subject
>
>
> I'm new to BAQ and programming. I have developed some BAQ's to
list
> table contents with some filtering, sorting, and minor formula's.
> However, what complexity of formulas are available using BAQ? Two
> needs that I have are for a Query listing previous weeks sales
totals
> and previous weeks # of sales order lines. Where do I declare
> variables for totals columns?
> Secondly, what is the ASP page and would you use it for?
> Thanks for any help.
> John
> --- In vantage@yahoogroups.com, "Aaron Hoyt" <hoyt@h...> wrote:
> > With some help from a list member off line, I was able to learn
some
> > vital keys that makes this work.
> > 1. Find the two files filterdata.xsl and exports.css in the
Vantage
> > directory (mine were in the UD folder)
> > 2. Copy them to the web where your ASP pages reside.
> > 3. If you use formulas to generate numbers inside a BAQ, you
will
> need
> > to edit the (filename).xsl file to use a ###,###....format
instead
> of
> > the x(30) format (notepad works great for this).
> > Other than that, this is very useful.
> > I am finding you can generate basic reports that everyone can use
to
> > slice the data the way they want with filters and sorting. If
you
> have
> > office XP or above, you can rightclick on the grid that is
> generated in
> > Explorer and export it to excel, filtered and sorted. If you are
> > dealing with static data (last years shipments for example), you
> can run
> > the query once and then users can slice and dice as they like.
If
> the
> > data is dynamic, you can turn on the BAQ Process server and have
> this
> > refresh the queries at preset intervals.
> > And the top three reasons I like this:
> > 3. Users don't have to know Report Builder to filter and sort.
> > 2. No Vantage license is used to look at the data (not even
ODBC).
> > 1. It's Vantage 8 (Sonoma code name is being dropped) compatible.
> > So, for anyone that was stressing out about the death of Report
> Builder,
> > I highly encourage you to check out the Business Activity Query in
> > Vantage 6.1.
> >
> > Aaron Hoyt
> > Hittite Microwave
> >
> >
> > -----Original Message-----
> > From: Aaron Hoyt
> > Sent: Thursday, May 20, 2004 10:13 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ and ASP pages
> >
> >
> > Is anyone else out there using the Business Activity Query to
> Generate
> > XML files and ASP pages to access them?
> > I have been trying to get this functionality to work as a side
> project
> > for the last few days. I can get the XML to generate (in fact
the
> new
> > process server for automatically generating the XML files is
slick).
> > The ASP file seems to have some rather large faults though. With
a
> > little self taught ASP programming I have managed to get the ASP
to
> > display and sort the data as it should. My major problem is that
it
> > does not filter the data. Is it just me, or are there others
having
> > this problem?
> > I appreciate any response related to this.
> > Thank you all,
> >
> >
> > Aaron Hoyt
> >
> > Hittite Microwave Corporation
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must
> > have already linked your email address to a yahoo id to enable
> access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> Builder
> > and Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/links
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > ADVERTISEMENT
> >
> >
>
<http://rd.yahoo.com/SIG=1298mthfs/M=295196.4901138.6071305.3001176/D=
> gr
> >
>
oups/S=1705007183:HM/EXP=1085148940/A=2128215/R=0/SIG=10se96mf6/*http:
> //
> > companion.yahoo.com> click here
> >
> > <http://us.adserver.yahoo.com/l?
> M=295196.4901138.6071305.3001176/D=group
> > s/S=:HM/A=2128215/rand=447076079>
> >
> >
> > _____
> >
> > Yahoo! Groups Links
> >
> >
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> >
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> > <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> >
> >
>
**********************************************************************
> **********************************************
> >
> > This e-mail and any files transmitted with it are confidential
and
> intended solely for the use of the individual
> > or entity to which they are addressed. If you have received this
e-
> mail in error please notify the system manager.
> >
> > This e-mail message has been swept for the presence of computer
> viruses.
> >
> > WARNING: All e-mail sent to this address will be received by the
> HMC network and is subject to archival and review
> > by someone other than the recipient.
> >
> >
>
**********************************************************************
> **********************************************
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
>
>
> Yahoo! Groups Sponsor
>
> ADVERTISEMENT
>
>
<http://rd.yahoo.com/SIG=1298e9qt9/M=295196.4901138.6071305.3001176/D=
gr
>
oups/S=1705007183:HM/EXP=1085747626/A=2128215/R=0/SIG=10se96mf6/*http:
//
> companion.yahoo.com> click here
>
> <http://us.adserver.yahoo.com/l?
M=295196.4901138.6071305.3001176/D=group
> s/S=:HM/A=2128215/rand=340695659>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
>
>
**********************************************************************
**********************************************
>
> This e-mail and any files transmitted with it are confidential and
intended solely for the use of the individual
> or entity to which they are addressed. If you have received this e-
mail in error please notify the system manager.
>
> This e-mail message has been swept for the presence of computer
viruses.
>
> WARNING: All e-mail sent to this address will be received by the
HMC network and is subject to archival and review
> by someone other than the recipient.
>
>
**********************************************************************
**********************************************
>
>
>
>
>
> [Non-text portions of this message have been removed]