Jump Query settings.

[#1]

Hi All,

I have a problem with jump query.

I want to execute a query based on Equipment say for ex. A.

3 materials are displayed say for ex. M1, M2 and M3.

User wants to see other equipments for the above 3 materials M1, M2 and M3.

I have created another query for displaying equipments based on materials.

Now i want to jump from the first query to the second query.

But i want to display the equipments for the materials only in the first report.

In our case M1, M2 and M3.

Please some body suggest.

[former_member181964]

Hi,

In the first Query, you drog and drop Material in rows and then restrict it with M1,M2 and M3 Materials only then your First report displays only M1,M2,M3 materials, if you click on M1 then it will takes to second report and there you can see M1 details.

How to restrict: Right click on Material in First report and the restrict, then select your materal from list.

Thanks

Reddy

[Former Member]

If i click on one material it will display only one material in the other report.

If i click on the material column then it is displaying all the materials which are not there in the first query also. I want only the materials which are there in the first report.