Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yvonneNZ
Starting Member
2 Posts |
 Posted - 2011-05-09 : 17:18:58
|
| This report gives yearly KPI data for a qualification enteredThere are three tablix each with the same type of data output but by descending year (and changes in query hence the requirement for different datasets) and therefore have the same headings. Only the top matrix shows the headings for 2009; 2010 - 2011 have hidden headings, so when there is data for all years, output appears under a single heading line.The trouble I am having is sometimes 2009 has no data and that means no HEADINGs appears for 2009 AND therefore nothing shows above 2010 and 2011There is not a possible 'year' option I could use that would guarantee a display of the headings when a qualification is selected and there are often missing years.How do I 'fix' the headings so that they are displayed regardless of the availability of underlying data please |
|
|
syedathariqbal
Starting Member
3 Posts |
Posted - 2011-05-11 : 16:30:17
|
| Can you please send a screenshot for both the cases?Athar IqbalConsultantMSBI |
 |
|
|
|
|
|
Tablix Headings