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.
Showing posts with label export. Show all posts
Showing posts with label export. Show all posts
Friday, March 30, 2012
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.
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.
Subscribe to:
Posts (Atom)