I want to get field value both from sub_table and main_table where sub_table contain forign key.

I have to group data on the base of sub_table primary key but at the same time I also have to get single field value from main_table. And grouping by mian_table's primary key can solve the problem by don't fullfill the requirements.

So, when I group by sub_table key and insert main_table field on report, it is to be repeated with each mapped row of sub_table.

Can I get rid from this problem.

Thanks