February 25, 2014 at 1:05 am
Hi, all
I'm getting this error on Dataset in SSRS while executing report on Preview :
<procedure or function has too many arguments specified >
even it runs OK from query designer, could it be some bug, I have exactly 2 params in sp and 2 params in rdl, 2 params in Dataset properties?
I'm totaly lost. I also checked Case and its match in rdl and sp.
One more time: it runs fine from query designer!!!
and sp_help sp_1000_Get_Mir shows me right number of params = 2.
Structure of my dataset is like this, so probably it come to question can I call sp from text pane for Datast like this:
create table #temp (c1....c2)
insert #temp
exec sp_1000_Get_Mir
select c1, c2 from #temp
February 25, 2014 at 7:22 am
Sounds like an issue with the number of parameters defined in the actual RDL file on the SSRS server, versus the number of parameters the procedure actually has (i.e. perhaps you have some parameters in the procedure that are default to NULL?
Can you please post your procedure and the parameters defined for the RDL?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 1:23 pm
No, everything is OK, number, datetime, case is the correct, and it rans OK from sql designer!!!!!
running
sp_help sp_1000_Get_Mir shows me all correct 2 params used in sp
February 25, 2014 at 1:38 pm
Running in the query designer is not the same as running it through the service (web browser)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 25, 2014 at 2:54 pm
Thansk, Jessie
Yes I got it, I finish with making sp1,2,3,4 for each of dataset even main portion for all of them is the same, hope it will run with buffer, as exec Plans for main query are the same.
Best
Mario
July 18, 2018 at 9:26 am
I realize this is an old post but I thought I'd share what might be a common pitfall because I just had the same issue.
By default, when you create a new project the default deployment setting for 'OverwriteDatasets' = False. So even though I had made changes to the report dataset and everything worked fine in the preview it would give me an error on the server. If you change this setting to True it will update your dataset on the server. Just be mindful if it's shared dataset you could break other reports that use it.
You can find this setting in Visual Studio under 'Project' -> '<project nane> properties'.
Cheers
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply