BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Using a .csv datasource that contains no header row


 
Search this topic... | Search Crystal Reports... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Author Message
stephiek04
Forum Member
Forum Member



Joined: 13 Aug 2019

Posts: 1



PostPosted: Tue Aug 13, 2019 8:18 am 
Post subject: Using a .csv datasource that contains no header row

I have a report built using an ODBC connection to our ERP system database. I need to include additional information that is only contained in a .csv file. The .csv file has records created automatically by a scale on our production floor to capture the unit's weight.

The .csv file is comma delimited and contains no header row.

Is there a way to create a connection in Crystal for this scenario? When I try to create the table links, it treats the .csv as if there is only one data column since the file is in a delimited format and not in separate columns.

I have even saved my .csv after putting text to columns and adding header rows (just to see if the join can be made) and Crystal does not allow me to link my database table to the .csv. I click to "Start Link" but when I select the field I want to link to, the "End Link" option is grayed out.

Any help would be very appreciated.
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 285



PostPosted: Tue Aug 13, 2019 12:48 pm 
Post subject: Re: Using a .csv datasource that contains no header row

May be below link will be helpful:

https://answers.sap.com/questions/4216938/a-way-to-import-csv-files-into-crystal.html
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Crystal Reports  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0267 seconds using 17 queries. (SQL 0.0023 Parse 0.0008 Other 0.0236)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo