Report detail and grouping in the same report

[sasha105]

Hi,

I am using Crystal reports XI. This report that I am working on has its datasource as Excel.

Consider that the excel has 10 records and shows customer order details.

Now, i want to show the all record details (10 records) sorted by order date as the first page of the report. The next pages must contain orders grouped by the customer.

Is it possible to design such a report or do i have to have to separate reports to get the required results?

Thanks.
Sasha

[Hack]

Welcome to the forums.

My immediate reaction to your question is if you are using Excel as the data source, why are you using Crystal to print reports?

Why not just print what you need to print using Excel's print functions? It would be so much less program overhead.

[sasha105]

Understand.

Excel is a good tool in itself that can provide a variety of features. We want all reporting to go thr' Crystal.

This excel data for which i am currently building a report is quite complex. My boss wants to have parameters and blah blah for the report with the group summary and the rest.

Do you think it possible to get the required?

[sasha105]

For reference:

I tried various means, here's what i could come up with.
- Creating a sub report on the same data source and inserting it in the main report's footer section.

Thanks,
Sasha.