Crystal reports fluke Help please

system · November 18, 2008, 10:52am

It was the RDD I got it running now. Stupid part.inactive field wasn't in
the rdd.

-----Original Message-----
From: Charlie Wilson [mailto:foamdesigncsw@...]
Sent: Tuesday, November 18, 2008 10:43 AM
To: 'Charlie Wilson'
Subject: RE: [Vantage] Crystal reports fluke Help please

I think you are right the issue lies in the RDD I'm going to see if I can
create. A new one and go from there.

-----Original Message-----
From: Charlie Wilson [mailto:foamdesigncsw@...]
Sent: Tuesday, November 18, 2008 10:05 AM
To: 'Vic Drecchio'
Subject: RE: [Vantage] Crystal reports fluke Help please

Here is what I got.

-----Original Message-----
From: Vic Drecchio [mailto:Vic.Drecchio@...]
Sent: Tuesday, November 18, 2008 9:56 AM
To: Charlie Wilson
Subject: RE: [Vantage] Crystal reports fluke Help please

If you'd like, email me your RPT and XML.

-----Original Message-----
From: Charlie Wilson [mailto:foamdesigncsw@...]
Sent: Tuesday, November 18, 2008 9:54 AM
To: Vic Drecchio
Subject: RE: [Vantage] Crystal reports fluke Help please

New report from the ground up.

~Charlie

-----Original Message-----
From: Vic Drecchio [mailto:Vic.Drecchio@...]
Sent: Tuesday, November 18, 2008 9:53 AM
To: foamdesigncsw@...
Subject: RE: [Vantage] Crystal reports fluke Help please

And you chose your modified Report Data Def in your Report Style? Make
sure you do that otherwise it will be sending the wrong result set.

Consider dumping the PartTran table to XML nightly via the BAQ Export
Process. It'll dump to mfgsysdata\reports\{user}. You may filter, as I
have in the past, on specific TranType's (MFG-STK, PUR-STK, etc).

Is it a "new" report that you created or is it a modified version of the
original Stock Status Report? If you created a brand-new report from
the ground-up and put it as a style of the Stock Status report, it may
be tricky.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 18, 2008 9:47 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports fluke Help please

What I did is added my new report as a style onto the Stock status
report.

So when I run the "stock status" report I change the style to the
inventory
turns report which means that Vantage pushes the correct XML down to the
report when it runs.

Just like it does with the standard stock status report.

I have tested and confirmed that the report is in fact getting the new
XML
file when I run it.

The parttran table is brought in VIA ODBC at the moment which makes the
report take an obscene amount of time to run.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Vic Drecchio
Sent: Tuesday, November 18, 2008 9:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports fluke Help please

Charlie, if I understand you correctly:

You created a new Crystal Reports report using the Stock Status XML file
located in mfgsysdata\reports\{user}

With the information you shared (and pending I am understanding you), it
doesn't work like that.

The XML file path and name are pushed to Crystal Reports as the report
is generated in Vantage/BAQ. The file is dynamic and changes every time
you run a report. Furthermore, if your Vantage system is properly set
up, those XML files are archived/deleted daily.

You must do one of two things:

1) Create a new BAQ Query and BAQ Report Designer to provide you with
the results you need and pump those out to a brand new Crystal Reports
report.

2) Copy the existing Stock Status report and the system default Report
Data Definition for the Stock Status report. Make changes to the report
and the RDD to yield the results you need. Make your modified report
and RDD a new "Report Style" of the Stock Status report.

How did you bring in the PartTran table? Via ODBC or did you create a
report in BAQ Report Designer?

If I misunderstood your email, I apologize in advance. :-)

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 18, 2008 9:22 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Crystal reports fluke Help please

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the
XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML
file
from the stock status report the report runs flawlessly but when I run
the
report from vantage I get a error message stating that a field name is
not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType} = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

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

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
5:24 PM

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

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date:
11/17/2008
5:24 PM

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM

system · November 18, 2008, 9:22am

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML file
from the stock status report the report runs flawlessly but when I run the
report from vantage I get a error message stating that a field name is not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType} = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

system · November 18, 2008, 9:27am

Hi Charlie,

After highlighting it, does it not give you any more information?

Cheers,

CHRIS

________________________________
From: Charlie Wilson <foamdesigncsw@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 18, 2008 2:21:57 PM
Subject: [Vantage] Crystal reports fluke Help please

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML file
from the stock status report the report runs flawlessly but when I run the
report from vantage I get a error message stating that a field name is not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType } = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

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

system · November 18, 2008, 9:32am

Details : errorKind

Is the only thing it says

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Chris Thompson
Sent: Tuesday, November 18, 2008 9:27 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal reports fluke Help please

Hi Charlie,

After highlighting it, does it not give you any more information?

Cheers,

CHRIS

________________________________
From: Charlie Wilson <foamdesigncsw@ <mailto:foamdesigncsw%40yahoo.com>
yahoo.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tuesday, November 18, 2008 2:21:57 PM
Subject: [Vantage] Crystal reports fluke Help please

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML file
from the stock status report the report runs flawlessly but when I run the
report from vantage I get a error message stating that a field name is not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType } = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM

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

system · November 18, 2008, 9:35am

Charlie, if I understand you correctly:

You created a new Crystal Reports report using the Stock Status XML file
located in mfgsysdata\reports\{user}

