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 Wanet Telecoms Ltd 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: M39Sthlm
  • Content: Threads
  • Order by date
  1. M39Sthlm

    Limiting number of rows in result

    Using Crystal Reports XI I have a report with a crosstab and a couple of charts. I need top N functionality to limit my result to last 10 rows (both in my crosstab and my charts). My SQL query is a simple select * from table In my crosstab I only have Columns and Summarized fields. Since I...
  2. M39Sthlm

    how to "set rowcount" in Crystal Reports XI?

    Hi, I'm building a report against sybase sql anywhere 8. I need a top N limitation to 10 in my query. I know that it works if using "set rowcount 10" before sql query and then "set rowcount 0" after. I have succesfully tried this in interactive sql, no problem But how do I implement this in...

Part and Inventory Search

Back
Top