Crystal Question

system · September 15, 2000, 2:02pm

I am trying to edit a Crystal reports form Invoice (ARform) to include a
comment on the buttom of the form. When I print to HP Deskjet in my office
it looks good. When our Accounting prints it to HP 6L it looks good, in
print preview it looks good, but when I print to Okidata-ML520 it prints
the invoice the way it was before the change. Any suggestions?

Also our A/P person e-mailed me saying:

Nothing serious, but if you go into A/P - Reports - Received but not
Invoiced and click on Print preview, it sends things directly to the
printer without allowing you to look first.

Has anyone else seen this problem, are there fixes for it?

Oleg Tumarkin
Herker Industries

system · September 15, 2000, 4:13pm

Just to let you know you're not crazy. I cannot get our HP/4V,
HP/5P, or Epson dfx 8000 to print the same as the HP/5N or
5L's. Have you tried printing to the Okidata from Crystal Reports?

I'm working on the PO form now. Crystal prints it fine to the
HP5P but Vantage won't. Line 1 is deleted and the total
recalculated. Print preview looks good. The 5N and 5L's print it
fine but not the 4P or 5P. I'm not done checking yet and I haven't
gone to support yet. The form that shipped with Vantage works
fine.

On 15 Sep 00, at 13:03, Oleg Tumarkin wrote:
I am trying to edit a Crystal reports form
Invoice (ARform) to include a
comment on the buttom of the form. When I print
to HP Deskjet in my office
it looks good. When our Accounting prints it to
HP 6L it looks good, in
print preview it looks good, but when I print to
Okidata-ML520 it prints
the invoice the way it was before the change.
Any suggestions?

Russ Dover
IS Manager
Weaver Industries, Inc.
717 336 7507 phone
717 336 4182 fax
rdover@...

system · January 16, 2002, 11:12am

If I had a penny for every minute I wasted reformatting a subtotal field in
crystal I'd be a rich man. I do a lot of reports where I suppress the
detail and print out the subtotals. The problem is the subtotal line. In
lotus I can paint the field or column but the only way I've found in Crystal
is to reformat the field one at a time. Anyone know a more efficient way?
How about changing the defaults so it never prints a line. Anyone know how
to do that?

system · January 16, 2002, 3:37pm

What do you mean by "so that it never prints a line"...
If you click File/Options in Crystal, you can set default Fonts (and many other attributes) for the various sections of the reports. Is that what you mean?

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ed Zywiec
To: 'vantage@yahoogroups.com'
Sent: Wednesday, January 16, 2002 10:53 AM
Subject: [Vantage] Crystal Question

If I had a penny for every minute I wasted reformatting a subtotal field in
crystal I'd be a rich man. I do a lot of reports where I suppress the
detail and print out the subtotals. The problem is the subtotal line. In
lotus I can paint the field or column but the only way I've found in Crystal
is to reformat the field one at a time. Anyone know a more efficient way?
How about changing the defaults so it never prints a line. Anyone know how
to do that?

Yahoo! Groups Sponsor
ADVERTISEMENT

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/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · January 16, 2002, 4:33pm

If your meaning is Can I select more than one field and then format them
all to be the same, you do that by selecting the fields with the shift key
held down, then right click and you have the option to format the fields
(fonts, lines, so on) all the same.

If that isn't what you meant, sorry I don't know what your asking.

Lydia

lotus I can paint the field or column but the only way I've found in
Crystal
is to reformat the field one at a time. Anyone know a more efficient way?
How about changing the defaults so it never prints a line. Anyone know
how
to do that?

system · January 16, 2002, 5:57pm

Yes that's what I mean. The border top on a summary field always defaults
to single line. You just saved me a lot of time. Thanks.

-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Wednesday, January 16, 2002 3:34 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Question

If your meaning is Can I select more than one field and then format them
all to be the same, you do that by selecting the fields with the shift key
held down, then right click and you have the option to format the fields
(fonts, lines, so on) all the same.

If that isn't what you meant, sorry I don't know what your asking.

Lydia

