Tips and Tricks: Problem on report

Print Page | Close Window

Problem on report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13333
Printed Date: 29 Apr 2024 at 3:44pm

Topic: Problem on report

Posted By: Almir.Plancic
Subject: Problem on report
Date Posted: 26 May 2011 at 3:10am

Hello to All

I have problem with crystal report.

I use SAP BUSSINES ONE with PPSONE ADDONE.

Now I want to create report in which I will see how much some employyes book hours.

When I do evrything what I want to have I have problem on crystal report because date of booked hours, how much employyes book hours and all other information are double.

Can someone help me with this?

How I can solw this problem?

Thanks in advance!

Replies:

Posted By: hilfy
Date Posted: 26 May 2011 at 3:53am

Go to the database menu in Crystal and turn on "Select Distinct Records". If that doesn't work and everything is always just doubled, you could create formulas that do your sums/counts and divide the results of each by 2.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Almir.Plancic
Date Posted: 26 May 2011 at 7:25pm

First of all thaks a lot for reply!

I try to select distinct records but that settings are not active.

What I need to do to activate it?

Thanks!

Posted By: Almir.Plancic
Date Posted: 27 May 2011 at 1:52am

I fix problem with grouping.

Thanks!

Print Page | Close Window