BAQ Reports Blank Title 92082

Yahoo Archive
1
Your best bet is to use dashboard.
Â
Create a BAQ and use this BAQ to create a dashboard. In the dashboard add more querys or create a filter. Use this to generate a dataset and there rest of steps is excatly as you would when creating any report.
this worked for me in may situations. I have even used it to create KPIs

--- On Fri, 23/7/10, Paul L Bennett <paullbennett@...> wrote:


From: Paul L Bennett <paullbennett@...>
Subject: [Vantage] BAQ Reports
To: "Vantage Group" <vantage@yahoogroups.com>
Date: Friday, 23 July, 2010, 19:10


Â



Can anyone tell me how to create subreports within crystal reports using BAQs
and BAQ Report Designer XML data as the source? I am able to do this with ease
using pure crystal report and ODBC but am a little lost as to how to do this
with BAQs...

Thanks in advance

[Non-text portions of this message have been removed]











[Non-text portions of this message have been removed]
2
Can anyone tell me how to create subreports within crystal reports using BAQs
and BAQ Report Designer XML data as the source? I am able to do this with ease
using pure crystal report and ODBC but am a little lost as to how to do this
with BAQs...

Thanks in advance




[Non-text portions of this message have been removed]
3
Paul, you can only use the single BAQ dataset for subreports.



When I had the need for something like this you have two options:



1) Make your BAQ result-set enormous and the container and sub
report will dice it up on the front end and display what you need.

2) Use your BAQ result-set for your container/master report and
dump other BAQ data-sets via the BAQ Export Process to XML somewhere
share-able on the network and use that data-set for your subreport(s).









________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul L Bennett
Sent: Friday, July 23, 2010 2:11 PM
To: Vantage Group
Subject: [Vantage] BAQ Reports





Can anyone tell me how to create subreports within crystal reports using
BAQs
and BAQ Report Designer XML data as the source? I am able to do this
with ease
using pure crystal report and ODBC but am a little lost as to how to do
this
with BAQs...

Thanks in advance

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Thanks for your response,

How do you deal with the fact that BAQs don't do right outter joins? I am
positive I read about away around this.

Paul


________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Fri, July 23, 2010 2:21:45 PM
Subject: RE: [Vantage] BAQ Reports

Â
Paul, you can only use the single BAQ dataset for subreports.

When I had the need for something like this you have two options:

1) Make your BAQ result-set enormous and the container and sub
report will dice it up on the front end and display what you need.

2) Use your BAQ result-set for your container/master report and
dump other BAQ data-sets via the BAQ Export Process to XML somewhere
share-able on the network and use that data-set for your subreport(s).

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul L Bennett
Sent: Friday, July 23, 2010 2:11 PM
To: Vantage Group
Subject: [Vantage] BAQ Reports

Can anyone tell me how to create subreports within crystal reports using
BAQs
and BAQ Report Designer XML data as the source? I am able to do this
with ease
using pure crystal report and ODBC but am a little lost as to how to do
this
with BAQs...

Thanks in advance

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
5
You can write your singular BAQ query to include everything.

When you see the result in your query it may be more than you need. But then you create a subreport to read that same query to only include what you want and create the link from the main to the subreport

Does that make sense? Also if your requirement ends up being more complicated than what a singular query can accomplish. Dashboard reports can accomplish this as well reading multiple queries where one is the parent and others are the children or pulled into sub reports

Do you have a specific requirement. It might be easier to answer if you have a specific question


Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Paul L Bennett <paullbennett@...>
Sender: vantage@yahoogroups.com
Date: Fri, 23 Jul 2010 11:10:56
To: Vantage Group<vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Reports

Can anyone tell me how to create subreports within crystal reports using BAQs
and BAQ Report Designer XML data as the source?� I am able to do this with ease
using pure crystal report and ODBC but am a little lost as to how to do this
with BAQs...

Thanks in advance




[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
6
2 becomes very messy!
Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: "Vic Drecchio" <vic.drecchio@...>
Sender: vantage@yahoogroups.com
Date: Fri, 23 Jul 2010 14:21:45
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Reports

Paul, you can only use the single BAQ dataset for subreports.



When I had the need for something like this you have two options:



1) Make your BAQ result-set enormous and the container and sub
report will dice it up on the front end and display what you need.

2) Use your BAQ result-set for your container/master report and
dump other BAQ data-sets via the BAQ Export Process to XML somewhere
share-able on the network and use that data-set for your subreport(s).









________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul L Bennett
Sent: Friday, July 23, 2010 2:11 PM
To: Vantage Group
Subject: [Vantage] BAQ Reports





Can anyone tell me how to create subreports within crystal reports using
BAQs
and BAQ Report Designer XML data as the source? I am able to do this
with ease
using pure crystal report and ODBC but am a little lost as to how to do
this
with BAQs...

Thanks in advance

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
7
Yes BAQs cannot do right outer joins

I have done this with dashboards

Sent from my Verizon Wireless BlackBerry

-----Original Message-----
From: Paul L Bennett <paullbennett@...>
Sender: vantage@yahoogroups.com
Date: Fri, 23 Jul 2010 12:33:45
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Reports



Thanks for your response,

How do you deal with the fact that BAQs don't do right outter joins? I am
positive I read about away around this.

Paul


________________________________
From: Vic Drecchio <vic.drecchio@...>
To: vantage@yahoogroups.com
Sent: Fri, July 23, 2010 2:21:45 PM
Subject: RE: [Vantage] BAQ Reports

Â
Paul, you can only use the single BAQ dataset for subreports.

When I had the need for something like this you have two options:

1) Make your BAQ result-set enormous and the container and sub
report will dice it up on the front end and display what you need.

2) Use your BAQ result-set for your container/master report and
dump other BAQ data-sets via the BAQ Export Process to XML somewhere
share-able on the network and use that data-set for your subreport(s).

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Paul L Bennett
Sent: Friday, July 23, 2010 2:11 PM
To: Vantage Group
Subject: [Vantage] BAQ Reports

Can anyone tell me how to create subreports within crystal reports using
BAQs
and BAQ Report Designer XML data as the source? I am able to do this
with ease
using pure crystal report and ODBC but am a little lost as to how to do
this
with BAQs...

Thanks in advance

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]