lotus I can paint the field or column but the only way I've found in
Crystal
is to reformat the field one at a time. Anyone know a more efficient way?
How about changing the defaults so it never prints a line. Anyone know
how
to do that?

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=215002.1818248.3328688.1261774/D=egroupweb/S=17050071
83:HM/A=847665/R=0/*http://ads.x10.com/?bHlhaG9vbW9uc3RlcjcuZGF0=1011216788%
3eM=215002.1818248.3328688.1261774/D=egroupweb/S=1705007183:HM/A=847665/R=1>

<http://us.adserver.yahoo.com/l?M=215002.1818248.3328688.1261774/D=egroupmai
l/S=1705007183:HM/A=847665/rand=764021610>

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
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .

system · April 6, 2004, 3:14pm

I am trying to write a Crystal Report that will show me the average use
of a group of parts for the preceding 12 months. This report must be run
each month and has to show the rolling 12 month average. I need to be
able to list the month names and the quantity used for that month and
then include the average for the 12 months listed. I would like to
create formulas that will grab the data and put it in the appropriate
month totals without having to edit date ranges. Can anyone tell me how
I would select records based on the current month -1, current month -2,
current month -3 etc and then how to apply the appropriate month name to
the month?

Thank You

Todd Hofert
IT Director
Spartan Graphics, Inc.

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

system · May 10, 2005, 9:50am

I need to pull a value from rep rate in the invoicedtl table, which is
an array. I only want to pull the first value in the array for each
rep. In report builder this is essentially done for you (i.e., reprate
[1]), but I don't know how to "code" it to get crystal to pull this
value.

Thanks,

Mark Smith
Innerpac, Inc.

system · May 10, 2005, 10:19am

Mark,
This should lead you in the direction you need to go. This method is messy,
and there may be a much cleaner way to get at it.

RepRate1...Left ({OrderDtl.RepRate}, (InStr ({OrderDtl.RepRate}, ";")-1))

RepRate2...Mid ({OrderDtl.RepRate},(InStr ({OrderDtl.RepRate}, ";")+1),
(InStr ((InStr ({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")-(InStr
({OrderDtl.RepRate}, ";")))-1)

RepRate3...Mid ({OrderDtl.RepRate},(InStr ((InStr ({OrderDtl.RepRate},
";")+1), {OrderDtl.RepRate}, ";")+1), (InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")-(InStr ((InStr ({OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")))-1)

RepRate4...Mid ({OrderDtl.RepRate},(InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), (InStr ((InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")-(InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")))-1)

RepRate5...Mid ({OrderDtl.RepRate},(InStr ((InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1))

Good Luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of innerpac_il
Sent: Tuesday, May 10, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Crystal Question

I need to pull a value from rep rate in the invoicedtl table, which is
an array. I only want to pull the first value in the array for each
rep. In report builder this is essentially done for you (i.e., reprate
[1]), but I don't know how to "code" it to get crystal to pull this
value.

Thanks,

Mark Smith
Innerpac, Inc.

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/links
Yahoo! Groups Links

system · May 10, 2005, 4:12pm

Messy maybe, but it works.

Thanks,

Mark Smith
Director of Information Systems
Innerpac, Inc
(p) 708-863-8300
(f) 708-863-9770
www.innerpac.com

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Aaron Hoyt
Sent: Tuesday, May 10, 2005 9:19 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: Crystal Question

Mark,
This should lead you in the direction you need to go. This method is
messy,
and there may be a much cleaner way to get at it.

RepRate1...Left ({OrderDtl.RepRate}, (InStr ({OrderDtl.RepRate},
";")-1))

RepRate2...Mid ({OrderDtl.RepRate},(InStr ({OrderDtl.RepRate}, ";")+1),
(InStr ((InStr ({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate},
";")-(InStr
({OrderDtl.RepRate}, ";")))-1)

RepRate3...Mid ({OrderDtl.RepRate},(InStr ((InStr ({OrderDtl.RepRate},
";")+1), {OrderDtl.RepRate}, ";")+1), (InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")-(InStr ((InStr ({OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")))-1)

RepRate4...Mid ({OrderDtl.RepRate},(InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), (InStr ((InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")-(InStr ((InStr
((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")))-1)

RepRate5...Mid ({OrderDtl.RepRate},(InStr ((InStr ((InStr ((InStr
({OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1),
{OrderDtl.RepRate}, ";")+1), {OrderDtl.RepRate}, ";")+1))

Good Luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of innerpac_il
Sent: Tuesday, May 10, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Crystal Question

I need to pull a value from rep rate in the invoicedtl table, which is
an array. I only want to pull the first value in the array for each
rep. In report builder this is essentially done for you (i.e., reprate
[1]), but I don't know how to "code" it to get crystal to pull this
value.

Thanks,

Mark Smith
Innerpac, Inc.

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/links
Yahoo! Groups Links

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/links

________________________________

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

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

system · July 26, 2005, 12:24pm

Is is possible to display query results in Landscape view?

Mark Smith
Innerpac, Inc.

system · July 26, 2005, 1:21pm

Change the printer settings to landscape and save the report sometimes it
doesn't save the setting and sometime it does.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.

-----Original Message-----
From: innerpac_il [mailto:mark_smith@...]
Sent: Tuesday, July 26, 2005 12:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Crystal Question

Is is possible to display query results in Landscape view?

Mark Smith
Innerpac, Inc.

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/links
Yahoo! Groups Links

Topic		Replies	Views
Crystal Question Yahoo Archive	1	395	September 15, 2000
Crystal PO Form Yahoo Archive	5	423	April 24, 2003
Crystal Reports and 6.1 Yahoo Archive	8	613	January 27, 2006
A/R invoice crystal report question Yahoo Archive	3	496	February 23, 2004
Crystal Sales Order Form Yahoo Archive	5	469	August 26, 2002

Crystal Question

Related topics