in crystal report want to display two detail feild in details section below first

[Azher Cybertech]

i have crystal report delivery in which i want display product list and hv done it bt i want to display returns product list below current product sale and adjust the amount from current amount to previous product return amount. also i would like to mention that data come from two tables of same dataset. i have tried to do that by adding two tables column name at detail field it shows record current product list but not all list of previous product list. is there any other way to solve this problem? thnks in advance :)

[Lost User]

You'll need a Sql-statement to fetch the data. Are you familiar with the "join"-keyword? If not, start there.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]

[Azher Cybertech]

thnks for ur suggestion. i hv Access database due to this have problem. yes i m familiar with join concept. bt i doesn't work for my requirement. is there any solution?

[Lost User]

Azher.Cybertech wrote:

yes i m familiar with join concept. bt i doesn't work for my requirement

I'm sure the examples don't work as-is. You'll need to write some Sql to gather the required results :)

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]