Friday, January 20, 2012

Please: Don’t use strange characters in the names of Customized Reports…

Bumped into this situation where some Linked Reports had to be exported to another SSRS instance. Huh? That can’t be done? Yes you can!

However, now it didn’t work at all. I just got strange errors referring to non-existing Reports and the lot. It puzzled me for a while and then I found it: the Linked Reports had percentage characters (%) in their names. And batch files (used here for importing the exported Linked Reports) use % signs for defining parameters…

Ouch!

After having renamed those Reports in SSRS and running a new export, the new import run just fine….

Conclusion:
Whenever you export (Linked) Reports using this tool, make sure those Reports don’t have strange characters in their names. Otherwise you bump into the same situation as I did…

No comments: