AdHooc Query

[Former Member]

I have to write a single adhoc query whose output will be two different reports.

One report should display pernr,perid, firstname, lastname, age, years of service, hire date,birthdate,

job title. The other should display pernr, firstname, lastname,hiredate, birthdate and department. So when first report is displayed the field department should be hidden and viceversa. Is it possible using adhoc query or custom report is better option. Any inputs will be highly appreciated.

Thanks

[Former Member]

I have to write a single adhoc query whose output will be two different reports.

One report should display pernr,perid, firstname, lastname, age, years of service, hire date,birthdate,

job title. The other should display pernr, firstname, lastname,hiredate, birthdate and department. So when first report is displayed the field department should be hidden and viceversa. Is it possible using adhoc query or custom report is better option. Any inputs will be highly appreciated.

Thanks

[Former Member]

Hi

If you have lot of coding part involved, you can try with data retrieval by program, when you create an infoset.. Or if you want to add a custom field you can do it in the infoset using any of the options like table joins, LDBs..

But I suggest you go with report if lot of coding is involved!

Thanks

Sushmitha