Is anyone here really good with Crystal Reports or excel?

glen

Lifer
Apr 28, 2000
15,995
1
81
UPDATED:
** If anyone can look at a Crystal Report, please send me a PM.
Thank you so much! **
 

glen

Lifer
Apr 28, 2000
15,995
1
81
I want to know who sends us buisness and how much.
The information is in a program called prosoft.
We pull information out of it with Crystal Reports.
I can dump that information into Excel.
But, the formate is all messed up in Excell making it impossible to make charts or other useful information.
Would it be easier to modify the Crystal Report, the Excel data, or what?
 

glen

Lifer
Apr 28, 2000
15,995
1
81
seriously, is anyone good with it?
I think that is where we can get the information I need.
 
Jan 18, 2001
14,465
1
0
check your email. something is causing your export file to have negative dates...something Excel doesn't like.

 

Steve

Lifer
May 2, 2004
15,945
11
81
Several people in my building use Crystal Reports along with Excel. I could ask somebody something for you, let me know what you have in mind.
 

JulesMaximus

No Lifer
Jul 3, 2003
74,578
982
126
Originally posted by: glen
I want to know who sends us buisness and how much.
The information is in a program called prosoft.
We pull information out of it with Crystal Reports.
I can dump that information into Excel.
But, the formate is all messed up in Excell making it impossible to make charts or other useful information.
Would it be easier to modify the Crystal Report, the Excel data, or what?

I dump Crystal reports to Excel all the time. It sometimes messes up the column headers but that's it.
 

glen

Lifer
Apr 28, 2000
15,995
1
81
Ok, the Crystal Report is an rft file, correct?
The one they made for me gets the data I want, but then it hands it to me as 150 pages of data.
I want it to tell me who brings in the most money.
Can't Crystal do that pretty easily?
 

glen

Lifer
Apr 28, 2000
15,995
1
81
If anyone can look at a Crystal Report, please send me a PM.
Thank you so much!