Data Report Issue

gunapriyan · October 24th, 2013, 01:38 PM

Friends,

I had designed an application.

I want Report like as follows using Data Grid.

TITLE
Date: Page 1 of 1

Region : North

Port Name Quantity FOB UP
XYZ 100 100 1
KLM 200 200 1
ABC 650 650 1
FGH 722 72000 100
Region Total 1672 72950

Region : South

Port Name Quantity FOB UP
KLM 100 100 1
UVW 200 200 1
RST 650 650 1
IJK 722 72000 100
Region Total 1672 72950

Grand Total 3344 145900

My Query:

Code:

select ROW_NUMBER()OVER (ORDER BY er.Port_Name) AS Row,er.Port_name,pm.Region,
sum(Quantity) Quantity,sum(Fob) Fob,convert(numeric(18,2),sum(Fob)/sum(Quantity)) Unitprice
from Exporter_Returns er join Exporter_Master em on er.exporter_id=em.exporter_id join
port_master pm on pm.port_name=er.port_name where returns_month
between '2010-01-01' and '2013-08-01' and quantity!=0 group by er.Port_Name,pm.Region

But I am unable to grouping.

I had received error "Report sections do not match data source"

Actually i have basic problem. I don't know how to create groups with out Data Environment.

Whether the Data Grid design is correct? If wrong, how can i design to group
This report contains 2-level group. My next report 3-level grouping.

I request you to please help me to get the output like as above.

Thanks in advance.

Regards,

Aakash