Skip to main content
Database Administrators

Return to Question

added 7 characters in body; edited tags; edited title
Source Link
Joe Obbish
Joe Obbish
  • 32.6k
  • 4
  • 74
  • 153

SQL 2000 - How to retrieve subtotal for order lines (rollup does not exist in sql 2000)

Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order lines prices. But I wan't to make a parameter for the end user to select whether the price is > or < than a specific amount. And what I thought may be the best solution is calculate the subtotal in the stored procedure and pass it to the report to build the parameter off of. But it looks like SQL Server 2000 does not contain the "ROLLUP"ROLLUP function in later versions.

SQL 2000 - How to retrieve subtotal for order lines (rollup does not exist in sql 2000)

Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order lines prices. But I wan't to make a parameter for the end user to select whether the price is > or < than a specific amount. And what I thought may be the best solution is calculate the subtotal in the stored procedure and pass it to the report to build the parameter off of. But it looks like SQL 2000 does not contain the "ROLLUP" function in later versions.

How to retrieve subtotal for order lines (rollup does not exist in sql 2000)

Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order lines prices. But I wan't to make a parameter for the end user to select whether the price is > or < than a specific amount. And what I thought may be the best solution is calculate the subtotal in the stored procedure and pass it to the report to build the parameter off of. But it looks like SQL Server 2000 does not contain the ROLLUP function in later versions.

Source Link
tfenwick11
tfenwick11
  • 171
  • 6
  • 14

SQL 2000 - How to retrieve subtotal for order lines (rollup does not exist in sql 2000)

Currently in a crystal report I have each order grouped together where the user is displayed the order lines in the orders group. I have made a running total field for a subtotal for all of the order lines prices. But I wan't to make a parameter for the end user to select whether the price is > or < than a specific amount. And what I thought may be the best solution is calculate the subtotal in the stored procedure and pass it to the report to build the parameter off of. But it looks like SQL 2000 does not contain the "ROLLUP" function in later versions.