SQL Server 2005 - Reporting Services

[Sarvan AL]

Hi ALL, Is this the right place to ask "SQL Server 2005 - Reporting Services" related questions? If not, direct me to the right place. I'm new to MS-SS-Reporting Services. I'm able to create some reports. I just wanted to create a report like this with multi-level columns. Population Report C1, C2, C3....Cities

------------------------------------------------------------------
Country-1 | Country-2

State-1 | State-2 | State-3 |

C1 | C2 | C3 |

|    |    |
|    |    |

Is it possible in MS-SS-Reporting Services? If so, kindly let me know how to do. As of now, I'm able create like this:

----------------------------------------------
Country | State | City | Population

India TamilNadu Chennai ---
Trichy ---
Madurai ---
Coimbatore ---
-----------------------------------
Kerala Trivandrum ---
Cochin ---
Ennore ---
Kottayam ---

SriLanka *** *** ---

Thanks in advance, Sarvan AL

[Frank Kerrigan]

Yes it is fairly easy, You have to experiment with Matrix for report1 and use table for report2. You also have to learn how use the embeded "IIF" statement to get your layout right. It's all trial and errror and plenty of RTFM.

---

Blog Have I http:\\www.frankkerrigan.com

[Sarvan AL]

Hi Frank, Thanks for your suggestions. Since I'm totally new to MS-SS-RS, let me go through the manuals about "Matrix" report and embedded IIF statement, and come back. Thanks once again, Sarvan AL