cancel
Showing results for 
Search instead for 
Did you mean: 

Making a special field, that selects from specific row and coloumn

0 Kudos

Hi people,

I've spend 6 hours now, trying to make a field which

selects from [Lines.No] = 1 - That is the row

and selects from [Lines.amount] - That is the column

and finally displays the number in that field times 1.25 (tax).

I'm a little used to SQL, but very new to crystal reports. I know the basics, but this is beyond me. It should be simple, but I'm throwing in the towel and asking you nice people for assistance. Please let me know if I need to explain my conundrum further.

Thanks.

moshenaveh
Community Manager
Community Manager

Welcome to the SAP Community. Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

I also recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

Should you wish, you can revise your question by selecting Actions, then Edit.

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond. Please consider revising your question because I'd really like to see you get a solution to your problem!

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

That being said, I would still like to know how to do it. It would really help with tax calculation. It's super easy to do in VBA and SQL. I feel like it should be easy in Crystal Reports too.

0 Kudos

Thx for the recommendations. I ended up finding another solution to my issue since I couldn't find an answer to my question.