Skip to Content
avatar image
Former Member

Cross tab drill down

Greetings all

I have a challange!!!!!!

I have created a crosstab report showing a list of wards acroos the columns and a list of days for each row. The data is the number of patients on each by day. The customer would wish to click on the number of patients on Ward 15 on the 15 Sep 08 and see a drill down (or sub report on demand) of a list of patient names on the ward.

Any ideas?

Thank you in anticipation


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 03, 2008 at 08:40 AM

    Hi Kevin

    A drill down on a part of a cross tab can not be done.

    However there is a workaround for your requirement: For example my data is: column for cross tab is Countryname, row is region name and the summarized value is last year's sales.

    1. Create a group on country on main report.

    2. Insert a subreport in the detailed section.

    3. Insert cross tab with region as column and last year's sales in summarized value.

    4. Link the subreport for country with main report.

    Now you would be able to drill down for the group of records for a particular country through this subreport and that also in a cross tab.

    Hope this helps!!!!



    Add comment
    10|10000 characters needed characters exceeded