In details my problem is:
What I want to do:
Populate data from database in the crystal report with a specific query
What I have done:
I have decleared a dataset YWStatus.xsd
in xsd file I have decleared a DataTable Named YWSdt
the columns are
Year,My query retrieve data from database in the same order
CountOfIDN,
CountOfsent_spno,
CountOfrep_sp_no &
CountOffinal_rep_no
then the Real problem began...
Now, What I want to do is...
Assign the values of the query-result into the datatable of .xsd file
Populate the values into the Crystal report (I got the table definations from the database field in the Field Defination pane)
Load the crystal report from .aspx file through CrystalReportViewer
I am using .net ver. 2 and Crystal Report that embeded with .NET
Sir, this is my problem in details.
I hope you will help me in this problem, I am waiting for your reply.
With Regards
Sushanta K Debnath