I am very green with reporting in general.
I am using VS2013 to design a simple report.
- I created a report and a data source.
- I added a report parameter and a data source to show a list of available values.
1) How do I take the report parameter and tie it to my data source?
For example the data source is simple "SELECT * FROM BOOKS"
I would like to set up as "SELECT * FROM BOOKS WHERE BOOK_TYPE = [MY PARAMETER]"
I manually added the following to my SelectCommand for the data source
SELECT * FROM BOOKS WHERE BOOK_TYPE == Parameters.ReportCodeParam.Value
However that didn't work.
On the data source I also see a Parameters property. When I go to that property I don't see the parameter that I created on the report.