Crystal Reports Report and Epicor 10

Yahoo Archive
1

That explanation is better than what I was thinking…I will look into that.  Thanks!  M

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, January 12, 2016 8:50 AM
To: Vantage <vantage@yahoogroups.com>
Subject: Re: [Vantage] Crystal Reports Report and Epicor 10

 

 

Crystal is really finicky with NULL values... my guess is that during one of those days a field that you use for joins was null and it was causing your dataset to freak out.



Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?

 

On Tue, Jan 12, 2016 at 7:47 AM, Manasa Reddy manasa.reddy@... [vantage] <vantage@yahoogroups.com> wrote:

 

Riddle me this Crystal gurus!

I have a Crystal report that shows Employee Efficiency on a weekly basis.  Worked great for 6 months.  Then for whatever reason, when I come across the week of December 5th I get nothing.  No data, nothing.  Of course I panic.  WTF I can pay my people (curse curse, sob sob), come to mind!  Of course we can pay but I cannot run my report.

Company doesn’t want the report anyway during the month of December so I figure I have time to fix this report.  I run it for last week and it still does not work.  In the process of rewriting the damn thing I notice that when I filter the labor records for anything greater than December 5th I get no data.  But if I run it for records greater than December 1st I get data from December 10th and over.  Then when I run it for records greater than November 29th, finally everything comes through including the records for the first 10 days of December.

Has anyone ever seen that?  What would cause it?  How to fix it?  Yes I also will be calling tech support but I thought I would run this past you guys first.

Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
2

Riddle me this Crystal gurus!

I have a Crystal report that shows Employee Efficiency on a weekly basis.  Worked great for 6 months.  Then for whatever reason, when I come across the week of December 5th I get nothing.  No data, nothing.  Of course I panic.  WTF I can pay my people (curse curse, sob sob), come to mind!  Of course we can pay but I cannot run my report.

Company doesn’t want the report anyway during the month of December so I figure I have time to fix this report.  I run it for last week and it still does not work.  In the process of rewriting the damn thing I notice that when I filter the labor records for anything greater than December 5th I get no data.  But if I run it for records greater than December 1st I get data from December 10th and over.  Then when I run it for records greater than November 29th, finally everything comes through including the records for the first 10 days of December.

Has anyone ever seen that?  What would cause it?  How to fix it?  Yes I also will be calling tech support but I thought I would run this past you guys first.

Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
3
Crystal is really finicky with NULL values... my guess is that during one of those days a field that you use for joins was null and it was causing your dataset to freak out.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, Jan 12, 2016 at 7:47 AM, Manasa Reddy manasa.reddy@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

Riddle me this Crystal gurus!

I have a Crystal report that shows Employee Efficiency on a weekly basis. Worked great for 6 months. Then for whatever reason, when I come across the week of December 5th I get nothing. No data, nothing. Of course I panic. WTF I can pay my people (curse curse, sob sob), come to mind! Of course we can pay but I cannot run my report.

Company doesn’t want the report anyway during the month of December so I figure I have time to fix this report. I run it for last week and it still does not work. In the process of rewriting the damn thing I notice that when I filter the labor records for anything greater than December 5th I get no data. But if I run it for records greater than December 1st I get data from December 10th and over. Then when I run it for records greater than November 29th, finally everything comes through including the records for the first 10 days of December.

Has anyone ever seen that? What would cause it? How to fix it? Yes I also will be calling tech support but I thought I would run this past you guys first.

Manasa

Â

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited. 

</div>
 


<div style="color:#fff;min-height:0;"></div>