Report Viewer - Groups

I have a SQL View that returns data formatted into a hierarchy of four
groups with values:

Grp1 Grp2 Grp3 Grp 4 Value
1 1 1 1 0.00
1 1 1 2 0.00
1 2 2 1 0.00
1 3 2 2 0.00
2 1 1 1 0.00
2 2 1 1 100.00
2 2 1 2 0.00
2 2 1 3 0.00
2 2 2 1 60.00
2 2 2 2 75.00

I need to show the values for each row within the group order. The report
has 4 groups from Grp1 to Grp4 with the value shown for each. However, when
running the report (and also in Crystal Reports), I get the values shown for
the higher order groups, e.g. the 100.00 amount for grouping 2111 also shows
on the report for Grp2=2, Grp2=2 and Grp3=1, as well as the correct 2 2 1 1
group.

I must be missing something regarding how groups are configured. A Microsoft
Access report based on the same SQL view reports correctly. Any help please?
Regards



.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: SCAN.EXE - McAfee AntiVirus Software
    ... > | of network computers and have only report summaries sent to be via ... > | Virus Scan Report File ... > | application RemoteProcessLaunch. ...
    (microsoft.public.security.virus)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Problems adding "All" to combo box
    ... SQL for each combo box is in a previous post). ... You have a report defined that is named AI Thru Hole Work Log_Operator ... of the report or form you want to filter ...
    (microsoft.public.access.formscoding)
Loading