Hi Chaim,

I think I understand now what you're trying to do.

Instead of labels in the report, use fields and IIF() expressions, eg

IIF(QueryType=1, "Report By Year", "Report By Something Else"

or else you could use variables which you could set prior to running the report. eg

cReportTitle = "Report By Year"
Report Form SomeReport

where you would have a field in the title band containing a variable cReportTitle.

As for the data fields, you could leave them unchanged but you should address their names in the SQL statement.

Regards,

Liam



>I did four reports and I used with Case... as you said before my quastion.
>My quastion was how can I do it with ONE report (something like this in the code: case optgroup=1 cfilter1='aaa',cfilter2='bbb'..., and to change the report fields and field names to veriables - it's not problem to do it with one group level, my problem was with two levels especially with the report fields names).
>Eventually - I think that it's big problem.
>Chaim