Print to pdf and .csv

[Andy16H]

thread693-1648503
Dr. Zogg I started the thread mentioned above. Tonight was the first time i have seen your .bat file. I now have micros res 3700 version 5.1. I can not make your file work. The address in the file does not exist on my pc. Any help would be appreciated. The goal would be to have this file print to a .csv file every day at 3:00 AM and save the file as yesterdays date ie. Today at 3:00 AM is 4/11/14 I would like the file to be saved as 4-10-14.csv

any help would be appreciated. If it is easier I noticed my new micros pc has export utility installed on it, i have no idea how to use it.

 

[pmegan]

Did you try looking in Program Files\common files\crystal decisions\3.0\bin instead of Program Files\common files\crystal decisions\2.0\bin? Res 5 uses Crystal XI instead of Crystal 9.

 

[Andy16H]

There is not a crystal folder under programs or programs(x86). Since they upgraded me my reports take forever to run and look a little different??

 

[Moregelen]

What are you trying to export to csv?

A lot of these reports have views or stored procedures as back-ends. It would be MUCH easier to run the procedure / query the view directly.

 

[Moregelen]

And in RES 5 it supports PDF; don't have to do the DLL flipping

 

[Andy16H]

Mainly i would like to export my daily sales totals. But I would like the ability to print any of my reports in the csv format. My old system did not have export utility but the new system does have export utility. I have looked around and can not figure out how to use it.

 

[Andy16H]

How can i tell if the report is stored as a view. the report title is daily consolidated sales the report file name is sys_102.rpt

 

[Moregelen]

You'd have to have crystal reports so you could open the file.

The thing about exporting these reports as cvs (rather than excel, which is a format that can take formatting), is that it won't work right for most of the reports. They aren't formatted in such a way that you could make them a cvs.


If you just want your sales you should check the tracking totals tables. Daily_sys_trk_ttls is, I believe! the table name.

So you could run something like:

SELECT * FROM micros.daily_sys_trk_ttl WHERE business_date = Date_you_want;
OUTPUT TO c:\exports\sales.csv;

 

[Andy16H]

my mistake the report i want to export is sys_Con Custom1

 

[Andy16H]

Shows what I know about sql and micros. I just thought .cvs would be easier. End goal is to get this information to excel.

 

[Andy16H]

I'm using the export utility and thanks to your help i have the following working.

SELECT * FROM micros.dly_sys_trk_ttl;

I put in export utility where to save and file type. The only problem with it is there are no column headings. How do i get those to appear?

 

[Andy16H]

Is there any way to change
SELECT * FROM micros.dly_sys_trk_ttl;
So the column headings come over as well?? I've googled this and tried several different scenarios but can't get one to work.