Hi,
I am using Oracle 11.2.0.1 on windows xp. After google for report writing tool, i think if i am able to get the output by either SQL or PL/SQL; then i think i need not to learn those new report writing tools; i will continue read Oracle PL/SQL and/or SQL. Here it is my required output :
=======================================================================================================================================================================
S.No. Customer Name & Address <-------------------Product Sold Description------------------> Qty Rate Amount
=======================================================================================================================================================================
1 Table1.CustomerName 1. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address1 2. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address2 <----Wrapable 3. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address3 4. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate Table3.Net_Amt
=======================================================================================================================================================================
2 Table1.CustomerName 1. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address1 2. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address2 <----Wrapable 3. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
Table1.Address3 4. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
5. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
6. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
7. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate
8. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rate Table3.Net_Amt
=======================================================================================================================================================================
3 Table1.CustomerName 1. Table2.Prod_Id Table3.Product_Name <-------Wrapable Table3.Qty Table3.Rat Table3.Net_Amt
Table1.Address1
Table1.Address2 <----Wrapable
Table1.Address3
=======================================================================================================================================================================
Wrapable Means If product name / Address2 are bigger than 30 characters, then they should be wrapped to next line.
If you says me to provide create table and couple of insert statements, i will provide, i am just mentioning the tablename.column name for what i wish to get from SQL, rather than learning the report writing tool and this will at the later stage will definitely a best option in view of 3rd party report writing tool.
Kindly help me, how do i get above output (if you need create table and/or insert statements) please.
Thanks.