SSRS: Cannot read the next data row for the dataset hexadecimal value 0x02, is an invalid character -
can please me following error on 1 value of parameter in ssrs report , works rest:ssrs: cannot read next data row dataset. hexadecimal value 0x02, invalid character .
the ssrs report works ssas cubes. parameter fails on list of insurer names of varchar value , cannot spot ascii characters in actual data. said works rest of insurers ...i cannot seem find solution anywhere.
looks there invalid character in data.
i didn't test solution 1 suggestion solve issue change invalidxmlcharacters property in data source in database. should possible select remove or replace. please see more details here.
This comment has been removed by the author.
ReplyDelete