- SAP Community
- Products and Technology
- Technology
- Technology Q&A
- Help please!
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Help please!
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 09-27-2007 8:53 PM
Post Author: hd1
CA Forum: Crystal Reports
I have a report that sorts by three parameters. The first one is a matter number relating to clients, the other two are beginning and end date. The report runs great except for one thing, it doesn't filter out the dates. It will sort out all of the other information which is good. For example, I run my report and enter in the information and when the report is done it will give me the matter number with the attorneys and show fees, costs, rates, etc. The problem is that it adds up everything not the information I would need from 1-1-2007 to 6-1-2007, or whichever date I desire. My tables are linked correctly, so I'm not sure what is going on. Could some please help?
- SAP Managed Tags:
- SAP Crystal Reports
Accepted Solutions (0)
Answers (14)
Answers (14)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: SKodidine
CA Forum: Crystal Reports
What are your input date parameters? 1/1/2007 and 06/01/2007? If yes then beware that the program will only fetch records up to and including June 1, 2007. If the timecard had dates in june other than the first then they will not be picked up. Could that be the issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
I checked with my accounting person and she said that the employee MOR entered a timecard in June for that matter. She said that somehow the report is excluding the month June when it runs the report. Does that help?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: SKodidine
CA Forum: Crystal Reports
Since it is only this one employee's info that is incorrect, now for more details.
What are the parameters used? For this one employee how many records are fetched and individually check each record fetched to see if the begin and end dates fall within the parameters.
"What the Report Should say
Total Hours Total Dollars Average Rate Most Recent Rate
MOR 23.80 5355.00 225.00 225.00"
List all the records and dates. I am sure one or two records don't match the parameters.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
Here goes....
There is only one employee off, everyone else is fine.
What the Report Should say
Total Hours Total Dollars Average Rate Most Recent Rate
MOR 23.80 5355.00 225.00 225.00
What it is Currently Saying
Total Hours Total Dollars Average Rate Most Recent Rate
MOR 22.70 5107.50 225.00 225.00
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: JKitz
CA Forum: Crystal Reports
Sorry, you are absolutely right, I missed the database end date. The original formula was correct using <= and >=. Not sure why the result would not tie out. Can you paste in some of the results with both correct and incorrect data (maybe highlight the incorrect data)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
Sorry for not getting back sooner, work got crazy. Thanks for your repsonses, I appreciate the help.
{timecard.tbillhrs} <> 0.00 and{matter.mmatter} = {?Matter} andDate({periodt.pebedt}) in {?Beginning Date} to {?End Date}
Enter this formula increased my results quite a bit, so I wouldn't be able to use this one, the other one said "A date is required here" {periodt.pebedt}
Not sure what that meant. I asked the account person and they were looking up my results and were saying that somewhere in my selection criteria, it was leaving something out. They weren't sure if it was the beginning month or the end month. So maybe just modifying the selection somehow.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: SKodidine
CA Forum: Crystal Reports
JKitz:
HD1 has a DB begin date and a DB end date. With your suggestion, he would only be checking to see if the begin date is between the parameter dates. What about the end date?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: JKitz
CA Forum: Crystal Reports
Use this selection instead:{timecard.tbillhrs} <> 0.00 and{matter.mmatter} = {?Matter} and{periodt.pebedt} in {?Beginning Date} to {?End Date}Also make sure that {periodt.pebedt} is not a DateTime field. you can change you selection to:{timecard.tbillhrs} <> 0.00 and{matter.mmatter} = {?Matter} andDate({periodt.pebedt}) in {?Beginning Date} to {?End Date}Just in case. Probably not the case, but worth a shotAnd please post some data for us and we can figure it out
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: SKodidine
CA Forum: Crystal Reports
For your previous post the answer is YES. Now for this one, post some data that you think is wrong so that we can get a better understanding.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
its working, but some data just doesn't add up. On some of my numbers I'm off a few digits, what could cause that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
FANTASTIC! I guess the way I had it the first time confused it. It's that programming experience you have isn't it. 😄 Thanks again! So is it saying {periodt.pebedt} >= {?Beginning Date} is greater than or equal to and {periodt.peendt} <= {?End Date} is less than or equal to?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: SKodidine
CA Forum: Crystal Reports
The trouble might be because you are equating to the begin and end dates, which will force it to fetch only if the date matches. Try this:
{timecard.tbillhrs} <> 0.00 and{matter.mmatter} = {?Matter} and{periodt.pebedt} >= {?Beginning Date} and{periodt.peendt} <= {?End Date};
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: hd1
CA Forum: Crystal Reports
I checked the data fields and the dates are the same format 1/1/2007, so they match up. When I created the parameters I just dragged them in the report. Now I put them in the record selection along with my others like so:
{timecard.tbillhrs} <> 0.00 and{matter.mmatter} = {?Matter} and{periodt.pebedt} = {?Beginning Date} and{periodt.peendt} = {?End Date}
But now when I enter my dates I don't get a blank report. But when I remove them, my data comes back.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Report Inappropriate Content
Post Author: palm
CA Forum: Crystal Reports
HI,
Check these , in the RecordSelection formula see whether you filtering on start and end dates
If you already have those in , then the problem might be compatability of the format of the date in calander and in the database date field
If they dont match then the date condition fails in recordselection and it dont filter on the date and you wont get the total in that date range
Update me!!!!!!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- print open lines sales order sap b1 using crystal report in Technology Q&A
- Onboarding Users in SAP Quality Issue Resolution in Technology Blogs by SAP
- Error while HANA Cloud tenant in Python on SAP HANA Cloud in Technology Q&A
- Moving a part of existing "On-Premise ECC" to "SAP S/4 HANA Cloud" in Technology Q&A
- Hi, we are getting below error javax.net.ssl.SSLHandshakeException: sun.security.validator.Validator in Technology Q&A
| User | Count |
|---|---|
| 85 | |
| 10 | |
| 10 | |
| 9 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.