Exporting a report

  • Is there a way to export a report to a txt delimited (tab preferable) file?   My output can exceed the 65,536 rows that Excel allows, so this format will not work for me.   I also can't get csv to work with large files. 

    Thanks in advance for any help you can provide.

  • Libby -

    You can export reports in a variety formats including CSV the challenge is that .CSV files are mapped to Excel by default, which as you've noted can only have 65K+ rows... Unless your users are trained to open the results in a different program you'll run up against the 65K+ row limit every time.  You can change the default mapping of .CSV to Excel but it will require the assistance of your windows admins.

    Joe

     

  • Hello,

    I´ve a problem with a report export.

    My report is a matrix, but the staticts columns (rows Groups) not have header (a column name, p. ej "Cliente").  look the example

                           enero  febrero   marzo

    7170989 ramiro   3443   1321      1233

    2300147 Pepe     4568   1789      3258

    I need that it appears of the following form

    cedula  nombre enero  febrero   marzo

    7170989 Ramiro 3443   1321      1233

    2300147 Pepe     4568   1789      3258

    how can i do its...."Cedula" and "Nombre" appears like column header of the this 2 rows group?

    I implement a solution with textbox, but it does not work when exporting.
  • While Excel 2003 has the 65k rows limit, Excel 2007 give you 1M rows.  This may not help you immediately, but our shop has mixed user base of 2003 adn 2007.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply