I m working in vb6 n oracle n now preparing report using crystal report 8.5.
I designed report n add oracle tables with their links n it's working well......
Now I wanna add record-set of sql queries to display report as per user demands but how to n
where to write sql commands in crystal report n how can I execute them???
I'm totally blank plz help me.......
SQL = "SELECT A.*,C.*,B.LOC_NAME FROM ASSET_OPTION A,LOCATION B,ASSET C WHERE "
SQL = SQL + " C.LOC_ID=B.LOC_ID AND C.AID=A.AID AND ASSET_NAME LIKE " & "'%" & UCase(STR) & "%' AND BIT='FALSE'"
RS.Open SQL, CON, 1, 2