I don't know how to display well enough here according to the guidelines of the forum. :crying:

I need to have [1] 2 groupings (group by zone and itemcode), [2] Totals( subtotal by each itemCode, and Grand total at the end of the tablix), [3]custom page break...

Because SSRS designing alone cannot fulfill my requirements. Of course I will be more than happy if I can design there to meet my report requirements. That's why I am...

Your result is giving me total of item and gross wt. I was applying inside my SSRS and cannot sort-by Zone, that's why I want to make a sort by...

hi again,

How can I make it sort-by Zone, I mean I want to have subtotal of each item, but wanna order ascending by Zone.

As in,

001/1 xxx1...

Thank you very much. Now it is resulting exactly what I want.:-):-):-)

Finally I can ,sort of , get it work. But not exactly what I want, yet.

When I run the query , I am getting the duplicate of subtotal by Products....

It will b better of with looking up UNION and UNION ALL first.

I really am not aware of importance of order in group by. Those are not intentionally order...

Sorry for all the confusion.:crying:

This is the final query which I make consistency in naming the columns.

Select * from

(SELECT Zone,ItemName, ItemCode, Quantity, GrossWeight

FROM ...

After changing the order of group by in inner query ,now it is running ok. But it is still showing error: Conversion failed when converting the varchar value 'TotalQ' to...

Sorry Quantity is the correct column name, misspelled.:-D

Select * from

(SELECT Dept,IName, ICode, Quantity, GrossWeight

FROM Data_Details

UNION

SELECT Zone,...