BAQ Missing Data

system · February 22, 2010, 3:39pm

Oops - replied to wrong thread - now corrected.

We do a lot of split orders, so this is a problem we have too. I can't solve the problem in a BAQ, but I do solve it in Crystal.

One thing to note - you cannot link to the sales rep table in your BAQ if you are using the technique I suggest.

First, separate out the sales rep ID's into rep1, rep2, rep3, rep4, and rep5. I have formulas I would be willing to share with anyone who is interested in this.

Then, create a list of numbers 1 through 5 in an Excel spreadsheet. Link to this spreadsheet in your Crystal report. Do not link this field of 5 numbers to any other table from your BAQ. This will create five records for each BAQ record, each numbered 1, 2, 3, 4, or 5.

Next, set up a formula for a single field that is the sales rep ID. If the line number is 1, use rep1, if the line number is 2, use rep2, and so forth for the 5 possible reps.

Put the various fields on your report. Suppress any records where the sales rep ID is blank. The line numbers become irrelevant at this point. You can sort by the calculated sales rep ID from the previous step.

If you need more information about the sales reps from the sales rep table, I think you could link that in using ODBC against the Vista/Vantage DB. I just use the ID and that works fine for out purposes. One more thing - if your splits do not add up to 100%, your sales totals will not be correct overall.

This information is a bit sketchy. Let me know if you need more details, or if you want me to repeat my rant about the moronic database analyst who came up with this idiotic database structure.

BTW, I like Steven's idea about breaking apart the rep list in a BPM. It still does not solve the issue of poor database structure, but it is an improvement over what is there now. Ideally, the salesperson splits should be in a separate table. I have thought about how to make that work, but so far have had more important things on my plate. If anyone comes up with that solution, I would like to see it.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Brian W. Spolarich
Sent: Monday, February 22, 2010 11:04 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Report Errors

This is how the report subsystem works in V8. Has anything changed in E9?

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@...<mailto:bspolarich%40advancedphotonix.com><mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Dines, Tim
Sent: Monday, February 22, 2010 1:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Report Errors

This is something that I run into on a daily basis. If the report does
not produce a preview screen I check the monitor after a few minutes.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Report Errors

Does anyone else have this problem?

Thanks,
Cindy

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"chouse1000" <cindy.house@...> wrote:

>
> We are upgrading from 6.10.543 to 8.03.408B and I have seen at least

four standard reports on 8.03 that have produced errors when there was
nothing to report. In 6.10 the report would come back with an error
message "No records selected for date range." However, I believe that
instead of getting this pop up error message in 8.03, we are just
getting an error message on the System Monitor instead. I have found
this to be true on the following reports: Open RMA Report, Subcontract
Status Report, and the Advance Billing/Deposit Balance Report. Has
anyone else experienced this? I want to make sure that my conversion is
clean.

>
> Thanks,
> Cindy House
>

