Hidden Subreport Help

[fmrock]

I have tried the techniques used in these 2 articles.

http://kenhamady.com/cru/archives/39

http://kenhamady.com/cru/archives/335

My subreport is in one of my group headers. While the trick from these articles works when you are viewing the report in Crystal, when you Export to Excel Data only, there are blank (empty) rows between the data rows.

Is there any trick to get this to export with Excel Data only so the blank rows are gone.

Thanks...

BTW.. using CR 2008

 

[lbass]

Why not use the regular Excel export?

-LB

 

[fmrock]

The end users can do it to regular excel, but it seems to add blank columns between the columns. The users use allot of reports as data dumps to excel.

 

[IanWaterman]

If ther are blanks between the data rows try

1 Make all field objects same size
2 align tops of field objects with top of detail section
3 close detail section up to bottom of field objects. There must be no white space above or below field objects
4 any unused group headers or footers must suppressed not just minimised.

Ian

 

[lbass]

If you follow Ian's instructions and also attach fields to vertical and horizontal guidelines, with neighboring fields attached to the same vertical guidelines, there will be no columns in between.

-LB

 

[fmrock]

Got it. Thanks. I will just have to instruct users to use Regular export to Excel instead of Data only.

 

[fmrock]

Well, even though the report looks to not show the blank rows in the Regular excel format, they are just so small you cant see them. So when you look at the row numbers in excel, it goes 1,3,5,7,9 ect.

 

[IanWaterman]

Is the subreport located between detailed rows of data?

If yes then I do not think there is much you can do.

Ian

 

[fmrock]

The subreport is in a group header.
The main report pulls from a sybase database, while the subreport for that grouping pulls data from an Oracle Database. and then shares a var back to the main report.