how to make a RDLC report using xml string ?

im working on webservice and i have to make a rdlc report from xml string

the xml is

"success\n01-09-2020\n\n\n\nPre balance\n0\n07-09-20202032.5 rem in 202003-452 JOD/??????? ???? ????????-2.507-09-2020203452rem in 202003-452 JOD/??????? ???? ????????-454.508-09-20202015355rem in 2020015-500 USD/??????? ???? ????????-809.508-09-202020151.5 rem in 2020015-500 USD/??????? ???? ????????-81108-09-20202016163.3rem in 2020016-230 USD/??? ????? ???? ????-974.308-09-202020161.5 rem in 2020016-230 USD/??? ????? ???? ????-975.809-09-20202027500 paid rem 500 JOD / ??? ??????? ????-475.809-09-202020271 paid rem 500 JOD / ??? ??????? ????-474.8"

ii have added a dataset called st_DS and ,make a datatable with 6 cloumns

also i'v add a report

then i added a web form with report viewer control

then there is a button wich must do all the work

this is the code behind

string xml_resp = objCmd.Parameters["p_out"].Value.ToString();
XmlTextReader reader = new XmlTextReader(new System.IO.StringReader(xml_resp));
st_DS stt = new st_DS();
stt.ReadXml(new XmlTextReader(new System.IO.StringReader(xml_resp)));
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("st.rdlc");
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("st_DS", stt.Tables["1"]));
//also tried// ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("st_DS", stt.Tables["0"]));
ReportViewer1.LocalReport.Refresh();

but i got this error

i have google it but with no luck at all !

im so confused that there is a better,easier way to do it but i cant find it ! i need help , thank you

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta6y ago
Its all seems good to me. Can you try cleaning the %temp% files and clean then rebuild your project, sometimes this also works
0
Amit Gupta6y ago
Debug your code and check if your dataset is having any tables. i.e st_DS
0
Amit Gupta6y ago
Replace your line

ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("st_DS", stt.Tables["1"]));

with this

ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("st_DS", stt.Tables[0]));

Your dataset doesnot have table with name 1, so use the index property.

Do let me know, if it solves your problem
+1