Hello experts
I am wondering if it is possible to have more than one column joined together in a list.
I tell you what I am truing to do: I have a report; the data is sitting in a list, because I have to have totals at the bottom. I have bunch of benefits and each benefit has 5 columns, say: Critical Illness Volume/ Critical Illness Premium/ Critical Illness ABC/ Critical Illness CDF, then i have Basic life Volume/ Basic life Premium/ Basic Life ABC/ Basic Life CDF. is it possible to have one header on the top saying: Critical Illness and 5 columns below: Volume/ Premium/ ABC/ CDF?
I tried to insert table inside, but I have to have calculations at the bottom, so that didn't work.
I also tried to insert list inside of list, also didn't work, it splits everything so the report doesn’t even look like one entity.
Any ideas greatly appreciated.
LP
Hi Little Princess.
Yes, Report Studio can do what you want to do, but you basically have to build your own list header to contain your column titles.
Steps:
1) Select your "List" and set the "Column Titles" properties to "Hide"
2) From the top menu select "Structure" -> "List Headers and Footers"
3) Check "List Page Header" (this will add a row to the top of your list)
4) Select the List Page Header Row
5) From the top menu select "Structure" -> "Insert List Rows Cells Above"
6) Choose as many rows as you need (for example 2)
7) Delete the default List Page Header row
8) Select all the cells of your new header rows and set the Class (Global) to: List Column Title Cell
....then, merge cells ("Merge Cells" button) as you see fit for your report and add column titles as required.
cheers,
david.
this is awesome! it totally worked! thank you so much David!