>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
While I don't know your exact needs, it is usually simpler to prepare the data for the report in a single cursor. So, instead of a p-view, just use a SELECT - SQL statement that combines data from your two tables (for example). This query might include a filter to only include certain records.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
