how to put a sub report and report in one line?

[lkh5650]

Hello

I need help.
I am trying to generate report and I have a sub report generated in detail

so each row

it would be like this..
with header

name address age height weight
A B [sub-report ]
C D [sub-report ]
E F [sub-report ]

Now of cors i am not using name address age height weight, it is more complicated then that and it requires me to use sub report.

My problem is, when I export this out to excel file with data only option, it will be exported like this

name address age height weight
A B
[sub-report]
C D
[sub-report]
...

etcs

the [sub-report] would bring in age height weight information with spaces so, it would be like [(age) (height) (weight)]

anyway, i hope this is not too ambiguous question.

Thank you!

 

[lbass]

It is easier to accomplish this with the regular export (not data only)--is that an option?

-LB

 

[Madawc]

You could try making the subreport blank and very small. Use Shared Variables to pass the value to the main report and display it with the other values.

Note that a Shared Variable value will only be available in a section below the section that contains the subreport. So you might get blank lines in your export: I've never tried this.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP