Present 2 different reports based on the selection of parameters ?

[ajayz90]

I need to present 2 different reports based on the parameters selected.One would be a string which is created for mail merege to word and other is a report which when exported to exel would create an Excel file with each field as a seperate column.


Any ideas how this can be best done.


I cannot export using CSV format and exporting to excel using data only required each filed to be a seperate field in a report to come out correctly while when i export to word the last filed which is the last textbox has a CRLF instead of a delimiter of the row as the last charachter so I cannot use as a mail merege document ......


Ideas as to

1.How can I create one report which when exported to an excel file has each filed as a column and when exported to word as each filed as a mail merge document.

2.How we can dispaly 2 different reports if we select a parameter say...Display Woed report or display excel report.


Thanks

Ajay