Search results for query: *

First - thank you for even taking the time to respond. An example of hoe I created the running total for group 3a Category 1: Field to Summarize: report field Category 1 Type of Summary : Sum Evaluate : For Each Record Reset : On Change of group - Group 3 I even...

The report should look like this : GH1 Region Name GH2 Team GH3 Team Member name Customer Name Catagory1 Catagory2 Catagory3 Totals GH4 Customer (Not Displayed) Detail (Not Displayed) GF4 Customer1 8 2 2 12 GF4 Customer2 7 1 1...

I used the top N group sort

Thank you for the response. That is what I have tried. The running totals are still summarizing all of the data - not just the top N. I should have included more detail. The detail section contain the client info that includes 4 categories. Each record has either a 1 or 0 for each of the...

I have a Top N report that has 4 groups: Region, Team, Team Member, and Client. The 4th group footer ranks the Clients in descending order based on the count of records for the client from the detail. I need to have seperate totals for each of the other footer sections; one with the sums of...

I had attempted to do exactly what you second point was. To create a no frills report with just to fields from the view. And no - no data was returned. Yet, I can still extract data from the view in either SQL Plus, Excel, or even BRIO.

Yep - every other table and view run just fine

The database is defined as an Oracle Server connection and all of the other views produce data.

Oracle 9i & Crystal reports XI. I have a new view that I am trying to select detail data from and the report does not return data. There are no filters or parameters. I can select from the view in SQL*PLUS, toad, Excel etc.... I can see all other views in the schema. I have been using...