tag:blogger.com,1999:blog-21895954.post532335975599852800..comments2023-10-11T01:39:25.473-07:00Comments on Andrus Development: SSRS: Saving User Settings from the ReportWilliam Andrushttp://www.blogger.com/profile/03485818134703783587noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-21895954.post-17758799203158816232018-01-11T21:52:07.788-08:002018-01-11T21:52:07.788-08:00Anonymous said...
"Hope I am not too late. Ho...Anonymous said...<br />"Hope I am not too late. How did you get a stored proc to run when you refreshed the report?"<br /><br />Just create a new dataset, set the query type to 'Stored Procedure'.<br />It doesn't have to return fields.<br />It will run when 'View Report' is clicked.<br /><br />Cheers,<br /><br />LukeLukenoreply@blogger.comtag:blogger.com,1999:blog-21895954.post-55890189819584207792017-03-30T13:45:07.407-07:002017-03-30T13:45:07.407-07:00Hope I am not too late. How did you get a stored p...Hope I am not too late. How did you get a stored proc to run when you refreshed the report?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-21895954.post-20914897906538623422015-10-01T14:10:11.590-07:002015-10-01T14:10:11.590-07:00marvy! just what I was looking formarvy! just what I was looking forbrainnoreply@blogger.comtag:blogger.com,1999:blog-21895954.post-22011046310309710372015-03-05T11:09:57.430-08:002015-03-05T11:09:57.430-08:00That did it, thanks very much!
That did it, thanks very much! <br />Lianehttps://www.blogger.com/profile/04838821494930801532noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-37369125150041183482015-03-05T00:37:21.182-08:002015-03-05T00:37:21.182-08:00Move the Parameter up (using arrows) on VS.Move the Parameter up (using arrows) on VS.Guynoreply@blogger.comtag:blogger.com,1999:blog-21895954.post-66405297457919845802015-03-04T11:59:20.319-08:002015-03-04T11:59:20.319-08:00Hello, thanks very much for this great suggestion!...Hello, thanks very much for this great suggestion! I'm attempting to implement this and getting stuck with the query to determine the default values. It works well enough when I'm just selecting a row based on the ParameterName, but when I try to limit the query based on @UserID I am told that "forward dependencies are not valid" (which I suppose makes sense before the report is even run). <br /><br />I know it's been a while, but do you happen to know how you worked around this issue?Lianehttps://www.blogger.com/profile/04838821494930801532noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-73856674083845885082014-10-01T08:52:00.708-07:002014-10-01T08:52:00.708-07:00It's been awhile, but looking at the image of ...It's been awhile, but looking at the image of the values stored in the database (row #6), I was saving the values as a comma separated value. <br /><br />I was probably using a table value function that converts the values into table. I have used a function such as: <br /><a href="http://andrusdevelopment.blogspot.com/2010/11/sending-multivalue-from-ssrs-to-stored.html" rel="nofollow">http://andrusdevelopment.blogspot.com/2010/11/sending-multivalue-from-ssrs-to-stored.html</a><br />William Andrushttps://www.blogger.com/profile/03485818134703783587noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-39757614737179076052014-10-01T06:48:09.874-07:002014-10-01T06:48:09.874-07:00Thanks so much for posting this. How would you for...Thanks so much for posting this. How would you format the proc if you were needing to save a multi value parameter? For example, I need to save a parameter that has a drop down list with a select all option. ThanksAnonymoushttps://www.blogger.com/profile/06087435339008853754noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-36456822480340277472013-07-22T07:45:23.528-07:002013-07-22T07:45:23.528-07:00It's great. I want to ask you one thing. I wan...It's great. I want to ask you one thing. I want to insert one button called Save Report in SSRS parameter area (ex. below view report button) and save report parameters on that button click instead of view report. How is it possible?Anonymoushttps://www.blogger.com/profile/15620709013443779897noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-60100378732050166902012-08-23T10:15:34.410-07:002012-08-23T10:15:34.410-07:00Hey i am my very first comment on your site. ,I ha...<br />Hey i am my very first comment on your site. ,I have been reading your blog for a while and thought I would completely pop in and drop a friendly note. . It is great stuff indeed. I also wanted to ask..is there a way to subscribe to your site via email?<br /><br /><a href="http://www.mdcovered.com/" rel="nofollow">ASC Coding</a> Anonymoushttps://www.blogger.com/profile/15775790947891705884noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-68396683103374300302012-06-07T11:58:53.956-07:002012-06-07T11:58:53.956-07:00In the parameters, default values section you have...In the parameters, default values section you have the option to specify values or get values from a query.<br /><br />You select "Get values from a query", which will ask you to select the Dataset and Value field. <br /><br />In this case I have the dataset setup to query the table based on the userid and set the default values.William Andrushttps://www.blogger.com/profile/03485818134703783587noreply@blogger.comtag:blogger.com,1999:blog-21895954.post-23566661901875138372012-06-07T10:11:41.383-07:002012-06-07T10:11:41.383-07:00How do you load the parameter defaults from the ta...How do you load the parameter defaults from the table into SSRS as the report is loaded?Davidhttps://www.blogger.com/profile/00104149218384019315noreply@blogger.com