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.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply