January 9, 2018 at 4:55 pm
Is it possible to split the tablix data into 2 parts. I have created two tablix -i want to display first half of the data in the first tablix and rest of the half in the second tablix. My dataset should be same. please help thanks.
January 9, 2018 at 7:41 pm
Is there a reason you want to split it? Are you splitting it on a value, or just trying to create a page break or something?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 11, 2018 at 10:29 am
jonathan.crawford - Tuesday, January 9, 2018 7:41 PMIs there a reason you want to split it? Are you splitting it on a value, or just trying to create a page break or something?
yes so as to reduce the number of pages in the report.
I am using the below formulas in the 2 lists that i have created that has same number of columns repeating. Is there any way to split the data based on the total number of rows and not to use the below formulas which shows odd rows in first and even rows in second table.i want to show first half of the total rows in first table and second half in second table.
=iif((rownumber(nothing) mod 2)=1,False,True) and =iif((rownumber(nothing) mod 2)=0,False,True)
January 11, 2018 at 11:34 am
It sounds like you want to use NTILE instead of MOD.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
January 11, 2018 at 11:59 am
drew.allen - Thursday, January 11, 2018 11:34 AMIt sounds like you want to use NTILE instead of MOD.Drew
When i replace then it fails with below error-
The Visibility.Hidden expression for the tablix contains an error: Overload resolution failed because no accessible 'IIf' accepts this number of arguments.
January 11, 2018 at 7:12 pm
can you post the formula you changed it to? Hard to troubleshoot the error if we can't see it
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
January 11, 2018 at 7:45 pm
Papil - Tuesday, January 9, 2018 4:55 PMIs it possible to split the tablix data into 2 parts. I have created two tablix -i want to display first half of the data in the first tablix and rest of the half in the second tablix. My dataset should be same. please help thanks.
bind them both to the same dataset, then use NTILE() to split the dataset into 2 parts. (filter for =1 for the first and =2 for the second)SELECT SymptomName
, NTILE(2) OVER (ORDER BY SymptomName) AS n
FROM dbo.Symptom;
Then just use the filter one for NTILE(2) = 1 and the other for NTILE(2) = 2
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply