Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Crystal report from .csv file Post Reply Post New Topic
Author Message
xhp95
Newbie
Newbie
Avatar

Joined: 20 Feb 2007
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote xhp95 Replybullet Topic: Crystal report from .csv file
    Posted: 20 Feb 2007 at 2:39am
I need to create a report from data in a csv file the contents of which is given below.   I want to be able to arrange this in columns as follows:
 
Day     Nov-06      Day   Dec-06    
1        <blank>     1        0.00
2       <blank>      2        0.00
..        <blank>     ..        0.00
20      <blank>    20      10.00
29       0.00         ...
30       0.00         ...
31       <blank>   31      10.00
 
Reading the data from below and having stripped out the text from .. Market Card Results .... Stock: 0.00. 
 
I found this rather daunting not having wrote a crystal report from csv file before.  
 
Any help will be much appreciated
 
thanks
xhp95
 
 
Market Card Results
Daily Breakdown - Total AH/USD (LME): Forward FX Position,  Shown in Lots and Square Card.  All physicals are included.
Stock: 0.00
Day,Nov-06 Cum Pos
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16,
17,
18,
19,
20,
21,
22,
23,
24,
25,
26,
27,
28,
29,0.00
30,0.00
31,
Total,
Day,Dec-06 Cum Pos
1,0.00
2,0.00
3,0.00
4,0.00
5,0.00
6,0.00
7,0.00
8,0.00
9,0.00
10,0.00
11,0.00
12,0.00
13,0.00
14,0.00
15,0.00
16,0.00
17,0.00
18,0.00
19,0.00
20,10.00
21,10.00
22,10.00
23,10.00
24,10.00
25,10.00
26,10.00
27,10.00
28,10.00
29,10.00
30,10.00
31,10.00
Total,

 
xhp95
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Feb 2007 at 10:04am
Crystal Reports prints from CSV files by using the Access/Excel option of the data source dialog box. Click on it and then on the file type, at the bottom will be listed Text files. Use that to print from your file.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
xhp95
Newbie
Newbie
Avatar

Joined: 20 Feb 2007
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote xhp95 Replybullet Posted: 20 Feb 2007 at 10:18am
Thanks.  But what I am looking for is to arrange the data into columns as shown in my original enquiry.  
xhp95
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Feb 2007 at 10:43am
Oh I see. This is the ACTUAL text file you'll be importing. Well, it's a pretty screwed up data file. Can you massage the data at all? In the current format, it would take a while to play around with it to get what you want. I would look at customizing the SQL statement to re-order the data in the way you need. I haven't done this for a CSV file before so I can't say the exact method to do such a thing. If you're new to CR, then this might be pretty challenging. Your best bet is to see if you can rearrange the data before importing it into CR like this. As it is, it's not an easy task.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
xhp95
Newbie
Newbie
Avatar

Joined: 20 Feb 2007
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote xhp95 Replybullet Posted: 21 Feb 2007 at 1:06am
Thanks.   I dont have access to the sql that generates this file.  I could reorganise it in excel but that would be an added step in the process - someone has to do that first before importing into cr and then running cr.
 
I'm looking at other alternatives.
 
thanks
 
xhp95
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.