Export to Excel

[DaveAdlard]

Hi,

I hope you can help as this is driving me mad.

I have built a report with a number of sub reports and have pulled through some shared variables from my sub reports. I have used these values for some calculations in the main report. To allow me to use these values I have put the sub reports in one of the group headers. The issue I have is when I export the report to excel the sub report values in my header is displayed. I can't suppress the group headers because I can't get the values and the hide option in section experts doesn't solve my problem either

 

[pmax9999]

It is possible to format the sub-report so it is hidden but still feeds the variable values in the main report. See this thread: thread767-1737714.

This thread refers to sub-report in the Report Header but will also work for Group Headers.


Cheers
Pete

 

[BeeBear2]

Sorry to hijack this thread, but this is exactly what I was about to post, except my subreport is in Group footer 1A and my visible data is in group footer 1B, so I can enable the shared var results to pass from the subreport to the main report sucessfully.

I have tried whats in the linked thread above, and when it exports to excel, I get all the required data, but I also get a blank line above each row of data (eg where the GF1A is).
This is when I export as DATA ONLY in Excel.
If I export as formatted Excel, then I get TWO blank lines between each row of data, and the data cells have lots of blank columns between each data column, and sometimes the single column of data is made into 2 or more merged cells.....

Surely theres a way to export a crystal report to Excel and have it come out without the blanks???

PS - I'm on Crystal V10 (yes, an old out of date version.....)

Thanks

 

[pmax9999]

This is a different topic and as such you should have started a new thread.

To ensure the report exports cleanly to excel, you need to:
[ul]
[li]ensure all fields are the same height, the fields are aligned to the top of the section in which they are situated and the section height is reduced to the same height as the fields (ie no white space above or below the fields within their sections); and[/li]
[li]use guidelines to control the vertical alignment and width of all fields, with no white space between them.[/li]
[/ul]

It will probably take a bit of trial and error but it is achievable if you persevere.

Hope this helps

Cheers
Pete

 

[Charliy]

also if you have areas in the report that are vacant in some bands (like a column that is not totaled in a group footer) insert a text box that is blank, and make it the same size as the other elements in the column. This will keep columns from shifting.