Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rydexdba
  • Content: Threads
  • Order by date
  1. rydexdba

    Top N Sum

    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?
  2. rydexdba

    Count Function in Subreport

    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...
  3. rydexdba

    How do you run a stored procedure in Crystal Reports

    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...
  4. rydexdba

    SQL and Crystal Reports

    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...

Part and Inventory Search

Back
Top