BAQ's --> BAQ Report Designer --> Crystal flow

Ditto!
Great shortcut, Brian.

Laraine

--- In vantage@yahoogroups.com, "Kevin Simon" <ksimon8fw@...> wrote:
>
> Brian,
>
>
>
> Love the shortcut - thanks. I can't stand it when I've got about a dozen
> datasources listed and close/reopen Crystal to get rid of the list.
>
>
>
> Kevin
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Brian W. Spolarich
> Sent: Wednesday, October 06, 2010 4:46 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow
>
>
>
>
>
> The BAQ will generate a new XML file each time. That's the report
> model: you run the BAQ report with whatever options/filters, Vantage
> generates a DataSet to the XML file in your
> \\server\mfgsysdata\reports\<username> folder, and renders the report by
> combining the .RPT file with the .XML file.
>
> So if you add a field, you need to point Crystal at the new data file
> or you won't be able to work with it. That's the downside of this
> disconnected reporting model (which I understand was driven into the
> design because of SAP's expensive licensing model with respect to
> Crystal Reports Server and what functionality they would allow OEMs to
> put into their own products without requiring their customers to buy
> Crystal Reports Server).
>
> The official way to do this is to add a new Data Source in Crystal:
>
> 1. Database->Set Datasource Location...
> 2. On the bottom, select Create New Connection...
> 3. Select ADO.NET (XML) as the type, browse for the file path
> pointing to your new XML file, select it, and click Finish.
> 4. Select the new ReportDataSet item on the bottom, the existing
> ReportDataSet on top, and click Update. If you skip this step you
> won't actually do the mapping. Click Close.
> 5. If any fields have changed that require mapping, Crystal will
> prompt you to map. Otherwise it might just tell you it is 'fixing up
> the database'.
>
> I've found its simpler just to do this:
>
> 1. Database->Set Datasource Location...
> 2. Expand Properties on the existing ReportDataSet.
> 3. Double-click on the File Path property. Delete a character or
> something in the path and hit Return. Crystal will prompt you to select
> the file you want instead.
> 4. Click Finish.
>
> This skips the tediousness of having to add a new connection each
> time, and instead just updates the existing connection.
>
> Crystal tends to build up these connections from past reports pointing
> to files that don't exist anyways, and it's not clear how to get rid of
> them.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> Of wapnerj
> Sent: Wednesday, October 06, 2010 4:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow
>
> I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a
> BAQ Report Design and a Crystal Report. That worked and I got my report.
>
> But now I find that I need to add a field. I've added the field to the
> BAQ but the added field does not appear in Crystal. Can someone help me
> out with what I'm missing?
>
> Related to this, what file/database should my Crystal Report be running
> against? It seems that BAQ generates a new XML file each time.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a BAQ Report Design and a Crystal Report. That worked and I got my report.

But now I find that I need to add a field. I've added the field to the BAQ but the added field does not appear in Crystal. Can someone help me out with what I'm missing?

Related to this, what file/database should my Crystal Report be running against? It seems that BAQ generates a new XML file each time.

Thanks in Advance

John Wapner
Bracalente Mfg.
You need to open the report in Crystal and point it to the new XML file that is created when you run it. then you should be all set.

________________________________

From: vantage@yahoogroups.com on behalf of wapnerj
Sent: Wed 10/6/2010 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow




I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a BAQ Report Design and a Crystal Report. That worked and I got my report.

But now I find that I need to add a field. I've added the field to the BAQ but the added field does not appear in Crystal. Can someone help me out with what I'm missing?

Related to this, what file/database should my Crystal Report be running against? It seems that BAQ generates a new XML file each time.

Thanks in Advance

John Wapner
Bracalente Mfg.






[Non-text portions of this message have been removed]
The BAQ will generate a new XML file each time. That's the report
model: you run the BAQ report with whatever options/filters, Vantage
generates a DataSet to the XML file in your
\\server\mfgsysdata\reports\<username> folder, and renders the report by
combining the .RPT file with the .XML file.

So if you add a field, you need to point Crystal at the new data file
or you won't be able to work with it. That's the downside of this
disconnected reporting model (which I understand was driven into the
design because of SAP's expensive licensing model with respect to
Crystal Reports Server and what functionality they would allow OEMs to
put into their own products without requiring their customers to buy
Crystal Reports Server).

