| Author |
Topic |
|
sunil
Constraint Violating Yak Guru
282 Posts |
 Posted - 2008-09-15 : 04:51:48
|
| I am trying to export SSRS report to XML. But in some cases,it throws exception with message,'.', hexadecimal value 0x00, is an invalid character.Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: '.', hexadecimal value 0x00, is an invalid character.I investigaetd by exporting it into tiff format. I saw couple of columns having boxes instead of data. When I updated these boxes field by some data like 'sunil' and then tried exporting report, I was successful. How can I find what this illegal character is in database column field. I tried using len(col),datalength(col),ltrim(rtrim) to find if there is any length difference but to no help. For example, if my column containing value "Hidden Warrior' for which boxes are displayed, i got len and datalength as 30 where as column definition is varchar(50). Its value should be 14. How can i find the illegal character? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 05:11:13
|
| How are you trying to export? By default, the report definition file rdl is in xml format. |
 |
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-15 : 05:14:47
|
| I am directly going to report url and then selecting "XML with Report Data" option from dropdown and then clicking Export link button. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 05:39:48
|
quote:
Originally posted by sunil
I am directly going to report url and then selecting "XML with Report Data" option from dropdown and then clicking Export link button.
Can you try taking the report code and saving it as xml file? |
|
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-15 : 05:52:48
|
quote:
Originally posted by visakh16
quote:
Originally posted by sunil
I am directly going to report url and then selecting "XML with Report Data" option from dropdown and then clicking Export link button.
Can you try taking the report code and saving it as xml file?
I am not getting what you are trying to say?My Report export works fine if I update the two columns displaying boxes in addition to column data. It is only when I get boxes, XML export fails. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 06:05:47
|
| Where are you seeing boxes in xml? Within nodes? |
|
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-15 : 06:47:26
|
quote:
Originally posted by visakh16
Where are you seeing boxes in xml? Within nodes?
I am not able to insert picture here of my output here on forum. but to give you idea.Description Title Hidder Warrior bbbbbb Many Names Some name My name In above sample, bbbbb stands for boxes which are shown in report output. But, these boxes are seen only when report is exported in tiff format. When it is exporetd in pdf format, it comes fine only showing "Hidder Warrior"instead of "Hidder Warrior bbbbbb " in tiff image. How to attach image to my post? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-15 : 07:06:10
|
quote:
Originally posted by sunil
quote:
Originally posted by visakh16
Where are you seeing boxes in xml? Within nodes?
I am not able to insert picture here of my output here on forum. but to give you idea.Description Title Hidder Warrior bbbbbb Many Names Some name My name In above sample, bbbbb stands for boxes which are shown in report output. But, these boxes are seen only when report is exported in tiff format. When it is exporetd in pdf format, it comes fine only showing "Hidder Warrior"instead of "Hidder Warrior bbbbbb " in tiff image. How to attach image to my post?
so i guess thats because of some unprintable characters appearing in your data. Can you try cleansing your table data while bringing it to report (inside your query or procedure) and exporting after rendering the report. |
|
|
|
sunil
Constraint Violating Yak Guru
282 Posts |
Posted - 2008-09-15 : 07:47:46
|
| I am not able to find what's there in table which is unprintable. Is there any way to find these unprintable characters? Data has come from client and if we get to know what these characters are, we can try to prevent them from front end itself. How to clean table data? I don't know what to clean here. |
|
|
|
|
Error exporting Report to XML file