ssrs query, subreport situation

I'm attempting to link an embedded subreport to my main report.  the table which the subreport comes from is connected via a relation table to the mortgage table which is my main report.   I'm attempting to use a parameter on the subreport of mortgage.loannumber which is connected to the relation table and then in the relation table, the nameaddrcd is connected to the nameaddr.nameaddrcr table.  Hoepfully I explained that well.  I keep getting errors when i run it, so I'm trying to create a third dataset and my code is.

SELECT loannumber
FROM mortgage inner join
             relation ON mortgage.loannumber = relation.loannumber AND nameaddr.nameaddrcd =  relation.nameaddrcd

Hopefully this is possible and i'm somewhat going in the right direction.
thanks and have a good one.

tomscottAsked:
Who is Participating?
 
GKaloskyConnect With a Mentor Commented:
This page should tell you what you nned to know about passing the parameter to the subreport.

http://msdn.microsoft.com/en-us/library/ms160348.aspx
0
 
planoczCommented:
The subreport is really just another report that runs with the first report.
Most of the time you just pass a parameter from the main report to the subreport and then it runs using your parameters that you passed. Ideally if you can use a Stored Procedure to do all the work on the SQL side then the reports just print out the answers.
What are you looking for in your question above? I am not sure of what you need from the EE group.
0
 
tomscottAuthor Commented:
How do I make the parameter roll over to the subreport. I started off trying that but it keep erroring. Thanks
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
scorneoCommented:
I dont know much about ssrs query. But there will be a way of passing parameter while configuring report. Or you may create a link with query parmaters like ?loannumber=23
0
 
scorneoCommented:
0
 
planoczCommented:
Look in the subreport properties on the main report. Ther is a parameters property there.
Click and add your parameter there that is going to be passed to from the main report
0
 
tomscottAuthor Commented:
while it helped me get closer to a solution, I still am having problems with what I'm trying to do, I think it might be my fault in the way I'm trying to explain what I'm trying to accomplish.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.