How to display parties in our required pattern? using sqlserver

Question

hi 2 all i have a one table in that we have 1)conforming party 2)seller 3)witness 4)purchaser my requirement is i want 2 display seller purchaser witneSS conforming party

Prabhu Raja · Answer

Hi As per i understood its about Select Query i think. Its simple and it depends on your Query. Select sellerpurchaser witness conforming party from yourtablename. If you want to display in crystal report. just create a procedure . and Use that procedure in your crystal report as a Datasource. and place fields in details band of the report.

Sam Hobbs · Answer

You say you want 2 display; which two do you want to display? Or is it supposed to be random?

Javeed M Shaikh · Answer

Is it just the order of display which you want to change and what is the basis i mean any other column or criteria?