[Solved] how to export certain field in a grid

[L]

hi

I have a grid that has maybe 10 fields, but i want to export only certain fields in the grid to PDF. How should i go about it? Thanks

[Shinu]

Hello,

If you want to hide certain columns in the exported pdf file, then you can try hiding the unwanted columns as shown in the following code snippet.

CS:

    protected void Button3_Click(object sender, EventArgs e)
    {
        RadGrid1.MasterTableView.Columns.FindByUniqueName("CompanyName").Visible = false;  // Hide the column
        RadGrid1.ExportSettings.ExportOnlyData = true;
        RadGrid1.ExportSettings.OpenInNewWindow = true;
        RadGrid1.MasterTableView.ExportToPdf();
    }

-Shinu.

[sln007]

Shinu,

I am using the correct technique to hide a column for ExportToPdf() and ExportToExcel().......(I have tried each of the following)

 

rdgrdBASE.MasterTableView.Columns.FindByUniqueName("Actions").Visible = false;

rdgrdBASE.MasterTableView.GetColumn("Actions").Visible = false;

 

 

The problem is that the Column header text is still being produced in the PDF output and a column
is also procuded in the Excel output.

Why is the particular column being produced?  It is taking up space on the Pdf page and creating an empty
column in Excel?

 

 

 

[Shinu]

Hello,

I cannot find out any mistakes in the code. I hope this help documentation will help you to solve the issue.
PDF export.
Word/Excel export (HTML-based).
Please elaborate your scenario if it doesn't help.

Thanks,
Shinu.