how to create a report that shows 1 page per main entity

[petercli]

hi,

I have a sql table with a master table M has id and  name . The details table D has a foreign key to M , and has a value.

How do i create a report that has one page per m.name, and shows the d.value ?

(My Db is more complicated but i am trying to get the general idea)

Thanks,Peter

[Greg_Deckler]

You would create a page for each M.Name. Name the pages for the M.Name that you want on that page. On the first page, put in your D.value in some sort of visualization. Once you get it the way you want (don't worry that it is for all M.Name at the moment), copy and paste it on the rest of your pages. Then, for each page, use the Page Filters area to filter for the correct M.Name that you want for that page.