Problem with exporting to XL

[Videla]

Hi All,
I am tryinig to export a crystal report to excel using ASP.net. In report i have links to sub reports also. While exporting the report, ASP.net exports with hyperlink to subreports also. so even after exporting to excel, when i click those hyperlinks in the excel file, it takes to my subreport in ASP.net page. I dont want hyperlinks while exporting to excel file. Any help will be appreciated.
you can even reach me thru sjayaprakash@inautix.com

Below is my CODE
----------------
pdiskFileOptions.DiskFileName = Server.MapPath(Session("pdfpath"))
rpt_sales.ExportToDisk(ExportFormatType.PortableDocFormat, pdiskFileOptions.DiskFileName)

 

[synapsevampire]

If the subreports are links, than you'll receive links.

Make the subreports embedded in the main report instead of a link.

-k

 

[Videla]

To make it more clear..actually these are not subreports of crystal..we have a group by column and on clicking that we have to generate the report at some other level.
say for example one table has population details at country, state, region. first report shows the details at country level..

country population
---------------------

now on clicking any country we need to show the population details at state level for that particular country.

state population
----------------------

we made the country column as a hyperlink, and on click we redirected to another aspx page where using another crystal report we are generated the sate level population.

Now the question if user exports the first report results we are getting hyperlinks also getting exported..How can we have only data to be exported (preferably with formattig ..as we have background colors etc.)


Thanks
Videla