Crystal -> Excel (multi tab)

[Former Member]

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

[Former Member]

@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.

[ido_millet]

"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.

[Former Member]

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

[ido_millet]

If you need to break by level 2 grouping, just create a version of the report that groups on that at level 1. You are then back in position to use the tool mentioned above.

[abhilash_kumar]

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