Skip to Content
author's profile photo Former Member
Former Member

using a formula to derive a group name

I'm creating a Crystal Report (version 2016) similar to an existing one but I don't know how it used the formula to create the group name.

This is its screenshot.

In the above pic, the group name is "@ObjectName" and the Formula Field is named "ObjectName".

So I tried to mimic this setup by first creating a formula field and using that same code. But it erred with no clear reason why.

Just a message saying an error occurred. Below is my attempt at recreating this setup.

Also note that the syntax highlighting is missing on the keywords: Dim, as, Number, String and Formula!

Thanks for any advice.

Aaron

orignal.PNG (66.4 kB)
groupname1.PNG (49.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 26, 2016 at 01:57 AM

    Hi Aaron,

    In the formula that throws an error, look for a drop-down on the top that reads 'Crystal Syntax'.

    Change that to 'Basic Syntax' and the formula should work fine,

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2016 at 04:48 AM

    Hi Aaron,

    If you look at second screen, on top you have selected 'Crystal Syntax' it should be Basic Syntax.

    Thanks,

    Sastry

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2016 at 12:32 PM

    DOH! <smh>

    Thanks, Abhilash!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.