Morning all,

I am trying to achieve the same layout as a cross-tab which would then allow drill down into the detail.

To elaborate, the cross tab has the following layout:

Columns: Date (by day)
Rows: Priority & Customer Name
Summarized Fields: Count of Priority

Unfortunately I do not know of a way that you can enable drill-down of a Crosstab so I'm trying to replicate the layout in a normal report scenario, however I can't think of a way to portray the Column (Date by day).

Priority/Customer name could be achieved by Groupings I believe.

A chart - line a graph?

The end goal is to have a report which shows data (filtered for Month To Date) in the following format:

Dates across the top (by day), priority's down the side and a count of priorities in the middle... something like this:

              01/12   02/12    03/12
Priority 1      3       1        5

I am not sure how to create something that would look like this without a cross-tab...

The only other thing I thought of was to Group by date but then it would show 1 section per day which isn't what I wanted..

does that make any sense?

I'll give it a go, thank you.

Won't this just give me one count (grouped by month) rather than a count per day in a month?

I'll give it a go - thank you :-)