I have 12(6input 6output) Store Procedures which give output in 6 type of Grouping like this 1; Quantity, Day, shift) 2: Quantity,Line,Day,Shift 4: Quantity, Type(ProductID),Day,shift 5: Quantity, Type,Line,Day,Shift 6: Quantity,Station,Day,Shift in the present Scanereo when i want to generate single report i have added subreports to take the output of all 12 store Procedures(6for input and 4 for output and 2 for BGrade) When i want to run the report i run 12 store procedure and during the report execution time the data entry become very slow so this report takes nearly 120 to 180 Seconds While the data Extracted by Store procedure 6 input give output of all above 5 Store procedures. So I want to run only 6th Store procedure which gives return in only in 10 to 14 Seconds. i have make Graphical View and prepare report but my admin people don’t want to show it in Graph so have to Show data like this as given below. i am try Trying to use Expression to extract the data but able to get only one output that total of one Day mean output of 1 Store procedure. Other reason is SSRS will get Data only one time not 6time to show results Is there any way we can sort data with respect to two or more condition like in Grouping and where if any person has some idea please help one I found in expression i.e. choose but could not go forward how to do. So needs experts help please Thanks in Advance.

View Will Represent like this In Put Data Put In process A-Grade Out Put Data Packing Quantity Day Shift A Grade Qty Day Shift 3786 2 Day2-C 3678 2 Day2-C Quantity Line Day Shift Quantity Line Lay Day Shift 172 LA 2 Day2-C 697 A 2 Day2-C 846 LC 2 Day2-C 653 B 2 Day2-C 170 LD 2 Day2-C 7 C 2 Day2-C 263 LF 2 Day2-C 626 D 2 Day2-C 170 LG 2 Day2-C Quantity Type Day Shift Quantity Model Day Shift 701 BC 2 Day2-C 519 B185 2 Day2-C 604 BC7 2 Day2-C 446 BE245 2 Day2-C B-Grade Qty Day Shift B Grade Qty Model No. Day Shift V 96 2 Day2-C 60 ZA220 2 Day2-C 36 ZE245 2 Day2-C

We will talk about this tomorrow in work