OT: Crystal Report Question

Yahoo Archive
1
I have a report like that. If you would like me to send it to you, send me
an email.

Dianna Musgrave
IS/MRP Manager
Stone County Ironworks
870-269-8108 ext. 2099
dmusgrave@...
http://www.stoneiron.com <http://www.stoneiron.com/>


_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bbelzer42
Sent: Monday, July 18, 2005 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Crystal Report Question


Is it possible to have 2 separate range selections on one detail line?

What I am trying to display is: Cust. / Month to date sales / Year to
Date sales all on the same line.

Is this possible?

Thanks,
Ben




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



* Visit your group "vantage <http://groups.yahoo.com/group/vantage> "
on the web.


* 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]
2
I am creating a crystal report with sales. I am showing every
customer and the totals of the invoices for that customer.

However, I still want to show a customer even if they don't have an
invoice. As soon as I add {extprice} to the detail line, those
customers with no invoices dissapear.

Is there any way to allow Crystal to show all customers even if they
do not have an invoice?

Thanks,
Ben
3
Join the Customer and InvcHead tables with a Left Outer Join.

-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Friday, April 01, 2005 1:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Crystal Report Question



I am creating a crystal report with sales. I am showing every
customer and the totals of the invoices for that customer.

However, I still want to show a customer even if they don't have an
invoice. As soon as I add {extprice} to the detail line, those
customers with no invoices dissapear.

Is there any way to allow Crystal to show all customers even if they
do not have an invoice?

Thanks,
Ben





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


* 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]
4
Is it possible to have 2 separate range selections on one detail line?

What I am trying to display is: Cust. / Month to date sales / Year to
Date sales all on the same line.

Is this possible?

Thanks,
Ben
5
Maybe I am missing the point of the question but why not....(not exact names ot syntax for Crystal) :
ThisMonthInv = IIFInvDate >= MonthStart and InvDate <= Today then InvAmt else 0
ThisYearInv = IIFInvDate >= 01/01/2005 and InvDate <= Today then InvAmt else 0
Then summarize these and report at the appropriate (customer?) footer.

The formula fields qualify the data range for the amounts to be used. If it has to be at a detail level then maybe summarize in a subreport and pass back to the main detail line.
-Todd C.

-----Original Message-----
From: bbelzer42 [mailto:bbelzer@...]
Sent: Monday, July 18, 2005 11:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] OT: Crystal Report Question


Is it possible to have 2 separate range selections on one detail line?

What I am trying to display is: Cust. / Month to date sales / Year to
Date sales all on the same line.

Is this possible?

Thanks,
Ben




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



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


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