×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Database Fields : Command

thread149-1801589

Database Fields : Command

Database Fields : Command

(OP)
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?

RE: Database Fields : Command

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.

RE: Database Fields : Command

(OP)
Thanks,sir

RE: Database Fields : Command

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close