Go Premium for a chance to win a PS4. Enter to Win

x

Crystal Reports

34K

Solutions

14K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

Share tech news, updates, or what's on your mind.

Sign up to Post

I am trying to do a nested if statement in Crystal Reports.
I have 3 company names based on a company id, so if id=1 then "company A" if id=2 then "company B" else "company C" but I can't get it to work, I get an error when saving the formula that "The remaining text does not appear to be part of the formula" and it highlights everything after my first variable. Can anyone show me the proper syntax for this formula. I am completely new to sql
0
 
LVL 101

Expert Comment

by:mlmcc
You should really ask this as a question
https://www.experts-exchange.com/askQuestion.jsp

If  test then result
ELSE if test then result
Else result
mlmcc
0
New feature and membership benefit!
LVL 11
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

How do I link two tables that do not have fields that match exactly?  One has two fields, ABC and 123.  The other has 1 field with the data combined, ABC123.
0
 
LVL 101

Expert Comment

by:mlmcc
You will have to do it in the SELECT EXPERT or use a Crystal Command.

{Field1} & {Field2}  =  {Field3}

You really should ask a question.  Posts are for providing information

https://www.experts-exchange.com/askQuestion.jsp

mlmcc
0
 
LVL 66

Expert Comment

by:Jim Horn
Welcome to EE.  For starters I'd ask this as a question in the Crystal Reports zone (which Crystal experts will see and compete for points) and not as a post (which everyone sees).
0
need help

looking for help on a formula that will calculate the total Time off clock. what is the total time between clock out and clock in per day

                      ---Clock In---            ---Clock Out---                                                        
Clock In Date            Actual               Actual                                    
                                                                                    
                                                                        
08/14/17            7:13 AM            12:01 PM            
08/14/17            12:31 PM      3:29 PM      

thanks in advance for any assistance
0
 
LVL 101

Expert Comment

by:mlmcc
WHat have you tried thus far?

I suspect the issue is because you need data from 2 records.
You can loo at fields from the Previous and Next records

mlmcc
0
 
LVL 12

Administrative Comment

by:Andrew Leniart
Hi Kevin,

Welcome to Experts Exchange.

What you have done is made a "Post" here.  To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask a Question

The following link also explains more about asking for help at Experts Exchange...
http://support.experts-exchange.com/customer/portal/articles/336330

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0

Crystal Reports

34K

Solutions

14K

Contributors

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.