I stumbled across a possible solution in Vantage 8.803.404A. I found
if you create a dashboard (with multiple BAQs) and design a Crystal
report from the dashboard (under Tools>Report Tools) the dataset
return holds results from all BAQs in the dashboard. The dashboard I
tried it with is a publish and subscribe dashboard. I put the publish
dashboard in a group header in Crystal reports and the two subscribe
dashboards in two subreports in details A & B. It worked nicely. This
type of report isn't a true BAQ report, it doesn't allow options or
filters by the user. It does allow simple access to the data produced
by multiple BAQs. (The Print Preview option from Crystal reports also
works using this method where it doesn't within BAQ report creation.)
After you've finished your Crystal report you can add a report view
in the dashboard which will allow access to the report thru the
dashboard under the Actions menu. I've used both BAQ reports and
creating a report thru a dashboard depending what I'm trying to
accomplish. There are advantages and disadvantages to both. I hope
this post will help someone even a fraction of what this user group
has helped me!
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
if you create a dashboard (with multiple BAQs) and design a Crystal
report from the dashboard (under Tools>Report Tools) the dataset
return holds results from all BAQs in the dashboard. The dashboard I
tried it with is a publish and subscribe dashboard. I put the publish
dashboard in a group header in Crystal reports and the two subscribe
dashboards in two subreports in details A & B. It worked nicely. This
type of report isn't a true BAQ report, it doesn't allow options or
filters by the user. It does allow simple access to the data produced
by multiple BAQs. (The Print Preview option from Crystal reports also
works using this method where it doesn't within BAQ report creation.)
After you've finished your Crystal report you can add a report view
in the dashboard which will allow access to the report thru the
dashboard under the Actions menu. I've used both BAQ reports and
creating a report thru a dashboard depending what I'm trying to
accomplish. There are advantages and disadvantages to both. I hope
this post will help someone even a fraction of what this user group
has helped me!
--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...>
wrote:
>BAQ's
> No, sir, Sorry. It's not supported. (very unfortunately).
>
> Are the two reports very much unrelated? I've had some BIG BIG
> (1MB+ XML file) and hit it from different angles within Crystal.BAQ
>
> Also, an option..... Depending on how "live" you need the data. I
> *have* created multiple BAQ's and dumped them automatically via the
> export process and then you can hit them from Crystal.want,
>
> If they can survive with last night's data or even hourly if you
> then that could be an option.Behalf
>
> Let me know if you need more info.
>
>
> Vic Drecchio
> ERP Administrator
>
> TIMCO Aviation Services
> Greensboro, NC
> Email: vic.drecchio@...
> Office: 336.668.4410 x3091
> Mobile: 704.530.3092
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Of Ross Hughescrystal
> Sent: Thursday, October 16, 2008 1:27 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Sub-Report from BAQ
>
> Oh, the same dataset. I was referring to two different datasets.
>
> Yes, then you just connect the XML file to both reports at the
> level.Behalf
>
> Vic, have you done two different XML datasets?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Of Vic DrecchioBehalf
> Sent: Thursday, October 16, 2008 12:11 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Crystal Sub-Report from BAQ
>
> Absolutely. I do it all the time.
>
> I have subreports using the same dataset/XML file.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Of hoomail4mequery
> Sent: Thursday, October 16, 2008 12:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Sub-Report from BAQ
>
> Does anyone know if a Crystal "sub-report" can be based on a BAQ
> like the main report?must
>
> Created main BAQ and report.
> Created sub BAQ and report.
> Added sub to main.
> Runs fine within Crystal Developer but fails if run from Vantage:
>
> "Crystal Report Windows Forms Viewer
> ---------------------------
> ...
> '{BAQReportResult.InvcDtl.PartNum}'
> This field name is not known.
> Details: errorKind"
>
> Note: I have a Epicor document describing how to add sub-reports but
> this document is using ODBC for the subs data source.
>
> Thanks
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> have already linked your email address to a yahoo id to enableaccess. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder
> and Crystal Reports and other 'goodies', please goto:must
> 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
> have already linked your email address to a yahoo id to enableaccess. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder
> and Crystal Reports and other 'goodies', please goto:must
> 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
> have already linked your email address to a yahoo id to enableaccess. )
> (1) To access the Files Section of our Yahoo!Group for ReportBuilder
> 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
>