AdHooc Query

Former Member — Fri, 14 Nov 2008 05:02:47 GMT

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

Re: AdHooc Query

Former Member — Fri, 14 Nov 2008 06:40:44 GMT

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

topic AdHooc Query in Application Development and Automation Discussions

AdHooc Query

Re: AdHooc Query