With the information you shared (and pending I am understanding you), it
doesn't work like that.

The XML file path and name are pushed to Crystal Reports as the report
is generated in Vantage/BAQ. The file is dynamic and changes every time
you run a report. Furthermore, if your Vantage system is properly set
up, those XML files are archived/deleted daily.

You must do one of two things:

1) Create a new BAQ Query and BAQ Report Designer to provide you with
the results you need and pump those out to a brand new Crystal Reports
report.

2) Copy the existing Stock Status report and the system default Report
Data Definition for the Stock Status report. Make changes to the report
and the RDD to yield the results you need. Make your modified report
and RDD a new "Report Style" of the Stock Status report.

How did you bring in the PartTran table? Via ODBC or did you create a
report in BAQ Report Designer?

If I misunderstood your email, I apologize in advance. :-)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 18, 2008 9:22 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal reports fluke Help please

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the
XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML
file
from the stock status report the report runs flawlessly but when I run
the
report from vantage I get a error message stating that a field name is
not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType} = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

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

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

system · November 18, 2008, 9:39am

IÂ¹m wondering if this is something as silly as having extra fields defined
in a new Report Data Definition, but you didnÂ¹t use that RDD with the report
style that references the new Crystal report file (i.e. you forgot to change
the default data def for the new style)? I do that occasionally and scratch
my head when my report doesnÂ¹t get all of the data I expected.

-bws

On 11/18/08 6:21 AM, "Charlie Wilson" <foamdesigncsw@...> wrote:

>
>
>
> All,
>
> I have built a crystal report that returns inventory turn information. I
> have basically hung this report off the stock status report so that the XML
> file is sent to it to get the start amounts on a certain day.
>
> Now when I run this report from crystal writer selecting a valid XML file
> from the stock status report the report runs flawlessly but when I run the
> report from vantage I get a error message stating that a field name is not
> known in my record selection statement. Which is just below.
>
> {PartPlant.Plant} = {?Plant Choice} and
>
> ({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
> false)and
>
> ({PartTran.TranType} = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
> {PartTran.TranType} = "MFG-STK") and
>
> {PartTran.TranDate} >= {?Transaction Date}
>
> Now it highlights the first row as having the problem.
>
> I'm totally baffled.
>
> Help please?
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
>
>

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

system · November 18, 2008, 9:46am

What I did is added my new report as a style onto the Stock status report.

So when I run the "stock status" report I change the style to the inventory
turns report which means that Vantage pushes the correct XML down to the
report when it runs.

Just like it does with the standard stock status report.

I have tested and confirmed that the report is in fact getting the new XML
file when I run it.

The parttran table is brought in VIA ODBC at the moment which makes the
report take an obscene amount of time to run.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Tuesday, November 18, 2008 9:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal reports fluke Help please

Charlie, if I understand you correctly:

You created a new Crystal Reports report using the Stock Status XML file
located in mfgsysdata\reports\{user}

With the information you shared (and pending I am understanding you), it
doesn't work like that.

The XML file path and name are pushed to Crystal Reports as the report
is generated in Vantage/BAQ. The file is dynamic and changes every time
you run a report. Furthermore, if your Vantage system is properly set
up, those XML files are archived/deleted daily.

You must do one of two things:

1) Create a new BAQ Query and BAQ Report Designer to provide you with
the results you need and pump those out to a brand new Crystal Reports
report.

2) Copy the existing Stock Status report and the system default Report
Data Definition for the Stock Status report. Make changes to the report
and the RDD to yield the results you need. Make your modified report
and RDD a new "Report Style" of the Stock Status report.

How did you bring in the PartTran table? Via ODBC or did you create a
report in BAQ Report Designer?

If I misunderstood your email, I apologize in advance. :-)

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 18, 2008 9:22 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Crystal reports fluke Help please

All,

I have built a crystal report that returns inventory turn information. I
have basically hung this report off the stock status report so that the
XML
file is sent to it to get the start amounts on a certain day.

Now when I run this report from crystal writer selecting a valid XML
file
from the stock status report the report runs flawlessly but when I run
the
report from vantage I get a error message stating that a field name is
not
known in my record selection statement. Which is just below.

{PartPlant.Plant} = {?Plant Choice} and

({Part.TypeCode} = "P" and {Part.InActive} = false and {Part.NonStock} =
false)and

({PartTran.TranType} = "PUR-STK" or {PartTran.TranType} = "INS-STK" or
{PartTran.TranType} = "MFG-STK") and

{PartTran.TranDate} >= {?Transaction Date}

Now it highlights the first row as having the problem.

I'm totally baffled.

Help please?

~Charlie

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

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

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. <http://groups.yahoo.com/group/vantage/files/>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups. <http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.175 / Virus Database: 270.9.4/1794 - Release Date: 11/17/2008
5:24 PM

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

Topic		Replies	Views
Crystal Reports That use XML Sheets Yahoo Archive	5	505	November 5, 2008
Need Help Adding RDD Yahoo Archive	7	386	June 18, 2013
Crystal Report error when run from w/in Vantage Yahoo Archive	3	902	July 10, 2008
Error in crystal when Adding table to AR invoice Yahoo Archive	6	772	August 2, 2012
Random Crystal Action Yahoo Archive	5	422	May 27, 2009

Crystal reports fluke Help please

Related Topics