I need to make crystal report group by category vertically display activities related?

Question

I am working on a Crystal Report and facing an issue. I cannot make

every cell in the categories have multiple activities vertically , so each category

needs to have multiple activities with row spans.

csharp code
    public bool GET_REGISTER_DATA_Report(string P_REQ_ID)
    {
        MyDatabase db = new MyDatabase();
        RptGET_REGISTER_DATA_Report cr = new RptGET_REGISTER_DATA_Report();
        var ds = db.GET_REGISTER_DATA_Report(P_REQ_ID);
        var P_REGISTER_ACTS = ds.Tables["P_REGISTER_ACTS"];



        cr.Database.Tables["P_REGISTER_ACTS"].SetDataSource(P_REGISTER_ACTS);
 

  
        CrystalReportViewer1.ReportSource = cr;
        cr.PrintOptions.NoPrinter = false;
        ExportFormatType formatType = ExportFormatType.PortableDocFormat;
        cr.ExportToHttpResponse(formatType, Response, false, string.Format("خدمات الامن السبيرانى", P_REQ_ID));

        Response.Flush(); Response.SuppressContent = true; HttpContext.Current.ApplicationInstance.CompleteRequest();
        return true;
    }

desired design I need

Updated post

I make as cross tab but can't customize it

so how to remove total fields

also how to remove column empty on last

update post

remaining column name header as category and activities with Arabic language

Answer 1

If you just need labels (no numeric summaries), create a dummy numeric summary, set the Display String property of the numeric summary to blank (""), suppress redundant totals, and hide redundant grid lines using the 'Format Grid Lines' dialog.

Here is an example of the final result:

Answer 2

It's not clear how or why the code is related to your question. Or what the problem is.

If the problem is that you need a report layout that looks like the desired design, then the easiest option is to simply use the menu option of Insert, Cross-Tab...