I'm new to SQL Reporting services and I think I'm close but can't seem to make it happen.
I am delevoping my report using Visual Studio 2005
I have a .RDL that looks like a paper form and the underlying table has two records in it
When I launch the report I can click on the next page button and the next record information is now in the form. That part is working perfectly.
In the form I have a "ParticipantID" field and in the underlying table I have a "ParticipantID" field (this field is the primary key)
I want to call the report using a URL
the following URL works perfectly
Now the problem...
What I really want to do is pull up the specific record by passing the "ParticipantID"
I thought it should be something like this ...
the url does not work as I hoped it brings the report up but brings me to my first record not record number 2
I am hoping some one can help me pull up ParticipantID =2