Hi,

I have created simple recipe structure that looks like this:

Attachment 161005

So I have "Recipes" and every recipe have "Steps" to make the food and also "Ingredients"

This is what it looks like:

Attachment 161007

Every recipe can have many steps to make it and also every recipe can have many ingredients.

So what I want to do is to have a report and every page of that report must show the information as in this form above. Meaning one recipe per page and on that page must display:

1- Recipe details
2- Steps
3- Ingredients

So I create tableAdapter and looks like this:

Attachment 161009

Code for tableAdapter:

Code:
SELECT        tblRecipes.*, tblIngredients.*, tblCookingSteps.*
FROM            tblCookingSteps INNER JOIN
                         tblRecipes ON tblCookingSteps.RecipeID = tblRecipes.RecipeID INNER JOIN
                         tblIngredients ON tblRecipes.RecipeID = tblIngredients.RecipeID
If I preview this it shows shows 112 rows (for only two recipes I have insert)

I am in rdlc designer and it looks like this:

Attachment 161011

Here I don't know what to do... I want two tables (tablix) + the recipe details per page..

Every recipe with details, steps and ingredients must show per page..

Can someone please help me?