Welcome, Guest
Username: Password: Remember me

TOPIC: Crystal report export into CSV

Crystal report export into CSV #1510

  • be05x5
  • be05x5's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 123
  • Thank you received: 2
  • Karma: 0
I am not sure if this is an event manager issue or a crystal report issue but export from a crystal report into a csv (comma separated values) exports all of the header information on every single line over and over again...

Does anyone know how to set things up so that this is not the case? I only want the header information exported once as the top row...
Thanks
The administrator has disabled public write access.

Crystal report export into CSV #1514

  • dgillz
  • dgillz's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
If you export from Crystal itself independent of event manager do you get the same results? What version of crystal?
www.gainfocus.biz
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
The administrator has disabled public write access.

Crystal report export into CSV #1515

  • be05x5
  • be05x5's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 123
  • Thank you received: 2
  • Karma: 0
Yes I do. Version 10 of Crystal running on the Event manager.
However, I did a workaround that I found online by doing some groups and hiding all the headers. In this case export from Crystal worked fine but from Event manager it was still exporting all headers for each line.
Then I ended up using a formula for each field and if row number was 1 I printed header else data... Very tedious and time consuming so i would like to fix this if there is a way.
The administrator has disabled public write access.

Crystal report export into CSV #1574

  • mmccarty
  • mmccarty's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 17
  • Karma: 0
We purchased Grid UFL from krystal keen. It allows you to export formatted data from Crystal to Excel. I am having trouble making it work through Event Manager, however. If anyone else is using this product with Event Manager please let me know.
The administrator has disabled public write access.

Crystal report export into CSV #1575

  • dgillz
  • dgillz's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 395
  • Thank you received: 14
  • Karma: 6
Event Manager has its own embedded crystal engine, so in order for it to work with your Grid tool, you would likely need to have Event Manager modified. I would post this in the Event Manager forum and/or email this issue directly to Vineyardsoft.
www.gainfocus.biz
Worldwide support for Macola Progression, Macola ES, Synergy, Event Manager and Crystal Reports.
The administrator has disabled public write access.

Crystal report export into CSV #1606

  • Shawn
  • Shawn's Avatar
  • OFFLINE
  • Senior Boarder
  • Posts: 48
  • Karma: 0
I spoke with Corey about this the other day and he did indeed say that exporting to a CSV was an issue.
with EEM. Now we all know crystal its self can do this.

so you could do this with crystal
Or another idea is if you are doing it for a simple flat file you could do it to a txt file then just change the extension as well.

_______________________________________
NeutralPosture, Inc.

Shawn Gamble
Information Services
979-778-0502 ext. 143
979-778-0408 fax
www.neutralposture.com

Women’s Business Enterprise
_______________________________________
NeutralPosture, Inc.

Shawn Gamble
Information Services
979-778-0502 ext. 143
979-778-0408 fax
Shawn@igoergo.com
http://www.neutralposture.com

Women’s Business Enterprise
The administrator has disabled public write access.

Crystal report export into CSV #1886

  • be05x5
  • be05x5's Avatar
  • OFFLINE
  • Expert Boarder
  • Posts: 123
  • Thank you received: 2
  • Karma: 0
Sorry to bring this old post back up but here is the Crystal code that I am using to do a workaroud.
Each field is a formule and the only thing not supressed in the report is the details:

if RecordNumber = 1 then "Company"
else if left({IMITMIDX_SQL.prod_cat},1) = "8" then "Fredrick Ramond"
else "Hinkley Lighting"

Just remember that the First Row will NOT be displayed. So I had to make up a record that will come first everytime. In this particular case i created an Item called 0000TST.
The administrator has disabled public write access.
Time to create page: 0.039 seconds
Powered by Kunena Forum  Protected by R Antispam