Skip to Content
avatar image
Former Member

Can we import extact Excel file in Crystal report in BO

an we import extact Excel file in Crystal report in BO

if yeh

den HOW

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 08, 2008 at 03:37 PM

    Hi Amit,

    Please respond with a detailed description of what you're trying to do.

    Regards,

    Wallie

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 08, 2008 at 07:58 PM

    Hi Amit,

    There is no functionality to import the data from MS Excel to Crystal reports. However we can connect to the Excel sheet as a data source and create Crystal reports against Excel.

    Some popular choices in the Create New Connection folder are described here:

    Access/Excel (DAO)

    This option lets you connect to a supported database type (Access, Excel, Lotus, and so on).

    I hope this helps you.

    Regards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 08, 2008 at 09:54 PM

    Amit,

    You can insert Excel Spreadsheets as OLE Objects but you would be limited as CR would only display it on 1 page. You would be better off inserting a subreport that is connected to that excel file and reporting off it.

    Add comment
    10|10000 characters needed characters exceeded