I am new to crystal reports. I am trying to create a report with some table of my database, I have created a dataset with the table and I have joined tables:
A (primary table; key field id_a) b (join one by ID_A; one relation to one) C (Join one by ID_A; Multiple relationships from one) D (Join for C for IDC; A Many relationships from A)
Then I try to make this form as a design:
The column named X: value A. Column_x Name column Y: A.column_y Name column value Z: B.column_z Name column value D.column_j Name column D.column_i XYJ HJU IOP IOP
A record is in the table (I filter by a parameter) and for this value in A, the value of multiple line items in Table D. I see the output in the output:
named column X: A.column_x name column column Y: A.column_y name column Z: value B.column_z name column D.column_j name column D.column_i XYJ HJU Name column X: A.column_x name column Y: A.column_y name column Z: B.column_z name Column DC value Olumn_j Name column D.column_i IOP IOP
I do not know why, but the first part is repeated repeatedly when the D column values are shown and apart from this I do not know how all the values of D together Eat it
I tried to fix this by making a sequence of tables C and D but this is the same. I split the two parts into separate details section but nothing has changed.
EDIT:
As I said, I try in some other way and I have created a sequence (tables C and D). Then, I have:
A (primary table; key field id_a) B (Join one by ID_A; see one relation from one) D (FK ID_A; Multiple relations from one)
I have a design view in:
Description a:
Column named X: Column named A.column_x Y: Value Name of A.column_y column Z: B.column_z value
Description b:
Column named name D.column_j Name column D.column_i XYJ HJU IOP -text "itemprop =" text ">
if you place in 2 details So the output will be one that you are getting ...
To get the required output ...
Place in the in-page header
< Code> Name column X: A.column_x name column Y: Value A.column_y name column Z: Value of B.column_z
Enter these details:
Column named D.column_j Name column D.column_i XYJ HJU IOP IOP
If you have data retaining page headers, then the path must be removed:
- Create 2 sub-reports in the main report ... place under a field in the
Description
andDescription B
/ P>
The name column X: A.column_x is named Y. Value A.column_y Name column Z: The value of B.column_z
Description B
in the field below
named column D.column_j name column D.column_i XYJ HJU IOP IOP
Comments
Post a Comment