subhash5678
Programmer
Hi Folks,
I need help in creating complex report. I have a view whose result set is similar to the view looks like the following:
ReportType Sales Profit Item# ItDetails Customer Item# Qty
------------------------------------------------------------
SalesReport 100 10 null null null null null
ItemDetails null null 1 blah1 null null null
ItemDetails null null 2 blah2 null null null
ItemDetails null null 3 blah3 null null null
CustPurDetails null null null null Brian 3 5
From the above result set, reportType describes each subreport in one IMR. Basically I have to create 3 reports from above result set. Each sub-report should appear on new page. Each of the ItemDetail should appear on different page. I am really having tough time to create this report.
Can anybody help me to solve this puzzle.
Thanks you very much in advance,
Subhash.
I need help in creating complex report. I have a view whose result set is similar to the view looks like the following:
ReportType Sales Profit Item# ItDetails Customer Item# Qty
------------------------------------------------------------
SalesReport 100 10 null null null null null
ItemDetails null null 1 blah1 null null null
ItemDetails null null 2 blah2 null null null
ItemDetails null null 3 blah3 null null null
CustPurDetails null null null null Brian 3 5
From the above result set, reportType describes each subreport in one IMR. Basically I have to create 3 reports from above result set. Each sub-report should appear on new page. Each of the ItemDetail should appear on different page. I am really having tough time to create this report.
Can anybody help me to solve this puzzle.
Thanks you very much in advance,
Subhash.