The official way to do this is to add a new Data Source in Crystal:

1. Database->Set Datasource Location...
2. On the bottom, select Create New Connection...
3. Select ADO.NET (XML) as the type, browse for the file path
pointing to your new XML file, select it, and click Finish.
4. Select the new ReportDataSet item on the bottom, the existing
ReportDataSet on top, and click Update. If you skip this step you
won't actually do the mapping. Click Close.
5. If any fields have changed that require mapping, Crystal will
prompt you to map. Otherwise it might just tell you it is 'fixing up
the database'.

I've found its simpler just to do this:

1. Database->Set Datasource Location...
2. Expand Properties on the existing ReportDataSet.
3. Double-click on the File Path property. Delete a character or
something in the path and hit Return. Crystal will prompt you to select
the file you want instead.
4. Click Finish.

This skips the tediousness of having to add a new connection each
time, and instead just updates the existing connection.

Crystal tends to build up these connections from past reports pointing
to files that don't exist anyways, and it's not clear how to get rid of
them.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of wapnerj
Sent: Wednesday, October 06, 2010 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow

I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a
BAQ Report Design and a Crystal Report. That worked and I got my report.


But now I find that I need to add a field. I've added the field to the
BAQ but the added field does not appear in Crystal. Can someone help me
out with what I'm missing?

Related to this, what file/database should my Crystal Report be running
against? It seems that BAQ generates a new XML file each time.
Thanks Brian; the "Set Datasource Location" trick is priceless.....

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Wednesday, October 06, 2010 3:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow



The BAQ will generate a new XML file each time. That's the report
model: you run the BAQ report with whatever options/filters, Vantage
generates a DataSet to the XML file in your
\\server\mfgsysdata\reports\<username> folder, and renders the report by
combining the .RPT file with the .XML file.

So if you add a field, you need to point Crystal at the new data file
or you won't be able to work with it. That's the downside of this
disconnected reporting model (which I understand was driven into the
design because of SAP's expensive licensing model with respect to
Crystal Reports Server and what functionality they would allow OEMs to
put into their own products without requiring their customers to buy
Crystal Reports Server).

The official way to do this is to add a new Data Source in Crystal:

1. Database->Set Datasource Location...
2. On the bottom, select Create New Connection...
3. Select ADO.NET (XML) as the type, browse for the file path
pointing to your new XML file, select it, and click Finish.
4. Select the new ReportDataSet item on the bottom, the existing
ReportDataSet on top, and click Update. If you skip this step you
won't actually do the mapping. Click Close.
5. If any fields have changed that require mapping, Crystal will
prompt you to map. Otherwise it might just tell you it is 'fixing up
the database'.

I've found its simpler just to do this:

1. Database->Set Datasource Location...
2. Expand Properties on the existing ReportDataSet.
3. Double-click on the File Path property. Delete a character or
something in the path and hit Return. Crystal will prompt you to select
the file you want instead.
4. Click Finish.

This skips the tediousness of having to add a new connection each
time, and instead just updates the existing connection.

Crystal tends to build up these connections from past reports pointing
to files that don't exist anyways, and it's not clear how to get rid of
them.

-bws

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of wapnerj
Sent: Wednesday, October 06, 2010 4:11 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow

I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a
BAQ Report Design and a Crystal Report. That worked and I got my report.

But now I find that I need to add a field. I've added the field to the
BAQ but the added field does not appear in Crystal. Can someone help me
out with what I'm missing?

Related to this, what file/database should my Crystal Report be running
against? It seems that BAQ generates a new XML file each time.



