index | search | no replies | posting guidelines | help login | register
Index » Products » ASP Report Wizard v2
search this forum:
:: Text Replacement does not seem to happen on Export :: (7)Post a New Message | Post a Reply
Aug 3 2006, 1:15 PM
 Text Replacement does not seem to happen on ExportPost a Reply
 scotthibbs

View this author's profile Send this author a private message

from: Philadelphia, PA

A data source requests a text column from the database that is
in the format 0nnnnn....like "07123".  A user wants to see the zero
when he creates an Excel export. However, Excel notices that the column is all numeric and removes the zero.

To try to correct this, we defined the formatting of the column as "Text Replacement", with a value of '#TEMP#.  We see the single quote on the
displayed report....the replacement works fine.

When we export the report...with ANY export format, the single quote disappears......the text replacement does not seem to occur.

Aug 9 2006, 9:29 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 scotthibbs

View this author's profile Send this author a private message

from: Philadelphia, PA

No response to problem report.

Aug 10 2006, 11:55 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

The current version of the report wizard does not support TextReplacements when exporting datasets....For now adding this functionality is beyond any reasonable scope since we are trying to launch version 3 (beta 1) by the end of the month.

Thanks



-------------------------
Ghost
Aug 28 2006, 6:13 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 scotthibbs

View this author's profile Send this author a private message

from: Philadelphia, PA

We will hope that this will be corrected in the new version.  For the time being, we will inform the users not to trust exports of data, as the export will not match what is visible on the web page.

Sep 17 2007, 2:46 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 jmc

View this author's profile Send this author a private message

since: Feb 24, 2006
from: Gronsveld,Netherlands

Hi, same issue when exporting to excel or word field contents like "BL+C4-4313"
Can we expect a solution in V2?  Thanks in advance.

Sep 17 2007, 7:37 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 ghost

View this author's profile Send this author a private message Visit author's homepage

from: Washington, DC

expect it in version 3 which is still in alpa


-------------------------
Ghost
Sep 17 2007, 8:57 AM
 Re: Text Replacement does not seem to happen on...Post a Reply
 jmc

View this author's profile Send this author a private message

since: Feb 24, 2006
from: Gronsveld,Netherlands

Hello
If this might help someone:
I found a solution to my problem even if I am using  Xl2003 (Office\11.0)
Check Microsoft knowledge base article 821456: Incorrect file origin.
Regards.

Pages: (1)   [1]

search this forum: