Is it a known limitation that the CSV export doesn't export the
contents of the detail tables? I've got a single method to handle the
export and when i export to either Word, Excel or PDF the detail table
is included. But when i choose CSV only the parent table is included
in the results. The code is very simple and was pulled mostly from
some other posts i saw on here about other peoples export problems.
void lbtnExport_Click(object sender, EventArgs e)
{
rgComparativeReport.ExportSettings.FileName = "Comparative Report Export";
rgComparativeReport.ExportSettings.ExportOnlyData = true;
rgComparativeReport.ExportSettings.IgnorePaging = true;
rgComparativeReport.ExportSettings.OpenInNewWindow = false;
rgComparativeReport.MasterTableView.HierarchyDefaultExpanded = true;
for (int i = 0; i < rgComparativeReport.MasterTableView.DetailTables.Count; i++)
{
rgComparativeReport.MasterTableView.DetailTables[i].HierarchyDefaultExpanded = true;
}
rgComparativeReport.Rebind();
if (ddlExport.SelectedValue == "Excel")
{
rgComparativeReport.MasterTableView.ExportToExcel(); //this works fine
}
else if (ddlExport.SelectedValue == "Text")
{
rgComparativeReport.MasterTableView.ExportToCSV(); //This only exports the parent table
}
else if (ddlExport.SelectedValue == "Word")
{
rgComparativeReport.MasterTableView.ExportToWord(); //this works fine
}
else if (ddlExport.SelectedValue == "PDF")
{
rgComparativeReport.MasterTableView.ExportToPdf();//this works fine
}
}
Thanks!
Mark
void lbtnExport_Click(object sender, EventArgs e)
{
rgComparativeReport.ExportSettings.FileName = "Comparative Report Export";
rgComparativeReport.ExportSettings.ExportOnlyData = true;
rgComparativeReport.ExportSettings.IgnorePaging = true;
rgComparativeReport.ExportSettings.OpenInNewWindow = false;
rgComparativeReport.MasterTableView.HierarchyDefaultExpanded = true;
for (int i = 0; i < rgComparativeReport.MasterTableView.DetailTables.Count; i++)
{
rgComparativeReport.MasterTableView.DetailTables[i].HierarchyDefaultExpanded = true;
}
rgComparativeReport.Rebind();
if (ddlExport.SelectedValue == "Excel")
{
rgComparativeReport.MasterTableView.ExportToExcel(); //this works fine
}
else if (ddlExport.SelectedValue == "Text")
{
rgComparativeReport.MasterTableView.ExportToCSV(); //This only exports the parent table
}
else if (ddlExport.SelectedValue == "Word")
{
rgComparativeReport.MasterTableView.ExportToWord(); //this works fine
}
else if (ddlExport.SelectedValue == "PDF")
{
rgComparativeReport.MasterTableView.ExportToPdf();//this works fine
}
}
Thanks!
Mark