[Non-text portions of this message have been removed]
Thanks for the tip and the explanation.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> The BAQ will generate a new XML file each time. That's the report
> model: you run the BAQ report with whatever options/filters, Vantage
> generates a DataSet to the XML file in your
> \\server\mfgsysdata\reports\<username> folder, and renders the report by
> combining the .RPT file with the .XML file.
>
> So if you add a field, you need to point Crystal at the new data file
> or you won't be able to work with it. That's the downside of this
> disconnected reporting model (which I understand was driven into the
> design because of SAP's expensive licensing model with respect to
> Crystal Reports Server and what functionality they would allow OEMs to
> put into their own products without requiring their customers to buy
> Crystal Reports Server).
>
> The official way to do this is to add a new Data Source in Crystal:
>
> 1. Database->Set Datasource Location...
> 2. On the bottom, select Create New Connection...
> 3. Select ADO.NET (XML) as the type, browse for the file path
> pointing to your new XML file, select it, and click Finish.
> 4. Select the new ReportDataSet item on the bottom, the existing
> ReportDataSet on top, and click Update. If you skip this step you
> won't actually do the mapping. Click Close.
> 5. If any fields have changed that require mapping, Crystal will
> prompt you to map. Otherwise it might just tell you it is 'fixing up
> the database'.
>
> I've found its simpler just to do this:
>
> 1. Database->Set Datasource Location...
> 2. Expand Properties on the existing ReportDataSet.
> 3. Double-click on the File Path property. Delete a character or
> something in the path and hit Return. Crystal will prompt you to select
> the file you want instead.
> 4. Click Finish.
>
> This skips the tediousness of having to add a new connection each
> time, and instead just updates the existing connection.
>
> Crystal tends to build up these connections from past reports pointing
> to files that don't exist anyways, and it's not clear how to get rid of
> them.
>
> -bws
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of wapnerj
> Sent: Wednesday, October 06, 2010 4:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow
>
> I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a
> BAQ Report Design and a Crystal Report. That worked and I got my report.
>
>
> But now I find that I need to add a field. I've added the field to the
> BAQ but the added field does not appear in Crystal. Can someone help me
> out with what I'm missing?
>
> Related to this, what file/database should my Crystal Report be running
> against? It seems that BAQ generates a new XML file each time.
>
Brian,



Love the shortcut - thanks. I can't stand it when I've got about a dozen
datasources listed and close/reopen Crystal to get rid of the list.



Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Wednesday, October 06, 2010 4:46 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow





The BAQ will generate a new XML file each time. That's the report
model: you run the BAQ report with whatever options/filters, Vantage
generates a DataSet to the XML file in your
\\server\mfgsysdata\reports\<username> folder, and renders the report by
combining the .RPT file with the .XML file.

So if you add a field, you need to point Crystal at the new data file
or you won't be able to work with it. That's the downside of this
disconnected reporting model (which I understand was driven into the
design because of SAP's expensive licensing model with respect to
Crystal Reports Server and what functionality they would allow OEMs to
put into their own products without requiring their customers to buy
Crystal Reports Server).

The official way to do this is to add a new Data Source in Crystal:

1. Database->Set Datasource Location...
2. On the bottom, select Create New Connection...
3. Select ADO.NET (XML) as the type, browse for the file path
pointing to your new XML file, select it, and click Finish.
4. Select the new ReportDataSet item on the bottom, the existing
ReportDataSet on top, and click Update. If you skip this step you
won't actually do the mapping. Click Close.
5. If any fields have changed that require mapping, Crystal will
prompt you to map. Otherwise it might just tell you it is 'fixing up
the database'.

I've found its simpler just to do this:

1. Database->Set Datasource Location...
2. Expand Properties on the existing ReportDataSet.
3. Double-click on the File Path property. Delete a character or
something in the path and hit Return. Crystal will prompt you to select
the file you want instead.
4. Click Finish.

This skips the tediousness of having to add a new connection each
time, and instead just updates the existing connection.

Crystal tends to build up these connections from past reports pointing
to files that don't exist anyways, and it's not clear how to get rid of
them.

-bws

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of wapnerj
Sent: Wednesday, October 06, 2010 4:11 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] BAQ's --> BAQ Report Designer --> Crystal flow

I'm starting to work with Crystal in Vantage 8. I've created a BAQ and a
BAQ Report Design and a Crystal Report. That worked and I got my report.

But now I find that I need to add a field. I've added the field to the
BAQ but the added field does not appear in Crystal. Can someone help me
out with what I'm missing?

Related to this, what file/database should my Crystal Report be running
against? It seems that BAQ generates a new XML file each time.





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