This is a migrated thread and some comments may be shown as answers.

Crosstab report design problem

1 Answer 35 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
sergio
Top achievements
Rank 1
sergio asked on 27 Sep 2010, 10:48 AM
Hello people.

I have a view (screenshot attached) that represents the items bought in a given period by different departments within the organization.
The departments (DeptName) and items (ItemRef) can therefore have repetitions.

What i would like to achieve is a crosstab (i think that's where i need to  go) where:
-I have one item per line
-A department "group" with a quantity (Qty) and unit price (Valor Unitario)  columns, with a total of [Valor Unitário]*[qty] by department,
like the screenshot "report". I am having problems creating this report because when i hit the crosstab wizard, i end up with a report like the "report_preview" image. I dont want to aggregate the [Qty] and [Valor Unitario] but i have to or the report wont build.

What am trying to achieve is similar to the demo "Product Sales per Period" , is there any step by step other than the video, which i cannot watch or download because flv's are blocked here?

1 Answer, 1 is accepted

Sort by
0
Accepted
Massimiliano Bassili
Top achievements
Rank 1
answered on 27 Sep 2010, 01:01 PM
You can download the Product Sales per Period video in telerik.tv from the tabbed interface below the video where it says "Related downloads".

Cheers!
Tags
General Discussions
Asked by
sergio
Top achievements
Rank 1
Answers by
Massimiliano Bassili
Top achievements
Rank 1
Share this question
or