Creating reports and dashboards | Stimulsoft community forum

Code: Select all

report1.RegData("DataSource1", dataSet.Tables["patients"]);

Code: Select all

public IQueryable GetPatientCoPayDetails(int appointmentId, string receivedBy)
        {
            var query = from a in this.ObjectContext.appointments
                        join p in this.ObjectContext.patients on a.patient_id equals p.patient_id into PatientValues
                        from ojp in PatientValues.DefaultIfEmpty()
                        join ph in this.ObjectContext.physicians on ojp.default_physician equals ph.physician_id into PhValues
                        from oph in PhValues.DefaultIfEmpty()
                        join u in this.ObjectContext.users on oph.user_id equals u.user_id into usValues
                        from us in usValues.DefaultIfEmpty()
                        join f in this.ObjectContext.facilities on ojp.default_facility equals f.facility_id into facValues
                        from fac in facValues.DefaultIfEmpty()
                        join pr in this.ObjectContext.Practices on fac.practice_id equals pr.practice_id into OJValues
                        from oj in OJValues.DefaultIfEmpty()
                        where a.appointment_id == appointmentId

                        select new CustomFormattedCoPayReceipt
                        {
                            
                            patient_name = "Received from " + ojp.last_name + " " + ojp.first_name + ", amount of US$ ", //+ (a.co_pay_amount == null ? 0 : a.co_pay_amount) + "/- for out-patient consultation with "+"Dr. "+u.last_name+" "+u.first_name+" on "+a.date_created+" appointment.",
                            coPay_amount = (int)a.co_pay_amount,
                            physician_name = "/- for out-patient consultation with " + "Dr. " + us.last_name + " " + us.first_name + " on ",

                            facility_name = fac.facility_name,
                            facility_address = fac.address_line_1 + ", " + fac.City + ", " + fac.state_code + ", " + fac.zip_code,
                            facility_phone = "Phone: " + (fac.main_phone == null ? "_" : fac.main_phone) + " Fax: " + (fac.Fax == null ? "_" : fac.Fax) + " E: " + (fac.email == null ? "_" : fac.email),

                            //facility_fax=fac.Fax,
                            //facility_email=fac.email,

                            appointmentId = a.appointment_id == null ? 0 : a.appointment_id,
                            appointment_date = a.date_created,

                            //physician_id=ph.physician_id,

                            //payment_method="Payment Method: "+(a.payment_method==null? "_":a.payment_method),
                            received_by_user = "Received by: " + receivedBy
                        };
            return query;
        }

Code: Select all

        using (NorthwindDataContext context = new NorthwindDataContext())
        {
            var categories =
              from c in context.Categories.AsEnumerable()
              select c;
            

            StiReport report = new StiReport();
            report.RegData("Categories", categories);
            ...
            
        }