i want to create a dynamic report that has the same Hierarchy with DetailTableDataBind event format but with different data. using store procedure to get the datas, how do i specify the mastertableview,detailview and column, and how do i do all of this in the server side. Plus how do i export all data on this to excel.
so if i have table call student
name address shoes shirt zip city state size
i want name to be master,address to be detail, shoes to be detail again
so if a user select a report call student it will get the above info and generate a Hierarchy with DetailTableDataBind event with the above info.
if a user select grade report, it will select info from grade table
level class test number
and level will be master, class will be detailtable.
and so on. could i do all this on server side and i want to be able to say e.detailtableview.datasource = "exec storedprocedure ......"
thank you very much for your help . i really appreciate it.
so if i have table call student
name address shoes shirt zip city state size
i want name to be master,address to be detail, shoes to be detail again
so if a user select a report call student it will get the above info and generate a Hierarchy with DetailTableDataBind event with the above info.
if a user select grade report, it will select info from grade table
level class test number
and level will be master, class will be detailtable.
and so on. could i do all this on server side and i want to be able to say e.detailtableview.datasource = "exec storedprocedure ......"
thank you very much for your help . i really appreciate it.