-
October 24th, 2013, 06:35 AM
#1
Data Report Issue
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:
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
Please find my Report Design. But I am unable to grouping. There is error message.
I didn't use Data Environment.
I request you to please help me to get the output like as above.
Thanks in advance.
Regards,
Aakash
-
November 25th, 2013, 07:09 AM
#2
Re: Data Report Issue
What is the error message and what line of code is throwing it?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|