Crystal report data
-
Hi, I want to display some data in crystal report but I am very new to Crystal Reports. I want to display some data which is not directly available in database but i have to cook from database. Where can i write all logic or queries to get correct data? To explain in detail: let say we i have a column "colA" in data base which has the data 1.0, 1.1, 1.2, 1.3, 2.0, 2.1, 2.2, 2.3.. etc. I want to display data in column of report as Row1: MeanOf(1.0, 1.1, 1.2,1.3) Row2: MeanOf(2.0, 2.1, 2.2, 2.3) . . I am using Table Adapter and Data table. I don't know where to store the intermediate dataset and further write the logic for cooking the required data? I ll be greatly thankful for any kind of help.
-
Hi, I want to display some data in crystal report but I am very new to Crystal Reports. I want to display some data which is not directly available in database but i have to cook from database. Where can i write all logic or queries to get correct data? To explain in detail: let say we i have a column "colA" in data base which has the data 1.0, 1.1, 1.2, 1.3, 2.0, 2.1, 2.2, 2.3.. etc. I want to display data in column of report as Row1: MeanOf(1.0, 1.1, 1.2,1.3) Row2: MeanOf(2.0, 2.1, 2.2, 2.3) . . I am using Table Adapter and Data table. I don't know where to store the intermediate dataset and further write the logic for cooking the required data? I ll be greatly thankful for any kind of help.
Make formula field then show this field in detail section.
-
Hi, I want to display some data in crystal report but I am very new to Crystal Reports. I want to display some data which is not directly available in database but i have to cook from database. Where can i write all logic or queries to get correct data? To explain in detail: let say we i have a column "colA" in data base which has the data 1.0, 1.1, 1.2, 1.3, 2.0, 2.1, 2.2, 2.3.. etc. I want to display data in column of report as Row1: MeanOf(1.0, 1.1, 1.2,1.3) Row2: MeanOf(2.0, 2.1, 2.2, 2.3) . . I am using Table Adapter and Data table. I don't know where to store the intermediate dataset and further write the logic for cooking the required data? I ll be greatly thankful for any kind of help.
Hi, i really dont understand what you are asking but i assume that you want to display data (varchar,int,image,etc) from the database to crystal reports, right? OK. - Add a report and a dataset to your solution - design the dataset to fit 100% the store_procedure you are triggering, meaning if you have "select first_name 'FN',last_name 'LN' ..." them datatable fields as to be named FN and LN, and have same type!!! - select the dataset as your datasource, and them drag fields to the report - after that is easy, keep doing like it was a datagridview
// DataGridView Report
DataGridView_Report.DataSource = dt;
// Crystal Report
CrystalReport_ConstructorStandings rpt = new CrystalReport_ConstructorStandings();
rpt.SetDataSource(dt);
CrystalReportViewer_Report.ReportSource = rpt;Only beware of the image formats that are not allowed in crystal reports (Can´t help you more, but, if you want to ask something related to this go my profile) :doh:
nelsonpaixao@yahoo.com.br trying to help & get help