Anyone know Crystal Reports?

Discussion in 'Windows Desktop Systems' started by BouncingSoul, Dec 8, 2005.

  1. BouncingSoul

    BouncingSoul Stranger Than Fiction Political User

    Sioux Falls, SD
    God I hope so!

    Here is the deal. I have a sql statement, it runs in SQL Server Query analyzer just fine, the output is exactly as expected. If I load it into the command interpreter thing in Crystal 10 it outputs a report just like Query Analyzer. That's all well and good but my assignment is to use the Crystal 10 wizards to generate the report and use the SQL statement as a guide to selecting the tables and grouping the output. If I go through the wizards and select the tables and eveything I get a report that is kind of right but not entirely.

    What the query does is average out a persons spending and displays each person and their average. What the wizards do is show each and every transaction and the average below that. So what I need to do is eliminate the list of transactions and just show the averages. This is difficult to say so I hope its clear to whoever reads this. Any guidance would be extremely helpful!