I have an export issue while downloading a crystal sub-report in MS-Excel(data only and with guidelines).

Say I have  data corresponding to main report columns C1, C2 , C3 as a,b & c and data corresponding to sub report columns Sub1,Sub2 are d & e and f,g correspond to columns C6 and C7 which are again from main report .

While exporting this to Excel, (data only format), the problem is the data for sub-report is getting displayed in the next line and the data for the columns from main report following it is getting displayed in the line after it starting from the first sub-report column

 

                

C1           C2          C3       Sub1     Sub2     C6    C7  

 a              b            c                                    

 

 d              e

 

                                            f            g        

 

 

Please help

Thank you so much for the solutions.

Is there any other way we can do this because these will affect the earlier reports design.

 

Thank you once again!!

Yes the sub-report is printed on the same line.

 

 

Thanks