Dynamic Crystal Report

Question

Hi Can someone please help me out here. I need to display some columns which are part of the table and some which are not in the crystal report. For eg. From backend i am getting columnsl like call_Date sum(p1calls) as call_total. and i am taking it in the dataset. i could display call_date by just dragging that table column on the report. Now i need to display call_total which is not actually a database table column but that is sum(p1calls)(This is not a single value but there is a value in each of the rows). So Can someone please tell me how to display this column on report. Thanks & Regards Prash

Amit Dhania · Answer

We can put fields on report dynamically. For it we have to put formula-fields on report on design time. We can put fields value from database in formula-fields in our c# coding. For example AttendenceReport is crystal report having formula-field status. AttendenceReport objAttendenceReport=new AttendenceReport(); //{AttendenceTable.Status} values coming from //database objAttendenceReport.DataDefinition.FormulaFields[Status].Text = {AttendenceTable.Status};