I am using kendo reporting v 11.x. and MS SQL Server 2016.
Firstly, I created a stored procedure that returns a list of person.
Then, I created a simple blank kendo report using visual studio 2017.
Inside the report, I then created a sqldatasource from the kendo reporting toolbox.
Lastly, I selected the stored procedure and dragged a table using the toolbox and then I opened data explorer dragged the field names from the data source.
Please take a look at the attached files.
When click the design tab as shown in the picture my procedure is called multiple times. I verified this by writing an insert query on my procedure. Everytime, I click the design time, I could see the data getting inserted multiple times
Alter PROCEDURE SpPersonSel
SET NOCOUNT ON;
INSERT INTO dbo.Test
'abc' -- Name - varchar(50)
SELECT p.* FROM dbo.Person AS p