Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-21 : 08:33:00
|
| Matt writes "I am trying to convert my MS Access reports into Crystal Reports. Domain Aggregate functions such as Dlookup and Dsum do not work in Crystal so I am trying to figure out a way to get the same effect by creating a view that Crystal can then use for the report. I have succesfully used a subquery to return a sum from a different table but it doesn't relate to each record, it returns the same value for all records. I am sure I need to link the subquery to each record in the main query but am unsure how to accomplish this. Thanks." |
|
|
|
|
|
Domain Aggregate Equivalents in T-SQL or Linking Subqueries to Main Queries