The detail doesn't correspond to my header

[RSX02]

Hi
I have a report that in the header I have the Item and the Lot. For each record that the item AND lot are the same I should have a detail section link to it.

The problem is that when I print my report I have Full of data that I shouldn't have in the detail section as it doesn't correspond to the header section (item and lot). I tried to group by item and that seems to work when I have only one lot by item (because I can have as many lot as I want for an item). But when I gonna have more than one lot for an item it will print every data for an item without considering the lot. It shouldn't work this way because the key for my data supposed to be the item and the lot. I don't know if it's my StoredProcedure that isn't okay or my report that I should group by item and by lot and make a "New page after the lot group".
Can somebody tell me how can I solve it?

 

[synapsevampire]

Consider fleshing out your environment by posting database and version information as opposed to text descriptions, especially because this one was a bit complicated to understand.

Crystal and database version, example data and expected output are generally very useful.

There are different types of headers, Report, Page and Group.

If you simply placed your fields on the report, then Crystal will just dump them as they are returned.

If you want the rows grouped by item and lot, then use Insert->Group to create groups for each, though the Stored Procedure would be a faster way of handling that part.

I really don't know what your question is, please consider saving yourself and others time by fleshing out your environment.

-k

 

[virk0009]

hi
I think u have two tables.
1 (master table ) mst
vih has field
lot
item

and a detail table.
Dtl.

lot
item
field1
field2
fieldn

I think u want to print the detail vih contains only those
records where dtl.lot = mst.lot and dtl.item = mst.item.

If this ur problem, there are two ways to solve this problem.

# u can group on lot or item as ur wish.

1. Link mst table and dtl table with 2 fields that is lot
and item. I mean there must be two link for two fields for both tables.

2. U can supress printing records in detail section
by follwing lines.
if {dtl.lot} = {mst.lot} and {dtl.item}={mst.item} then
false
else
true

If u need further help, please list name of the tables and
fields.

Regards
Parminder Virk