I have the following tables:
Report - contains reports to list in treeview
Report_cd Parent_cd Report_name report_obj
2 1 'my report 1' c:\reports\myreport1.rpt
3 1 'my report 2' c:\reports\myreport2.rpt
4 1 'my report 3' c:\reports\myreport3.rpt
Report_dm - this gives more info on the report for generation
Report_cd report_type report_node
2 pdf MYRPT1
3 xls MYRPT2
4 pdf MYRPT3
Report_Parameters - this contains the parameters required to call the report. My intention is to dynamically build screens based on this info...that's my intention anyway....I haven't completely figured this out yet.
Report_cd parameter_nmbr parameter_name parameter_control
2 1 Group Number ddlst_group_nmbr
2 2 Statement Date ddlst_statement_dt
Ignore report parameters for now....I've gotten the treeview populated my report list. I'm now on to the double click event to generate the report. Firstly, however I need the information from the report_dm to construct a file name and I would need the parameters so I can prompt for the information. This process could be called for one group or loop through and do all groups. I'm trying to identify the 'right' way to store and access the information so when processing all groups, I'm not hitting the database to get the same info over and over for the different groups. My inital thought is to go get all this info and store in a collection...not sure how the parameters would work in this case... maybe multiple collections. I don't know..I'm very new at this. Anyway, I've now double clicked on my tree node.... now I need this information so I can generate the report. In my dataset to build the tree, I've only pulled back the report_cd, parent_cd and report name...just what is needed to build the tree. How should I gather the remaining info so I can call the report generating class?
thanks so much!