Hi, I need some help regarding the

[sslab]

Hi,
I need some help regarding the crystal report format...I am using Crystal reports 9. The database tables used for this report are Prodinfo (prodid, pic1, pic2)
Stdequip (prodid, type, desc)
Stdfeature(prodid, type, desc)
The report format shld be

prodid1
pic1 Stdequip
.Type1 desc
.Type2 desc

pic2 Stdfeatures
.Type1 desc
.Type2 desc
prodid2
pic1 Stdequip
.Type1 desc
.Type2 desc

pic2 Stdfeatures
.Type1 desc
.Type2 desc
and so on
How can I achieve this?? Please let me know..
Any help is appreciated.. Thank you

 

[synapsevampire]

Hard to say with certainty without understanding the joins, but I think you can do the following:

Group by Prodid, Right click the details and select insert section below.

Place pic1 and stdequip in details A, and pic2 and stdfeatures in details b.

Should work, again the joins might get you here so if you need additional help, flesh out your table structures.

-k

 

[sslab]

Hi,

Thank you for your prompt reply..
The database table structure used is:
Prodinfo (prodid, pic1, pic2) prodid is the primary key
Stdequip (prodid, type, desc) prodid is foriegn key that references prodid of Prodinfo
Stdfeature(prodid, type, desc)...its the same with this too..

Any help is appreciated...