Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • Last Modified:

Import from Crystal Report to Excel (Hierarchical data to seperate columns in the Excel sheet)

Hello All,

I have developed a windows based application in ASP.net 2.0. I would like to import the data that i can see in the Crystal report to Excel. My problem is, i have hierarchical data in the crystal report.


Now if i import the hierarchical data from crystall report to excel (Microsoft Excel Data Only format), then its does not comes in the seperate columns as its hierarchical.

Just for example: I have Customer Basic Details ( First Name, Last Name)
                                            Customer Card Details ( Card No, Card Type) (There can be one or more cards for  customer - so there will be 3-4 records for the same customer)
                                                Case Details ( Case Id, Action Id, Action Type, Case Category etc) Here Alos one customer has n records.

Note: Also the stored procedure written in oracle, here i have used cusors for fetching the hierarchial data, as the data is coming from different tables.

Thanks, Ketaki
0
KetakiP
Asked:
KetakiP
1 Solution
 
UnifiedISCommented:
Do you want the detail records indented from the group records?  You can put in some blank text fields to act as column spacers to the left of your detail fields.
0
 
KetakiPAuthor Commented:
Well yes this did help me  thanks.  But still i have certain issues.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now