Hi all, first post!
Ok i dont know if im just missing something obvious but i cant for the life of me get this to work. I basically have a report with a big query behind it. I have been trying to edit it in report builder so i can have drop down menus along the top so users can filter via manager name.
I have set a parameter up so it references the dataset and the particular column and i do indeed end up with a drop down list where i can select all or individual manager names.
The issue i have is no matter what i select once i refresh the report based on my selections it still returns all the data. Im not sure why its doing this and to be honest im a reporting services/report builder virgin so im learning this as i go along.
Things ive done/tried so far.
In the parameter settings ive pointed the available and default values to look at the dataset and column (for reference dataset is "Clearview" and Value field is "ProjMgr") Should the label field also be set as "ProjMgr" as thats what ive been doing?
Ive also tried creating an additional dataset with a simple query that retrieves all the data for that field. select
s.firstname+' '+s.lastname ProjMgr
and then pointing the parameter settings at this dataset instead. That still gives the same results.
If i add an additional where clause in my original query for a prompt and s.firstname+' '+s.lastname = (@ProjMgr)
i then just get a blank search field when i run the report and it does actually retrieve the correct data once i type in a manager name and refresh.
I just cannot get the report to show the appropriate results based on manager name when i select them from a drop down list. I must be missing something obvious but feel like ive tried all i can think of at present.
Sorry if i havent supplied enough detail. If anyone can help it would be much appreciated. I can then go on and add my drop down lists to the report then.