I need to create a report where the user will enter in a date and then can see the quantity sold on their items from the prior 12 months. It must run under version 8.5.
Setup
Table has the following fields
Year, ItemNumber,
Period1, Period2, Period3, Period4, Period5, Period6, Period7...
This is related to topic # 767-878823
http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/100/pid/767/qid/878823
I want to be able to group on the Integer portion and have all of the related documents listed underneath.
for example
+17.000
17.001
17.002
17.005
17.006
but CR is...
I have a list of ID's stored in a string field in an sql database. (see lists below) I would like to use a formula to get the proper sorting. The issue is CR is sorting them like below.
Default Desired
Sorting Sorting
RFIID RFIID
001.001 001.001
002...
Using standard version 10 of Crystal Reports.
Database is Peachtree = Btrieve (customized) does not allow for SQL expressions.
I have multiple companies in Peachtree. Each Company has its own set of tables. Table definition for each company are identical but are not linked in any way.
I would...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.