Indeed I have used both as well. Wrote a BAQ that dumped all the data and duplicated rows; however I pulled just the data I needed in the main report; then I created a subreport and pulled that data into sub report;
A quote for saleskit and the sales kit components PartBin.On-hand quantities comes to mind as a report. I wouldn't advise creating a BAQ Report then create a sub-report to ODBC however. Epicor curriculum had that as an actual exercise for a RMA to Deliveries Comparison Report; and I actually rewrote it as a Dashboard Report
I created several dashboard reports that pulled in 6 or 7 queries; and created a report. Job Status Report is another Epicor Curriculum exercise that isn't demonstrated very well but is a good base.
I did have problems with subreports on Dashboard Reports; at what version I can't remember but they were broke, however, getting a login ID when a subreport was added to the Dashboard report? I cannot remember what version; but it doesn't happen at E9 now? And indeed the caveat of Dashboard Reports is you don't get the flexibility of the options, sorts or filters asyou do with BAQ Report Paramter table; but you can add an Advanced Search to a dashboard and utilize that for your options and filters. Also caveat of being careful how you publish and subscribe (if at all) at the dashboard level before you publish it out to the xml for the Crystal to read. Let the subreport to the publishing and subscribing....
Ann Fisher
A quote for saleskit and the sales kit components PartBin.On-hand quantities comes to mind as a report. I wouldn't advise creating a BAQ Report then create a sub-report to ODBC however. Epicor curriculum had that as an actual exercise for a RMA to Deliveries Comparison Report; and I actually rewrote it as a Dashboard Report
I created several dashboard reports that pulled in 6 or 7 queries; and created a report. Job Status Report is another Epicor Curriculum exercise that isn't demonstrated very well but is a good base.
I did have problems with subreports on Dashboard Reports; at what version I can't remember but they were broke, however, getting a login ID when a subreport was added to the Dashboard report? I cannot remember what version; but it doesn't happen at E9 now? And indeed the caveat of Dashboard Reports is you don't get the flexibility of the options, sorts or filters asyou do with BAQ Report Paramter table; but you can add an Advanced Search to a dashboard and utilize that for your options and filters. Also caveat of being careful how you publish and subscribe (if at all) at the dashboard level before you publish it out to the xml for the Crystal to read. Let the subreport to the publishing and subscribing....
Ann Fisher
----- Original Message -----
From: snielsen28
To: vantage@yahoogroups.com
Sent: Wednesday, August 12, 2009 4:07 PM
Subject: [Vantage] Re: non-BAQ subreport in BAQ report
You can create a dashboard consisting of multiple BAQs. Refresh the dashboard and from the dashboard you can create a Crystal report (under Tools>Report Tools). The resulting report contains all the data from all the BAQs in the dashboard. You may need to do some linking in Crystal to get the information grouped the way you want it. You should be able to produce subreports. In some ways, its more flexible than a BAQ report because you can include results from more than one BAQ. In other ways, its less flexable because I don't think you can pass options, filter, etc. to Crystal. The data that appears in the dashboard is the data available to the report. The option to print/print preview the report in the dashboard shows up under the actions menu. I use a combination of BAQ reports and reports produced from a dashboard to meet a variety of our needs. Hope this helps.
Sue
--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> You can also leverage subreports to combine multiple kinds of data into a single report document. Regular Vantage reports can include multiple tables, but BAQ reports have a single table.
>
> Put both sets of data into the BAQ, and accept the fact that your BAQ data set doesn't make sense (i.e. you might get duplicated rows, or lots of empty columns).
>
> In the Crystal Report, you can use subreports that use the same XML BAQ result set as your data source, but do different grouping, filtering, sorting, etc. on the data.
>
> I can't think of a concrete example off the top of my head, but I know I've done this a couple of times now. Its not 100% clean but it works.
>
> -bws
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
> Sent: Wednesday, August 12, 2009 12:03 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] non-BAQ subreport in BAQ report
>
> Oh absolutely!
>
> I've used this technique multiple times when the Vantage BAQ just
> wouldn't do everything I needed.
>
> You can join multiple datasets very easily using Database Expert.
>
> A couple examples that I've done:
> - I have used the BAQ Export Process to dump a virtual table to XML
> and joined to that using Crystal Reports.
> - I have joined to an MS Access table to display related payroll info
>
> If you can relate the tables (ie, Part.PartNum <--> MSAccess.PartNum)
> then you're golden. Crystal Reports doesn't care where you get the
> data.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of emverbeke
> Sent: Wednesday, August 12, 2009 11:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] non-BAQ subreport in BAQ report
>
> I was wondering if you can put in a subreport (nonBAQ) into a BAQ
> report? I can't get it to work yet but I haven't worked a ton on it.
> Anyone know if you can or can't do this? And if you can, any tips or
> tricks?
>
> Thanks!
>
> Emily
>
>
>
> ------------------------------------
>
> 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
>
>
>
>
>
> ------------------------------------
>
> 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
>
Messages in this topic (7) Reply (via web post) | Start a new topic
Messages | Files | Photos | Database | Members
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
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Recent Activity
Visit Your Group
Give Back
Yahoo! for Good
Get inspired
by a good cause.
Y! Toolbar
Get it Free!
easy 1-click access
to your groups.
Yahoo! Groups
Start a group
in 3 easy steps.
Connect with others.
.
._,___
[Non-text portions of this message have been removed]