Hi ,
I hv Generated Crystal Report .
Im Exporting it in ms Excel.
Everything is proper But there is prblem i m not able to sort excel sheet.
Can any one Help Me Plz.
Regards,
Pradeep yadav

Do you have any more information besides "not able to sort excel sheet"?

What are the symptoms? Is the all of the data from your CR report being exported as text thus making a numeric sort a bit difficult?

Please elaborate.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Hi,
I hv use Following Code to Export

        objRevRptDoc.Load(@"C:\Pradeep\RevenueReport\Repor ts\RevenueReport.rpt");
        objRevRptDoc.SetDataSource(Ds.Tables["ReportData"]);

        objRevRptDoc.SetParameterValue("paraFrmDate", txtDtFrm.Text.Trim());
        objRevRptDoc.SetParameterValue("paraToDate", txtDtTo.Text.Trim());
        objRevRptDoc.SetParameterValue("paraLoc", ddlLocation.Text.Trim());
        objRevRptDoc.SetParameterValue("paraFun", ddlFunction.Text.Trim());
        objRevRptDoc.SetParameterValue("paraPartner", txtPartner.Text.Trim());
        objRevRptDoc.SetParameterValue("paraMgr", txtMgr.Text.Trim());
        objRevRptDoc.SetParameterValue("paraPrj", txtPrj.Text.Trim());
        objRevRptDoc.SetParameterValue("paraClient", txtClient.Text.Trim());
        objRevRptDoc.SetParameterValue("paraPrjSubFun", ddlPrjSubFun.SelectedItem.Text.Trim());

        RevCrysalRptViewer.ReportSource = objRevRptDoc;

        System.IO.MemoryStream revStream;
       revStream = (System.IO.MemoryStream)objRevRptDoc.ExportToStrea m(CrystalDecisions.Shared.ExportFormatType.Excel);
       // revStream = (System.IO.MemoryStream)objRevRptDoc.ExportToStrea m(CrystalDecisions.Shared.ExportFormatType.RichTex t);
        Response.Clear();
        Response.Buffer = true;
         Response.ContentType = "application/vnd.ms-excel";
        //Response.ContentType = "application/rtf";

        Response.BinaryWrite(revStream.ToArray());
        Response.End();

You didn't answer my questions:

Do you have any more information besides "not able to sort excel sheet"?

What are the symptoms?

When you try to sort in excel what is happening?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

SomeTimes it does not Enable oprtion of Sorting

This is the Error Im m getting trying to Sort it.

This error only appears if you attempted to sort a range of previously merged cells, but not all cells in the sort range were merged or are not of the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge all the cells in the range to be the same as the largest merged cell grouping.

Hmm. I had this problem working with RDLC files but was able to rectify the problem by modifying how the report was bound to its data source and how it was displayed.

The only help that I can offer is to identify the offending cells and try to modify your report so that you don't have a series of merged and un-merged cells.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========