Showing posts with label export. Show all posts
Showing posts with label export. Show all posts

Friday, March 30, 2012

Receiving Export file name

Hello,
I work with Crystal in Visual Studio 2005.
Is it possible to receive the export file name after the report viewer finished exporting?I think it is not possible. It is also not possible to figure out which format was used for exporting, which optional parameters were used etc.
If I needed that information, I would probably create my own form for entering export file name and export options.

Wednesday, March 7, 2012

re-arrange name data

i'm attempting to make a DTS package that will export to a csv each day. my problem is figuring out how to change a name field that stores the data as the following format:

First Middle Last

into

Last, First Middle in the outputted .csv file

thanks in advance.

-csubstring(fld,len(fld) - charindex(' ',reverse(fld)),len(fld))
+ ', ' + left(fld,len(fld)-charindex(' ',reverse(fld)))

The numbers will be a bit wrong but you can fix that.