Section Style Subreports...

rbuser

Hi,
I have 2 questions regarding section style subreports:
1.) Let's say I have a report "A" with autosearch fields. Now I need to
create report "B" that would generate many "A" reports but with different AS
values. How can I make this provided that "B" report should iterate and pass
different values for AS fields of "A" report?
(The user wants to print a report which for example will generate all
invoice reports for the last few days.)
2.) Why can't I have subreport pipelines only? Let's say I load a new
subreport which has 5 pipelines. 4 of them are completely independent. But
when I actually try to load it, all of the pipelines are being overriden by
the main report pipeline which is being passed onto subreport.
In a subreport I want to obtain a value from the main pipeline and use it to
generate several other pipelines (using this value). But it seems that I
cannot do that.

Everything above is to be able to print several (same) reports (but with
different passed values for pipeline generation) by printing one single
report.

Can you help me with this?

Thank you,
MB.

digitalmetaphors

Hi Moisey,

1. You can parameterize a detail query to get a value when each subreport A
goes to print by using the main report's detail band before print event.
You'll have to prepare a pipeline on the main report B in order to print N
detail bands. When each detail gets a chance to print, it will get a new
query parameter and then subreport A will generate for the new dataset.

2. You can have subreport pipelines only. Are the pipelines assigned to
subreport when you save the report template? When you save a subreport, it
will save its pipeline reference and should restore it when it is loaded.
Are you talking about DADE dataviews or pipelines on a form? What do you
mean when you say all of the pipelines are overridden? If you load a report
template it will replace the datamodule dataviews. You should use the
LoadSubreport utility from the designer's File menu inside a subreport when
designing the subreport. When you load a sureport this way, it should load
the dataviews that are included in the subreports and merge them with the
main report's dataviews. You can also take more control and use DADE
datamodules. Think of them as templates for the Data tab, just as you would
save the layout to a report template. These are dtm files. You can also save
them to database and load/unload them in code if you want to. You should see
on the File menu of the Data tab there are three menu options for Import,
Export and Merge. These are the utilities to handle the datamodules in the
designer.

Cheers,

Jim Bennett
Digital Metaphors