0

all data displayed in stored procedure but not in SSRS report on internet explorer,2997 rows of data and stored procedure timing is 42 secounds. if filter is applied then working properly but if by default all is selected then can't display.

user7413238
  • 1
  • 4
  • Can you add a sample of the data, and add the query - otherwise we're working in the dark with what's causing your problem... – JonTout Nov 22 '18 at 14:18

1 Answers1

0

This sounds like a problem within the multi parameter within the stored procedure.

You will need to create a function on the server to split the comma-delimited string into values that can be used in “IN” clause or operator.

Example can be found at :enter link description here

SuperSimmer 44
  • 964
  • 2
  • 7
  • 12