Data Description not printing

[AccUser]

I have a report that brings following tables:

TableA has customer info. TableB has product info. TableC has sales info.

By grouping on the product, I can get summary records for the products (MTD, YTD, ...). I hide the product group header and detail section. I copied the product id to the group footer section, along with summary formulas. But when I try to add the product description, I either end up with 1 record or the app crashes because it locks after awhile.

What am I doing wrong?

 

[synapsevampire]

Lots of potential problems here, sharing technical information will help in diagnosing it:

Crystal version
Database/connectivity used
Example data (and what is the description data type?)
Expected output

One trick might be to use a SQL Expression to parse the description data, but this is Crystal version and database dependent.

It also may be that your connectivty is wrong, one example of this is using the Oracle supplied ODBC driver instead of the Crystal supplied Oracle ODBC driver.

-k

 

[AccUser]

Sorry...

Crystal Reports 9.0
Extracting Data from SqlServer2000
CustomerTable has CustID, CustomerName,...
PartTable has PartID, Part Desc,...
SalesData has PeriodID,CustID,PartID,...(no part desc)
PartDesc is string value

Expected Output

Part No Desc MTD YTD
PartA PartADesc 1 1
PartB PartBDesc 4 9

Actual Output

Part No Desc MTD YTD
PartADesc 0 0

But if no desc is included, I get:

Part No Desc MTD YTD
PartA 1 1
PartB 4 9

 

[synapsevampire]

So close, if only you would have supplied example data instead of the names of somet of the fields in the tables.

Right click the part desc field and select browse data, this wil show you it's type.

Not sure why you don't want to provide this information, it is important.

If you're trying to concatenate the product descriptions into one field in a group footer, use the 3 formula method:

GH formula:
whileprintingrecords;
stringvar AllDesc:= ""

Details formula:
whileprintingrecords;
stringvar AllDesc:= AllDesc+{table.desc}+" "

GF formula:
whileprintingrecords;
stringvar AllDesc

The GF formula will now display the descriptions for all of the details in one field.

-k

 

[AccUser]

Sorry about that. Specs as requested:

Customer Table:
CompanyNo: String[2]
CustomerNo: String[11]
Name: String[40]
Slsprsn: Number: Number

Part Table:
CompanyNo: String[2]
PartNo: String[15]
PartDescription: String[40]
Leadtime: Number

ForecastTable:
CompanyNo: String[2]
YYYYMM: String[6]
PartNo: String[15]
CustomerNo: String[11]
Forecasted: Number
MonthSales: Number

SampleData:
CT: 001 100 Bill's Auto 2
001 105 Frank's Repair 11

PT: 001 1003A Sprockets 15
001 235C O-Rings 7

FT: 001 200301 1003A 100 75 37
001 200301 235C 100 20 40
001 200301 1003A 105 30 25
001 200302 1003A 100 75 80
001 200302 235C 100 10 20
001 200302 235C 105 40 40