August 3, 2011 at 4:22 pm
I am getting "GUID" parameter from storeproc , which is displayed on the report while report generation but the users dont want to see this "GUID" paramter on report when they render the report.So , I hide the parameter in report but I get an error as " Guid Parameter is missing".Is there any way other than deleting the parameter from storeproc?
August 3, 2011 at 5:40 pm
It sounds like that GUID parameter is required to pass to the proc. Is a NULL value permissible for that parameter?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 3, 2011 at 5:55 pm
Nope....Null is not allowed!!!
August 4, 2011 at 7:26 am
Does the GUID parameter have a default value?
August 4, 2011 at 8:24 am
No default value too!!
August 4, 2011 at 9:25 am
Is the GUID required to be a part of the stored proc call?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 4, 2011 at 9:38 am
I got it...I created another Dataset for Guid which is tied to Name and passed those values to GUID.:)
August 4, 2011 at 9:40 am
Good to hear
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply