TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Omar Kh
NA
301
22.4k
how to make a RDLC report using xml string ?
Sep 11 2020 4:51 AM
im working on webservice and i have to make a rdlc report from xml string
the xml is
"<Data><Result>success</Result><Rowset><Row>\n<Date>01-09-2020</Date>\n<TrNo></TrNo>\n<Debit></Debit>\n<Credit></Credit>\n<Remark>Pre balance</Remark>\n<Balance>0</Balance>\n</Row><Row><Date>07-09-2020</Date><TrNo>203</TrNo><Debit>2.5</Debit><Credit></Credit><Remark> rem in 202003-452 JOD/??????? ???? ????????</Remark><Balance>-2.5</Balance></Row><Row><Date>07-09-2020</Date><TrNo>203</TrNo><Debit>452</Debit><Credit></Credit><Remark>rem in 202003-452 JOD/??????? ???? ????????</Remark><Balance>-454.5</Balance></Row><Row><Date>08-09-2020</Date><TrNo>2015</TrNo><Debit>355</Debit><Credit></Credit><Remark>rem in 2020015-500 USD/??????? ???? ????????</Remark><Balance>-809.5</Balance></Row><Row><Date>08-09-2020</Date><TrNo>2015</TrNo><Debit>1.5</Debit><Credit></Credit><Remark> rem in 2020015-500 USD/??????? ???? ????????</Remark><Balance>-811</Balance></Row><Row><Date>08-09-2020</Date><TrNo>2016</TrNo><Debit>163.3</Debit><Credit></Credit><Remark>rem in 2020016-230 USD/??? ????? ???? ????</Remark><Balance>-974.3</Balance></Row><Row><Date>08-09-2020</Date><TrNo>2016</TrNo><Debit>1.5</Debit><Credit></Credit><Remark> rem in 2020016-230 USD/??? ????? ???? ????</Remark><Balance>-975.8</Balance></Row><Row><Date>09-09-2020</Date><TrNo>2027</TrNo><Debit></Debit><Credit>500</Credit><Remark> paid rem 500 JOD / ??? ??????? ????</Remark><Balance>-475.8</Balance></Row><Row><Date>09-09-2020</Date><TrNo>2027</TrNo><Debit></Debit><Credit>1</Credit><Remark> paid rem 500 JOD / ??? ??????? ????</Remark><Balance>-474.8</Balance></Row></Rowset></Data>"
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
as
<asp:ScriptManager ID=
"ScriptManager1"
runat=
"server"
></asp:ScriptManager>
<rsweb:ReportViewer ID=
"ReportViewer1"
runat=
"server"
></rsweb:ReportViewer>
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
Reply
Answers (
3
)
Existing c# code to javascript or other web app
I want a method that tells me the text length is same as Compared text