Solved

How do I drill-down a crystal reports cross tab report

Posted on 2011-02-12
1
1,319 Views
Last Modified: 2012-05-11
Joined Orders, Orders Details, Product tables of xtreme.mdb. Using VS2008 Crystal Reports Cross-Tab report.

 how can i create a cross-tab report first showing Country in Rows, count of OrderID
e.g Brazil 6

Then drill down to :

Belo Horizonte      1
Distrito Federal      1
Rio de Janeiro      1
Rio Grande do Sul      1
São Paulo      2

Then

Drill-down São Paulo      2

To Show

row level detail :

Country,Region,Contact Position,Position,Ship Via,Product Name,Order ID
0
Comment
Question by:Jimmy_inc
1 Comment
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 34881394
Crosstabs are all about summarizing data.  I think you more of a regular report where you can drill into the groups and eventually into the details.

mlmcc
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now