• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Anyone know Crystal Reports?

BouncingSoul

Stranger Than Fiction
Political User
#1
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!

Thanks
 

Members online

No members online now.

Latest posts

Latest profile posts

Perris Calderon wrote on Electronic Punk's profile.
Ep, glad to see you come back and tidy up...did want to ask a one day favor, I want to enhance my resume , was hoping you could make me administrator for a day, if so, take me right off since I won't be here to do anything, and don't know the slightest about the board, but it would be nice putting "served administrator osnn", if can do, THANKS

Been running around Quora lately, luv it there https://tinyurl.com/ycpxl
Electronic Punk wrote on Perris Calderon's profile.
All good still mate?
Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,962
Messages
673,247
Members
89,019
Latest member
fontjohnson