Spread Sheet in crystal reports

[fhurmuzlu]

is there is any way to create spread sheet inside crystal Reports?

 

[lbass]

You need to provide a much more detailed explanation of what you are trying to do.

-LB

 

[crystalkiwibruce]

You can export any report to Excel (looks pretty) or Excel Data (just the rows and columns). Crystal 2010 allows export to xlsx files, while older versions export to xls files and are limited to 32767 rows.

If you want to display a spreadsheet inside the report, use Insert OLE object, select the file and follow the links. But that just displays the spreadsheet as if it was an image. Can't do much else with it.

you can also use an xls file as a data source and then can use formulas and formatting on any field in the spreadsheet. Select DAO and the Excel file format. If your report has data from other sources you might want to retrieve the Excel data in a sub report.

Bruce Ferguson

http://www.crystalkiwi.com/nlog.htm

 

[Madawc]

Crosstabs look much like spreadsheets, though actually they are rather different. Worth getting to know them, regardless.

Crystal has a flow: you could lay fields out as if they were a crosstab, but the results of later sections cannot be referenced in earlier sections.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[SkipVought]

If you are going to export to Excel in order to do something useful, then
[tt][red]
DO NOT EXPORT[/red]

1. a REPORT

2. a CROSSTAB
[/tt]
These structures are not in the best for to be analyzed in Excel.
[tt]
PLEASE DO EXPORT Excel Data (just the rows and columns, with column headings)[/tt]

Excel's many data analysis and reporting features are designed to work with tabular data, just like CR best uses tabular data as its source data.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}