I have a report that works perfectly when I export the report data as CSV in standard Mode with the Isolate Report and the Isolate Group checkboxes selected. Works perfectly..... Now I need to schedule the report to run weekly and the Isolate options are not available which changes the entire report. Am I missing something? Does a way exist to schedule crystal reports as a CSV that is Isolated?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Maintaining CSV style on sheduled report
- Thread starter BigDaddyE
- Start date
I'm not familiar with Isolate Report. I have got round other limits on CSV by creating a single large field with commas put between fields, and exporting this as text. Does this help?
![[yinyang]](/data/assets/smilies/yinyang.gif "[yinyang] [yinyang]")
Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP
Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP - Thread starter
- #3
Sorry the format must be as follows as a CSV export:
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted"
"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
And you can only get this by selecting the Isolate options on an Export. If you do not select the Isolate options then you get this garbage:
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted"
"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
And you can only get this by selecting the Isolate options on an Export. If you do not select the Isolate options then you get this garbage:
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
"Employee_#","Facility_#","Mileage_Count","First_Name","Last_Name","Date_Posted",,"0068818340","30100","000675.00","ANNA","SMITH","10/23/2012"
briangriffin
Programmer
In Crystal you'll see File: Export: Export Report Options. Change that to CSV and click OK, there you'll see the Isolate options. Save the report with those changes.
When scheduling, when you select CSV you'll probably see a checkbox for Use the Export Options Defined in the Report. If you check that, then whatever you have defined when saving the report to Enterprise will be retained, and the report will export in the format you want.
At least it worked for me on 4.1 - you don't mention what version of Enterprise you're using, but I don't think this functionality has changed.
- Status
Similar threads
- Locked
- Question
- Locked
- Question