Search results for query: *

OK ... I tried the sub-report way and discovered that I can display the top 10 values in a subreport. The Grand Total of these 10 values however is incorrect when I remove the 'Others' checkbox of the TopN Expert. Instead, it gives me a subtotal of all values. I am using Crystal Reports 6.0...

Thanks for pointing me into the way of a resolution to this problem. I am new to crystal reports though. Any insights into how an array could be used? An example would be greatly appreciated!

I have a report that should not display in Top N format. I would like however, to be able to sum the Top 10 largest incomes from it, even though the report might display 100 employees. The top 10 sum would then be put at the end of the subreport. Is there any way to accomplish this?

I got the subreport to display the correct count of all records linked to the main report and to display only once in the details section of the Main report. Now, I would like to get the count of only certain records in the subreport, like so: count(activity_id) where activity_type = 'meeting'...

I am working on a subreport that reports out of a table and it has a subreport that includes a count function. All the fields are in the 'details' section of the main report, including the subreport. The subreport has a one-to-many relationship with the main table. My question is the...

I'm trying to run a MSSQL7 stored procedure just before a report is opened. Can anybody offer a solution on how this can be accomplished? Ideally, the user would open the report, the stored procedure would run and the data would then be reported. Can Crystal Reports do this out-of-the box...

I am trying to have the following MSSQL 7 query show up in Crystal Reports: select t.territory_name, c.company_name, co.city from company c, contact co, territory t where c.company_id = co.company_id and co.territory_id = t.territory_id and co.priority = '2A' and co.date_2a >= '2001-04-20' and...