It looks like you're new here. If you want to get involved, click one of these buttons!
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
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.
I request you to please help me to get the output like as above.
Thanks in advance.