Database Fields : Command

[TariqMehmod]

I prepare query in SAP while using HANA DATABASE

after preparing query I copy this query to Crystal Reports Command box

Now I go to crystal report, Field Explorer and get all fields which I have selected with command

Now my question:

Is it possible to add more fields in command?

 

[kray4660]

Yes. But of course you would have to follow the normal SQL rules. So initially any fields in the ORDR (ALIASED AS T0), RDR1 (ALIASED AS T1), and OITM (ALIASED AS T2) should be available. Any fields from other tables would have be joined.

 

[TariqMehmod]

Thanks,sir

 

[kray4660]

No unfortunately. I just pop in an try to give a quick answer when possible. I have a regular job and do not have time to assist beyond a few postings. Sorry, maybe someone else can assist.