[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/.<http://groups.yahoo.com/group/vantage/files/><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

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

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

system · February 18, 2010, 4:09pm

We are upgrading from 6.10.543 to 8.03.408B and I have seen at least four standard reports on 8.03 that have produced errors when there was nothing to report. In 6.10 the report would come back with an error message "No records selected for date range." However, I believe that instead of getting this pop up error message in 8.03, we are just getting an error message on the System Monitor instead. I have found this to be true on the following reports: Open RMA Report, Subcontract Status Report, and the Advance Billing/Deposit Balance Report. Has anyone else experienced this? I want to make sure that my conversion is clean.

Thanks,
Cindy House

system · February 22, 2010, 1:23pm

Does anyone else have this problem?

Thanks,
Cindy

--- In vantage@yahoogroups.com, "chouse1000" <cindy.house@...> wrote:
>
> We are upgrading from 6.10.543 to 8.03.408B and I have seen at least four standard reports on 8.03 that have produced errors when there was nothing to report. In 6.10 the report would come back with an error message "No records selected for date range." However, I believe that instead of getting this pop up error message in 8.03, we are just getting an error message on the System Monitor instead. I have found this to be true on the following reports: Open RMA Report, Subcontract Status Report, and the Advance Billing/Deposit Balance Report. Has anyone else experienced this? I want to make sure that my conversion is clean.
>
> Thanks,
> Cindy House
>

system · February 22, 2010, 1:40pm

This is standard functionality in V8 reports when no data is returned.

Ross

On Feb 22, 2010, at 12:21 PM, "chouse1000" <cindy.house@...

> wrote:

> Does anyone else have this problem?
>
> Thanks,
> Cindy
>
> --- In vantage@yahoogroups.com, "chouse1000" <cindy.house@...> wrote:
>>
>> We are upgrading from 6.10.543 to 8.03.408B and I have seen at
>> least four standard reports on 8.03 that have produced errors when
>> there was nothing to report. In 6.10 the report would come back
>> with an error message "No records selected for date range."
>> However, I believe that instead of getting this pop up error
>> message in 8.03, we are just getting an error message on the System
>> Monitor instead. I have found this to be true on the following
>> reports: Open RMA Report, Subcontract Status Report, and the
>> Advance Billing/Deposit Balance Report. Has anyone else
>> experienced this? I want to make sure that my conversion is clean.
>>
>> Thanks,
>> Cindy House
>>
>
>
>
>
> ------------------------------------
>
> 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 · February 22, 2010, 1:51pm

This is something that I run into on a daily basis. If the report does
not produce a preview screen I check the monitor after a few minutes.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Errors

Does anyone else have this problem?

Thanks,
Cindy

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"chouse1000" <cindy.house@...> wrote:

>
> We are upgrading from 6.10.543 to 8.03.408B and I have seen at least

four standard reports on 8.03 that have produced errors when there was
nothing to report. In 6.10 the report would come back with an error
message "No records selected for date range." However, I believe that
instead of getting this pop up error message in 8.03, we are just
getting an error message on the System Monitor instead. I have found
this to be true on the following reports: Open RMA Report, Subcontract
Status Report, and the Advance Billing/Deposit Balance Report. Has
anyone else experienced this? I want to make sure that my conversion is
clean.

>
> Thanks,
> Cindy House
>

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

system · February 22, 2010, 2:04pm

This is how the report subsystem works in V8. Has anything changed in E9?

--
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 Dines, Tim
Sent: Monday, February 22, 2010 1:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Report Errors

This is something that I run into on a daily basis. If the report does
not produce a preview screen I check the monitor after a few minutes.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Errors

Does anyone else have this problem?

Thanks,
Cindy

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"chouse1000" <cindy.house@...> wrote:

>
> We are upgrading from 6.10.543 to 8.03.408B and I have seen at least

four standard reports on 8.03 that have produced errors when there was
nothing to report. In 6.10 the report would come back with an error
message "No records selected for date range." However, I believe that
instead of getting this pop up error message in 8.03, we are just
getting an error message on the System Monitor instead. I have found
this to be true on the following reports: Open RMA Report, Subcontract
Status Report, and the Advance Billing/Deposit Balance Report. Has
anyone else experienced this? I want to make sure that my conversion is
clean.

>
> Thanks,
> Cindy House
>

[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 · February 22, 2010, 2:40pm

We do a lot of split orders, so this is a problem we have too. I can't solve the problem in a BAQ, but I do solve it in Crystal.

One thing to note - you cannot link to the sales rep table in your BAQ if you are using the technique I suggest.

First, separate out the sales rep ID's into rep1, rep2, rep3, rep4, and rep5. I have formulas I would be willing to share with anyone who is interested in this.

Then, create a list of numbers 1 through 5 in an Excel spreadsheet. Link to this spreadsheet in your Crystal report. Do not link this field of 5 numbers to any other table from your BAQ. This will create five records for each BAQ record, each numbered 1, 2, 3, 4, or 5.

Next, set up a formula for a single field that is the sales rep ID. If the line number is 1, use rep1, if the line number is 2, use rep2, and so forth for the 5 possible reps.

Put the various fields on your report. Suppress any records where the sales rep ID is blank. The line numbers become irrelevant at this point. You can sort by the calculated sales rep ID from the previous step.

If you need more information about the sales reps from the sales rep table, I think you could link that in using ODBC against the Vista/Vantage DB. I just use the ID and that works fine for out purposes. One more thing - if your splits do not add up to 100%, your sales totals will not be correct overall.

This information is a bit sketchy. Let me know if you need more details, or if you want me to repeat my rant about the moronic database analyst who came up with this idiotic database structure.

BTW, I like Steven's idea about breaking apart the rep list in a BPM. It still does not solve the issue of poor database structure, but it is an improvement over what is there now. Ideally, the salesperson splits should be in a separate table. I have thought about how to make that work, but so far have had more important things on my plate. If anyone comes up with that solution, I would like to see it.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brian W. Spolarich
Sent: Monday, February 22, 2010 11:04 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Report Errors

This is how the report subsystem works in V8. Has anything changed in E9?

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
bspolarich@...<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Dines, Tim
Sent: Monday, February 22, 2010 1:37 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Re: Report Errors

This is something that I run into on a daily basis. If the report does
not produce a preview screen I check the monitor after a few minutes.

Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Report Errors

Does anyone else have this problem?

Thanks,
Cindy

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ,
"chouse1000" <cindy.house@...> wrote:

>
> We are upgrading from 6.10.543 to 8.03.408B and I have seen at least

four standard reports on 8.03 that have produced errors when there was
nothing to report. In 6.10 the report would come back with an error
message "No records selected for date range." However, I believe that
instead of getting this pop up error message in 8.03, we are just
getting an error message on the System Monitor instead. I have found
this to be true on the following reports: Open RMA Report, Subcontract
Status Report, and the Advance Billing/Deposit Balance Report. Has
anyone else experienced this? I want to make sure that my conversion is
clean.

>
> Thanks,
> Cindy House
>

[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/.<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

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

system · February 22, 2010, 2:54pm

Ross,
That is odd, because the "Shipped Not Invoiced" report gave me the error message, like the old V6 would have, stating that no data was in the selected rangeÂ…which is what I believe that it should do. The error should not go to the System Monitor, just a note telling us that nothing was found.

ThanksÂ…I will probably write up a enhancement request form for that.

--- In vantage@yahoogroups.com, Ross Hughes <ross.hughes@...> wrote:
>
> This is standard functionality in V8 reports when no data is returned.
>
> Ross
>
> On Feb 22, 2010, at 12:21 PM, "chouse1000" <cindy.house@...
> > wrote:
>
> > Does anyone else have this problem?
> >
> > Thanks,
> > Cindy
> >
> > --- In vantage@yahoogroups.com, "chouse1000" <cindy.house@> wrote:
> >>
> >> We are upgrading from 6.10.543 to 8.03.408B and I have seen at
> >> least four standard reports on 8.03 that have produced errors when
> >> there was nothing to report. In 6.10 the report would come back
> >> with an error message "No records selected for date range."
> >> However, I believe that instead of getting this pop up error
> >> message in 8.03, we are just getting an error message on the System
> >> Monitor instead. I have found this to be true on the following
> >> reports: Open RMA Report, Subcontract Status Report, and the
> >> Advance Billing/Deposit Balance Report. Has anyone else
> >> experienced this? I want to make sure that my conversion is clean.
> >>
> >> Thanks,
> >> Cindy House
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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 · February 22, 2010, 2:58pm

Tim,

I would think that should only show up on the monitor as an error if there is a problem with the report, not if the report is fine, but there is no data to report.

Thanks,
Cindy

--- In vantage@yahoogroups.com, "Dines, Tim" <tdines@...> wrote:
>
> This is something that I run into on a daily basis. If the report does
> not produce a preview screen I check the monitor after a few minutes.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of chouse1000
> Sent: Monday, February 22, 2010 1:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report Errors
>
>
>
>
>
> Does anyone else have this problem?
>
> Thanks,
> Cindy
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "chouse1000" <cindy.house@> wrote:
> >
> > We are upgrading from 6.10.543 to 8.03.408B and I have seen at least
> four standard reports on 8.03 that have produced errors when there was
> nothing to report. In 6.10 the report would come back with an error
> message "No records selected for date range." However, I believe that
> instead of getting this pop up error message in 8.03, we are just
> getting an error message on the System Monitor instead. I have found
> this to be true on the following reports: Open RMA Report, Subcontract
> Status Report, and the Advance Billing/Deposit Balance Report. Has
> anyone else experienced this? I want to make sure that my conversion is
> clean.
> >
> > Thanks,
> > Cindy House
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · February 22, 2010, 3:06pm

V8.03.xxx

We have the same thing happen when there is no data. I have gotten 'used
to' looking at the system monitor for errors when reports don't run. I
don't like it, but we have to 'get used to' lots of things with Vantage.

If you want to test/recreate, capture and post WIP, then run the
Inventory/WIP Recon report. You will get no report and the system
monitor will show an error if there is no data to report.

Randy Weber

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Errors

Tim,

I would think that should only show up on the monitor as an error if
there is a problem with the report, not if the report is fine, but there
is no data to report.

Thanks,
Cindy

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Dines, Tim" <tdines@...> wrote:

>
> This is something that I run into on a daily basis. If the report does
> not produce a preview screen I check the monitor after a few minutes.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of chouse1000
> Sent: Monday, February 22, 2010 1:22 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Report Errors
>
>
>
>
>
> Does anyone else have this problem?
>
> Thanks,
> Cindy
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

<mailto:vantage%40yahoogroups.com> ,

> "chouse1000" <cindy.house@> wrote:
> >
> > We are upgrading from 6.10.543 to 8.03.408B and I have seen at least
> four standard reports on 8.03 that have produced errors when there was
> nothing to report. In 6.10 the report would come back with an error
> message "No records selected for date range." However, I believe that
> instead of getting this pop up error message in 8.03, we are just
> getting an error message on the System Monitor instead. I have found
> this to be true on the following reports: Open RMA Report, Subcontract
> Status Report, and the Advance Billing/Deposit Balance Report. Has
> anyone else experienced this? I want to make sure that my conversion

is

> clean.
> >
> > Thanks,
> > Cindy House
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · February 22, 2010, 3:13pm

Nope. You will see an error status for a report if there are no records selected. Select the detail row in the system monitor and click on the Detail tab. This is how Vantage works in terms of report generation.

--
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 chouse1000
Sent: Monday, February 22, 2010 2:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Report Errors

Tim,

I would think that should only show up on the monitor as an error if there is a problem with the report, not if the report is fine, but there is no data to report.

Thanks,
Cindy

--- In vantage@yahoogroups.com, "Dines, Tim" <tdines@...> wrote:
>
> This is something that I run into on a daily basis. If the report does
> not produce a preview screen I check the monitor after a few minutes.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of chouse1000
> Sent: Monday, February 22, 2010 1:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Report Errors
>
>
>
>
>
> Does anyone else have this problem?
>
> Thanks,
> Cindy
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "chouse1000" <cindy.house@> wrote:
> >
> > We are upgrading from 6.10.543 to 8.03.408B and I have seen at least
> four standard reports on 8.03 that have produced errors when there was
> nothing to report. In 6.10 the report would come back with an error
> message "No records selected for date range." However, I believe that
> instead of getting this pop up error message in 8.03, we are just
> getting an error message on the System Monitor instead. I have found
> this to be true on the following reports: Open RMA Report, Subcontract
> Status Report, and the Advance Billing/Deposit Balance Report. Has
> anyone else experienced this? I want to make sure that my conversion is
> clean.
> >
> > Thanks,
> > Cindy House
> >
>
>
>
>
>
> [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 · February 22, 2010, 3:13pm

There is an alternate solution for BAQ reports.Â Structure your BAQ where the Company is your top table.Â Then link your next table to the Company table using the Company field and outer join.Â This will guarantee that the BAQ will generate at least one record.Â You can then design your Crystal Report to display a message when there is only the one record.

________________________________
From: Randy Weber <rweber@...>
To: vantage@yahoogroups.com
Sent: Mon, February 22, 2010 2:59:51 PM
Subject: RE: [Vantage] Re: Report Errors

Â
V8.03.xxx

We have the same thing happen when there is no data. I have gotten 'used
to' looking at the system monitor for errors when reports don't run. I
don't like it, but we have to 'get used to' lots of things with Vantage.

If you want to test/recreate, capture and post WIP, then run the
Inventory/WIP Recon report. You will get no report and the system
monitor will show an error if there is no data to report.

Randy Weber

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of chouse1000
Sent: Monday, February 22, 2010 1:54 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Report Errors

Tim,

I would think that should only show up on the monitor as an error if
there is a problem with the report, not if the report is fine, but there
is no data to report.

Thanks,
Cindy

--- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ,
"Dines, Tim" <tdines@...> wrote:

>
> This is something that I run into on a daily basis. If the report does
> not produce a preview screen I check the monitor after a few minutes.
>
>
>
> Tim Dines
>
> Information Technology
>
> Steel Parts Manufacturing, Inc.
>
> 801 Berryman Pike
>
> Tipton, IN 46072
>
> Direct: 765-675-5201
>
> Cell: 765-437-1402
>
>
>
> From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>

[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf

> Of chouse1000
> Sent: Monday, February 22, 2010 1:22 PM
> To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
> Subject: [Vantage] Re: Report Errors
>
>
>
>
>
> Does anyone else have this problem?
>
> Thanks,
> Cindy
>
> --- In vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>

<mailto:vantage% 40yahoogroups. com> ,

> "chouse1000" <cindy.house@ > wrote:
> >
> > We are upgrading from 6.10.543 to 8.03.408B and I have seen at least
> four standard reports on 8.03 that have produced errors when there was
> nothing to report. In 6.10 the report would come back with an error
> message "No records selected for date range." However, I believe that
> instead of getting this pop up error message in 8.03, we are just
> getting an error message on the System Monitor instead. I have found
> this to be true on the following reports: Open RMA Report, Subcontract
> Status Report, and the Advance Billing/Deposit Balance Report. Has
> anyone else experienced this? I want to make sure that my conversion

is

> clean.
> >
> > Thanks,
> > Cindy House
> >
>
>
>
>
>
> [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]