Cross tab drill down

[Former Member]

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

Kevin

[Former Member · Accepted solution]

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!!!!

Regards

Sourashree

[Former Member · Accepted solution]

Dear Sourashree

Thank you for your help. I thought it may have been too good to be true.

Thank you for your time.

Kevin