I need to make crystal report group by category vertically display act

Since Crystal Reports doesn't natively support rowspan like HTML, we'll have to use a visual workaround.

 

Let’s say you have multiple rows with the same value for a field, and you want that value to appear once, like it’s merged vertically across those rows.

 

Option 1: Suppress if Duplicated (Best for Static Height Rows)

This is the most common and simplest way:

1. Right-click on the field in the Detail section.

2. Select Format Field.

3. Under the Common tab, check Suppress If Duplicated.

4. (Optional) Align fields and draw borders to make them look merged.

This works best when your data is sorted or grouped, so duplicates are in order.

 

Option 2: Use Grouping Instead of Repeating in Details

If your field logically groups several rows together (e.g. same Order ID, same Category):

1. Go to Insert → Group and choose the field.

2. Move the "merged" field into the Group Header.

3. Keep your other fields in the Detail section.

This way, the field shows once above all related rows.

MY Question how to make crystal report BOVE

I face issue on merge cell and make row span 

C# code seems to be setting the data source correctly. Make sure your dataset (P_REGISTER_ACTS) is structured properly, with categories and their corresponding activities.

Here's a simplified version of your C# code for clarity:

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\"];
    
    \/\/ Set the data source for the report
    cr.Database.Tables[\"P_REGISTER_ACTS\"].SetDataSource(P_REGISTER_ACTS);
    CrystalReportViewer1.ReportSource = cr;
    cr.PrintOptions.NoPrinter = false;
    
    return true;
}