[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Crystal Reports

35K

Solutions

15K

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

crystal reports formatting
0
LVL 102

Expert Comment

by:mlmcc
Did you mean to ask a question
Start here
https://www.experts-exchange.com/askQuestion.jsp

mlmcc
0
OWASP: Avoiding Hacker Tricks
LVL 12
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

I am struggling to complete a formulation for calculating the expiration of data entered which depending on which database table they are in depends on their expectoration time, either 24hrs, 7days, 14days or 21 days.
If there isn't any withing that particular table then it will default to 14.
This is my so far attempt, but have gaps i know and it is so frustrating that I cannot get my head around it....If anyone can shed some light it would be gratefully appreciated.

@example = INT(Table.example/2) MOD 2 <> 0

Open in new window


If {@example} then 1
Else
(

If IsNull{table.NAME} then
14
Else if {table.NAME}= help then
7
Else if {table.NAME} = more help then
21
Else
14
) 

Open in new window

0
LVL 102

Expert Comment

by:mlmcc
You probably should ask this as a question as not all Crystal experts follow the posts.

There is a BLUE button for ASK
https://www.experts-exchange.com/askQuestion.jsp

Need more information as to when each length applies

mlmcc
1

Author Comment

by:Kev wood
Sorry didn't realise, thank you. I have now done what you have said.
1
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 102

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
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 102

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 67

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 102

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 23

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

35K

Solutions

15K

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.

Top Experts In
Crystal Reports
<
Monthly
>