August 21, 2014 at 1:27 am
maximum number of values or filters tha tcan be given is 1000. I know we can modify MaxHttpCollectionKeys to more than 1000. What is the max limit that can be given for this?
August 21, 2014 at 2:45 am
If you are going over 1000, there are some serious usability issues with your report...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 3:06 am
Yes, thats an separate issue/discussion; would be taken up later. Need a temp fix. Is there a limit? or can we give any values like 10K?
August 21, 2014 at 3:13 am
balasach82 (8/21/2014)
Yes, thats an separate issue/discussion; would be taken up later. Need a temp fix. Is there a limit? or can we give any values like 10K?
Googling around learns me that people have succesfully set it to a higher number then 10K, and that there is no known defined limit.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 4:40 am
This was removed by the editor as SPAM
August 21, 2014 at 4:50 am
jacksonandrew321 (8/21/2014)
U can use row-constructor syntax to solve your problem. Try pls
With replies like these, it's best you either supply an example or a link where one can learn more about your suggestion.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 21, 2014 at 5:12 am
okay. Thank you.
MSDN does not have a page for maximum specification like it has for database engine.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply