Skip to Content
author's profile photo Former Member
Former Member

Crystal -> Excel (multi tab)

Hi

I know this has been asked several times and I know everyone says there's no way to do this. Can someone say something else lol.

I just started at a new company and they asked me to check this out. I did download Visual Cut and it works but only on Level 1 group.

I did also find out that if a Crystal Report goes over 65k lines then it will go onto a new tab.

So is there anyway to add empty rows at the end of a section to fill up the 65k limit? Because that might just work.

I'm downloading CR 2011 and hope there's something new in there that can help me out but don't know yet.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Feb 03, 2012 at 03:10 PM

    Hi,

    I don't think I have anything new for you! Blank lines can only be added if the data is actually there, however if it's the 65k limit that you're worried about, then CR 2011 does support export to .xlsx and Excel 2007 does not have that limitation.

    You're heading the right way!

    -Abhilash

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 03:14 PM

    Hi,

    In Crystal Designer 2011, data will be displayed in single tab, Select MIcrosoft Excel Workbook Data Only to be able to Export to Excel 2007 format.

    Cheers,

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 06, 2012 at 06:28 AM

    @Abhilash - I'm not worried about the 65k limit. I would actually like to have blank fields filling to space so my report can go to the next sheet.

    @Ido - Your tool rocks but the reports I'm looking at is 1 report with +- 6 sub-reports so there's not any grouping. The sub-reports are all in the footer sections.

    Each of those sub reports has to go into their own sheet. I know you said something about creating each sub-report as their own report.

    I would then assume I should use your tool to export each report (which was converted from the sub-report) into an excel document and add the tag to update the document. Am I correct?

    Problem with this is that the report is currently running from our system so we can't use your tool as well. The clients would like to run it and export it and that's it. No addition effort has to be used for this.

    ps: Tested Crystal 2011 and the export is the same except that it supports xlsx files.

    Add a comment
    10|10000 characters needed characters exceeded

    • "I would then assume I should use your tool to export each report (which was converted from the sub-report) into an excel document and add the tag to update the document. Am I correct?"

      Yes, it's just a matter of naming the export file in a way that specifies the target Workbook and the Tab name.

      "Problem with this is that the report is currently running from our system..."

      Your system can trigger the process via a command line API.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.