topic Re: report in Application Development and Automation Discussions

report

Former Member — Thu, 21 Jun 2007 07:34:41 GMT

Hi Guys,

I'm creating a report on history card, for the PM module, where in the selection screen i have fields like equipment no. functional location and date(only mandatory field).

Now the client wants that if in the functional location field if he enters a functional location then all the locations that come come under this functional location should be located.

I hope you people know that functional locations are maintained in a herarchy.

say for eg -- first INDIA then comes the name of states and then the cities under that.

so the clients want that if he selects india as the functional location then all the states and the cities should be selected.

And when he selects karnataka as the functional location thenall the cities under karnatak ashould get selected.

So how can this be done please help me urgently. its very important.

points would be awarded generously.

Re: report

Former Member — Thu, 21 Jun 2007 07:37:12 GMT

ask ur functional from which table u have to get all these data ?

Regards

Peram

Re: report

Former Member — Thu, 21 Jun 2007 07:41:42 GMT

First fetch all the Fun locations of the entered Fun location from the Table IFLOT

enter the given Fun location field as TPLMA (superiod fun location) and take all the TPLNR fields

You have to fetch all the related TPLNR's of the Superior ones

for one TPLMA you will get multiple TPLNR's from this table IFLOT

and put them in a range

and use that range table in select statement.

Reward points for useful Answers

Regards

Anji