I have Account_Number,Subscriber_Name,Paper_Publication_code,Rate in my report. I am calculating the totals at the end of rate column. Here there is a small business requirement. Actually Paper_Publication_code range from 1 to 100, 1 to 50 is triumph publications and 50 to 100 is stung publications. Every account number(i.e subscriber) is subscribed to both triumph publications and stung publications. Business wants to see triumph publications and stung publications in separate tables for a particular account(i.e subscriber). For example model should be like this : Account:13345 triumph publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate stung publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate Account:245654 triumph publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate stung publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate I created two separate tablixes but it was displaying like, first all the triumph publications second all the stung publications. Account:13345 triumph publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate Account:245654 triumph publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate Account:13345 stung publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate Account:245654 stung publications Account_Number,Subscriber_Name,Paper_Publication_code,Rate Some please help me with this. Please tell me the steps if there any settings in the SSRS. svk

Hello SVK, You can create the format with one tablix. you just need to do a parent child grouping. first group on Account as the parent grouping and then group on Publication Decription. I did it in my sample and its shows as below Account Publication Desc Subscriber_Name Paper_Publication_code Rate 13345 triumph Publications 13345 A 1 100 Stung Publications 13345 A 51 100 245654 triumph Publications 245654 B 2 200 Stung Publications 245654 B 52 200 Please let me know if the above format suits your requirement. HTH, RamRam

You are correct but i want the subtotal for triumph publications and stung publications for a particular account. Just for your clear understanding there many sub-publications under triumph publication and Stung publicaition. So i need a sub-total of all those publications. Thanks for your reply.svk