Select an entire group based on one field in the group 1

[SROY0270]

My report has only one group - job number. I want the report to pull in all job numbers that have a ship date that I select but include all shipments for those job numbers as well. I think I would do this through group selection but when I do it the report only contains that date and not all shipment dates for those jobs.

 

[Turkbear]

Hi,
you can do it with a subreport; use a record selection formula for the main report that selects the job number for the ship date provided.
Group on the job number and, in the details for that group,insert a subreport and link by job number, to show all shipments for that job number.




PS: If you can find way to build a view or stored procedure in the datasource to handle that logic, it will be faster.

 

[synapsevampire]

To use the GROUP selection formula you might create a formula which has the following:

if {table.date} = {?dateparm} then
1
else
0

Now in the GROUP selection use:

sum({@formula},{table.group}) > 0

-k