I need to display output as shown below. In Col1, Col2 and Col3 I want to insert values from subqueries. But do not want to use sub-reports... is there any alternative to subqueries.
In Col1, Col2 and Col3 there can be any number of values.
Company
why don't you want to use a sub-report?
It takes very long time, because i have 17 columns in the report.. its not fisible to insert 15 sub-reports
||| Ah I understand, and agree. Not sure how else to implement this though...could you insert another table into your main table's cells?
Not resolved yet... any ideas...
|||One idea would be to build your data using a view. Capture the main data (Company, Bank, ID) and then capture each columns' data (based on the ID in first query). Select from the view.
I think your data would be more like:
ID Company Bank ManagerNames BranchOffices TopSalesNames
1 CompanyA BankOne Jerry, Ted, Lisa Omaha, Chicago Fred, Mary
2 CompanyB BankTwo Paul Lincoln, Springfield, Florence William, John
Not sure if this meets your needs. You may be able to format the multi-value rows once in the report. Hope this helps.
|||thanks... I will try this
