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
Loading
Amit DhaniaPosted Dec 16, 2008, 7:22 AM
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}";