passing session variable to reportviewer

Bear in mind, I am really, really new at all this.  I have a database created using 2008 SQL Server Management Studio and am using Microsoft Visual Web Developer 2008 Express Edition to create a website.  Using gridview & detailview throughout this project. Datasources are configured using "where MasterId=session(RFQMasterId)". Individual pages are passed the MasterId    
        Me.SqlDataSource1.InsertParameters("MasterId").DefaultValue = Session("RFQMasterId")
        Dim iReturn As Int32 = Me.SqlDataSource1.Insert()
then passed page specific ID
        Dim sValue As String = Me.GridView1.Rows(Me.GridView1.Rows.Count - 1).Cells(1).Text
        Session("corrId") = sValue
to create new record.  May be edited using:
        Dim Row As GridViewRow = Me.GridView1.SelectedRow
        Session("CorrId") = Row.Cells(1).Text

I now have to create a report that ties all individual records to MasterId.  How do I set up my data set to return only the pages "where master id = session(rfqmasterid)" [the selected record]?  I then want to have report list selected main information & individual page ids that are tied to that masterid.  I want sub report to print all information on individual pages.

Can anyone point me in the right direction?  Any code or sql queries would be greatly appreciated!!
acs6699Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

acs6699Author Commented:
thank you
0
CodeCruiserCommented:
If I understand correctly, you need to use parameters.

http://www.codeproject.com/KB/books/InputParmReport.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
acs6699Author Commented:
Thank you.  I will try it & let you know how it turns out.  Problem is, I've been asked to put out some other fires
0
CodeCruiserCommented:
>I've been asked to put out some other fires
Happens most of the time in IT :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.