CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2010
    Posts
    18

    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.

    Name:  Report Design.jpg
Views: 660
Size:  74.1 KB

    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

  2. #2
    Join Date
    May 2005
    Location
    Sterling Heights, MI
    Posts
    74

    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
  •  





Click Here to Expand Forum to Full Width

Featured