Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Crystal Report from Epicor Tables

Crystal Report from Epicor Tables

Crystal Report from Epicor Tables

Hi guy's i'm rather new at SQL and Crystal Report's, My Company had a custom crystal report built from a guy that was in my position about 6 year's ago.  Recently the computer it was on crashed and it was not backed up anywhere.  I've looked everywhere for the file and the implementation steps and needless to say he was not the best at documentation.   I read a old closed thread that you guy's said it was quite easy to do this task.  I have taken two Crystal Classes which kinda gave me the run down on Crystal i understand it.  It's just finding the sql file or the table's to start the report.   I have a print out of the end result of the lost report which give's me some structure but where to look for table's is where i need some assistance with.  Any help would be much appreciated  

RE: Crystal Report from Epicor Tables


Could you let us know, what epicor software you are running and version. Also, the nature of the report. And how do you run it, from a menu etc.

RE: Crystal Report from Epicor Tables


Thank you so much for your reply, the version of epicor is 7.0b, the nature of the report is too be a customer log, when she clicked on the report link on her desktop a box pop's up for her to enter the salesman, customer code, and a date range. once this is done a report is generate into crystal reports then she would export it to excel.  any help would be much appreciated and some form of compensation could be worked out  

RE: Crystal Report from Epicor Tables

I also believe i have found the sql query the the original guy before me wrote for this, i did a query for it and it's pulling up information just like in the customer log i have printed out, now i just need to find where crystal report needs to connect to in epicor to pull these fields.  once again everyone any help would be much appreciated..


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close