How can I retrive data from database using parameterfielddef

Question

hello everyone i am creating windows desktop application. i use saveupdatedelete button and perform code good it run properly. and i want to see report.then click on preview button. it open data but i need fix code for header style in report like  company nameaddresscityimageetc. i use crystal report for reporting tool. now i want to retirve some data like company name addresscityimage on header of report using ParameterFieldDefinitionsParameterDiscreteValueParameterFieldDefinitionetc use . What I have tried: i create insert updatedelete and preview button. then preview button it open crystal report and retrive data in report. i only need code for retrive some data like companynameaddresscityimage in header using ParameterFieldDefinationsParameterDiscreateValue etc.

Nitin Sontakke · Answer

From whatever I have understood from the question I think you are better of implementing this logic in a stored procedure itself and the return the final output from sp. The reason is your data will be in vertical order in db and you will need it in horizontal order at the report end. So you will have data like: parameter name parameter value comp_name acme limited country usa You create a temp table (table variable for example @company_information) in sp and update each column with proper values. And finally select * from @company_information.