Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

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

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
On Demand Webinar: Networking for the Cloud Era
LVL 10
On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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.

Top Experts In
Crystal Reports
<
Monthly
>