May 18, 2017 at 3:40 pm
I have three tablix . When i export to excel. First tablix shows in first tab and remaining all three need to be grouped and shows on same tab
If you see the below attachment. I was able to get first tablix in one sheet (excel) and second on secondsheet. But i am adding all the remaining to same second sheet . How can i do it?
May 19, 2017 at 10:47 am
komal145 - Thursday, May 18, 2017 3:40 PMI have three tablix . When i export to excel. First tablix shows in first tab and remaining all three need to be grouped and shows on same tab
If you see the below attachment. I was able to get first tablix in one sheet (excel) and second on secondsheet. But i am adding all the remaining to same second sheet . How can i do it?
I will re-phrase the question. I have 3 tablix in a report. I want one on one sheet and the 2 , 3 tablix results on the 2nd seheet. how is this possible?
Example i have Tablix one name : TABLE A ----this goes to sheet1
2) Tablix B and Tblix C ------data goes to sheet 2,3,4.......etc Tablix b and tablix C has a common column called "Competitor" example : APPLE , SAMSUNG.
SHEET A = SUMMARY ( TABLIX A)
I wanted to show data from two different tablix on sheet B ( SHEET B = "APPLE" DATA( DATA FROM TABLIX B AND TBALIX C) ) , (SHEET C=SAMSUNG DATA ( DATA FROM TABLIX B and TABLIX C)
May 22, 2017 at 5:46 pm
If you put a page break after Tablix A, it should render on the first excel sheet and the others should be on the second.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply