>I'm messing with a report and am looking for some insight. I have the classic one-to-many type relationship and was wondering if there was a way to use a parameterized View for the "Detail Band" data. I'm able to get one record in the View to output, but I can't seem to "SET SKIP" to a view.
>
>Would I be better off just using "SET RELATION" to the base table instead, or in the case of a SQL-Server table creating a view that drags all the "Detail Band" data?
>
>I hope I gave enough info, and TIA
I think your problem is that you have the wrong table selected at the time you run the report. The detail section of a report is "driven" by the cursor selected when the report is run. If you need to show data in a related record as well, you should set a relation from the cursor that drives the detail into the other cursor. (Note: This is different from how the new multiple detail band reports work.)
Still, Hilmar's suggestion about creating a de-normalized cursor for the report is the solution I'd go with.