March 12, 2009 at 6:02 pm
This is a simple stored proc.
CREATE PROCEDURE [dbo].[usp_rpt_report1]
(@col1 varchar(8))
AS
SELECT col1 FROM mytable
GO
mytable :
[col1] [col2]
ABC 23
ABC 56
DEF 33
FR 453
When from sql server reporting services I pass ABC as the parameter it is returning all the rows and not just
ABC 23
ABC 56
Thanks
March 12, 2009 at 6:15 pm
Id's need screen shots of both Report Parameters and the script and Parameters tab for the dataset to be sure but I'd guess that you have defined the parameters for the report but they are not being applied to the dataset
[font="Arial"]_______________________________________________________
Change is inevitable... Except from a vending machine.[/font]
March 13, 2009 at 6:48 am
In your example code, you do not have a where clause in your query. No where clause means all rows returned.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply