July 7, 2008 at 7:19 am
Hello
I have a little problem, I have created a report which generates information which in include OrderID, and what i have done is to create a subreport, which links to the main report.
When a user clicks on the OrderID, it is supposed to retrieve the customer details linked to that OrderID, but what I get is the whole list of customers instead of the customer records linked to the OrderID on the main report.
Can anyone help?
July 7, 2008 at 8:07 am
Can you Post your Coding.
July 7, 2008 at 8:44 am
Is this in reporting services? Please post to the appropriate forum. I've moved it there, so post if it needs to be moved back.
If you want to pull data for a child report based on a parent, you need to pull all the data for all children and include the parent ID in your regular coding, or you have the sub-report call the procedure below and pass in the parent ID.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy