Schedule Shipment report

Yahoo Archive
1
Tim, that's amazing. Is there a way you can share the Excel file? Do you connect to the database via ODBC? I'm running Progress.

Thanks



________________________________
From: "Dines, Tim" <tdines@...>
To: vantage@yahoogroups.com
Sent: Wed, January 13, 2010 10:14:03 AM
Subject: RE: [Vantage] Schedule Shipment report


By changing the CR parameters you may be able to have the report stick to a defined date range, but that removes flexibility from the report. In Crystal you can have the user prompted for starting and ending dates. You can do these same thing sin Excel and the report is produce in less than 2 seconds. In CR it takes a little while to come up.







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 Ken Taylor
Sent: Wednesday, January 13, 2010 11:49 AM
To: vantage@yahoogroups .com
Subject: Re: [Vantage] Schedule Shipment report





Tim, tech support suggested I changed the CR parameters. Does that make sense at all? This report is based on Data Definition and Report Style. By the way what is a parameter report? Thanks for your input.

Ken

____________ _________ _________ __
From: "Dines, Tim" <tdines@steelparts. com <mailto:tdines% 40steelparts. com> >
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Sent: Wed, January 13, 2010 5:05:44 AM
Subject: RE: [Vantage] Schedule Shipment report

In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.

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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Schedule Shipment report

Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

[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]







[Non-text portions of this message have been removed]
2
Just wondering if there is a need to customize the report option screen or are these prompts in a data definition file? I need to add a beginning Due Date and I don't want to re-create a whole new report. Thanks for your input.


Ken





[Non-text portions of this message have been removed]
3
In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.



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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Schedule Shipment report





Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

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





[Non-text portions of this message have been removed]
4
Tim, tech support suggested I changed the CR parameters. Does that make sense at all? This report is based on Data Definition and Report Style. By the way what is a parameter report? Thanks for your input.


Ken




________________________________
From: "Dines, Tim" <tdines@...>
To: vantage@yahoogroups.com
Sent: Wed, January 13, 2010 5:05:44 AM
Subject: RE: [Vantage] Schedule Shipment report


In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.

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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Schedule Shipment report

Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

[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
I believe what tech support is suggesting is that you can add a START FROM parameter in crystal.

That would work but it would present a dual-prompt report environment.

We rewrote the report as a BAQ because the 'program' reports such as this don't offer any usable fields to transport custom parameters across to crystal. BAQ reports give you some fields for this purpose.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ken Taylor
Sent: Wednesday, January 13, 2010 10:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Schedule Shipment report

Tim, tech support suggested I changed the CR parameters. Does that make sense at all? This report is based on Data Definition and Report Style. By the way what is a parameter report? Thanks for your input.


Ken




________________________________
From: "Dines, Tim" <tdines@...>
To: vantage@yahoogroups.com
Sent: Wed, January 13, 2010 5:05:44 AM
Subject: RE: [Vantage] Schedule Shipment report


In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.

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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Schedule Shipment report

Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

[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]



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

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
6
By changing the CR parameters you may be able to have the report stick to a defined date range, but that removes flexibility from the report. In Crystal you can have the user prompted for starting and ending dates. You can do these same thing sin Excel and the report is produce in less than 2 seconds. In CR it takes a little while to come up.







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 Ken Taylor
Sent: Wednesday, January 13, 2010 11:49 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Schedule Shipment report





Tim, tech support suggested I changed the CR parameters. Does that make sense at all? This report is based on Data Definition and Report Style. By the way what is a parameter report? Thanks for your input.

Ken

________________________________
From: "Dines, Tim" <tdines@... <mailto:tdines%40steelparts.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, January 13, 2010 5:05:44 AM
Subject: RE: [Vantage] Schedule Shipment report

In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.

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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Schedule Shipment report

Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

[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]
7
In Excel a parameter is created in the criteria section. I use this to prompt the user for a start and end date.



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 Ross Hughes
Sent: Wednesday, January 13, 2010 12:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Schedule Shipment report





I believe what tech support is suggesting is that you can add a START FROM parameter in crystal.

That would work but it would present a dual-prompt report environment.

We rewrote the report as a BAQ because the 'program' reports such as this don't offer any usable fields to transport custom parameters across to crystal. BAQ reports give you some fields for this purpose.

Ross

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On Behalf Of Ken Taylor
Sent: Wednesday, January 13, 2010 10:49 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Schedule Shipment report

Tim, tech support suggested I changed the CR parameters. Does that make sense at all? This report is based on Data Definition and Report Style. By the way what is a parameter report? Thanks for your input.

Ken

________________________________
From: "Dines, Tim" <tdines@... <mailto:tdines%40steelparts.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Wed, January 13, 2010 5:05:44 AM
Subject: RE: [Vantage] Schedule Shipment report

In the end, I found it easier just to recreate the report in Excel as a
parameter report. This way it asks the user for the starting and ending
date. It also produces the report much faster than Vantage and CR.

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 Ken Taylor
Sent: Tuesday, January 12, 2010 2:02 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Schedule Shipment report

Just wondering if there is a need to customize the report option screen
or are these prompts in a data definition file? I need to add a
beginning Due Date and I don't want to re-create a whole new report.
Thanks for your input.

Ken

[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]




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]