Vantage Newbie: Sales rep code from OrderHed.SalesRepList and BA

Yahoo Archive
1
I have not been able to get that working at the BAQ level. You can't filter
on a calculated filter from a Quick Search either...that I know of.

If the output result is a report you can filter it in Crystal.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bjcracosta
Sent: Tuesday, December 30, 2008 5:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Newbie: Sales rep code from OrderHed.SalesRepList
and BAQ Report sorting

Okay, I've searched the message archive and learned how to parse the
sales rep codes out of OrderHed.SalesRepList into individual
calculated fields in BAQ. However, the calculated fields aren't in the
'Sort Order' tab 'Available Columns' and can't be selected to sort by.
Nor are they available as sort fields in the BAQ Report Designer Sort
Options tab. Is it possible to get a report sorted by the sales rep
codes? If so, how?

We're on Vantage v8.03.406A.

Thanks,
Reggie


------------------------------------

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/linksYahoo! Groups Links
2
Okay, I've searched the message archive and learned how to parse the
sales rep codes out of OrderHed.SalesRepList into individual
calculated fields in BAQ. However, the calculated fields aren't in the
'Sort Order' tab 'Available Columns' and can't be selected to sort by.
Nor are they available as sort fields in the BAQ Report Designer Sort
Options tab. Is it possible to get a report sorted by the sales rep
codes? If so, how?

We're on Vantage v8.03.406A.

Thanks,
Reggie